 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008Open a sheet from other Excel file
Hi there, is there a way to open, by Excel vba code, another Excel file and naviagate in the sheets and cells ? From which other 'language' can i navigate in the cells of a Excel file ? Thanks -- SteM YOU CAN USE AN INPUTBOX Sub testa() fileToOpen = Application _ .GetOpenFilename("Excel Files (*.xls), *.xls") If fileToOpen <> False Then Workbooks.Open Filename:=fileToOpen Set myRange = Application.InputBox(prompt:="Sample", Type:=8) End If End Sub > Hi there, > is there a way to open, by Excel vba code, another Excel file and naviagate [quoted text clipped - 5 lines] > -- > SteM Thanks, but after the open, how can i refer to a Cell of that sheet ? -- SteM > YOU CAN USE AN INPUTBOX > [quoted text clipped - 18 lines] > > -- > > SteM Look at the code. Myrange is the seelcdted cell(s). > Thanks, > but after the open, how can i refer to a Cell of that sheet ? [quoted text clipped - 25 lines] > > > -- > > > SteM |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.