| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open another WorkBook
In excel VB for Apps how to open another workbook if the path is unknown
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open another WorkBook
Function GetOpenFilename([FileFilter], [FilterIndex], [Title], [ButtonText],
[MultiSelect]) of Excel.Application regards r Il mio ultimo lavoro ... http://excelvba.altervista.org/blog/...ternative.html "JB" wrote: In excel VB for Apps how to open another workbook if the path is unknown |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open another WorkBook
you can use the GetOpenFileName() method -- read HELP on this as it is
quite useful Dim FileToOpen As String ChDrive "D" ' not required here. but enables you to get the dialog box looking somewhere.. FileToOpen = Application.GetOpenFilename "JB" wrote in message ... In excel VB for Apps how to open another workbook if the path is unknown |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open another WorkBook
Patrick, what I have going on is the user clicks button on the current
worksheet. The code will copy three numbers from that worksheet. Open the other workbook (target) and pasts the data into that workbook. If the user has moved the target workbook or has navigated away from the directory it is in my code Workbooks.Open Filename:= "Target.xls" does not work because it needs the path. "Patrick Molloy" wrote: you can use the GetOpenFileName() method -- read HELP on this as it is quite useful Dim FileToOpen As String ChDrive "D" ' not required here. but enables you to get the dialog box looking somewhere.. FileToOpen = Application.GetOpenFilename "JB" wrote in message ... In excel VB for Apps how to open another workbook if the path is unknown |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open another WorkBook
If you mean to open other workbooks from the same path of the currently
opened file use... Workbooks.Open ActiveWorkbook.Path & "\filename.xls" If this post helps click Yes --------------- Jacob Skaria "JB" wrote: In excel VB for Apps how to open another workbook if the path is unknown |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open another WorkBook
Worked like a charm. Sometimes you cannot see the trees for the forest.
"Jacob Skaria" wrote: If you mean to open other workbooks from the same path of the currently opened file use... Workbooks.Open ActiveWorkbook.Path & "\filename.xls" If this post helps click Yes --------------- Jacob Skaria "JB" wrote: In excel VB for Apps how to open another workbook if the path is unknown |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
| Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation | Excel Programming | |||
Hybrid Mode
