Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open File Location
How can I rewrite this code to open a file named "invoice", in case I move
the workbook to another directory. T.I.A. Workbooks.OpenText Filename:= _ "C:\Documents and Settings\Owner\My Documents\\Project\Summary\Test_Macro\invoice" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open File Location
properties wrote:
How can I rewrite this code to open a file named "invoice", in case I move the workbook to another directory. Workbooks.OpenText Filename:= _ "C:\Documents and Settings\Owner\My Documents\\Project\Summary\Test_Macro\invoice" Workbooks.OpenText Filename:= _ "C:\newdirectory\invoice" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open File Location
You either need to
- know the directory name - get the path of the activeworkbook - get the path of thisworkbook - use GetOpenFilename to browse for the file. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "properties" wrote in message ... How can I rewrite this code to open a file named "invoice", in case I move the workbook to another directory. T.I.A. Workbooks.OpenText Filename:= _ "C:\Documents and Settings\Owner\My Documents\\Project\Summary\Test_Macro\invoice" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open File Location
cucchiaino wrote:
properties wrote: How can I rewrite this code to open a file named "invoice", in case I move the workbook to another directory. Workbooks.OpenText Filename:= _ "C:\Documents and Settings\Owner\My Documents\\Project\Summary\Test_Macro\invoice" Workbooks.OpenText Filename:= _ "C:\newdirectory\invoice" Oops! Move you the workbook? Not rewrite!! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open File Location
Sorry I didn't make my question clear. I want to write this code so that
regardless of where I put this workbook it will look to open the file in the directory where the workbook exists. "cucchiaino" wrote in message ... properties wrote: How can I rewrite this code to open a file named "invoice", in case I move the workbook to another directory. Workbooks.OpenText Filename:= _ "C:\Documents and Settings\Owner\My Documents\\Project\Summary\Test_Macro\invoice" Workbooks.OpenText Filename:= _ "C:\newdirectory\invoice" |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open File Location
Use something like
Workbooks.Open ThisWorkbook.Path & "\Invoice.xls" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "properties" wrote in message ... Sorry I didn't make my question clear. I want to write this code so that regardless of where I put this workbook it will look to open the file in the directory where the workbook exists. "cucchiaino" wrote in message ... properties wrote: How can I rewrite this code to open a file named "invoice", in case I move the workbook to another directory. Workbooks.OpenText Filename:= _ "C:\Documents and Settings\Owner\My Documents\\Project\Summary\Test_Macro\invoice" Workbooks.OpenText Filename:= _ "C:\newdirectory\invoice" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel will not open in default file location | Excel Discussion (Misc queries) | |||
Open Last Modified File form Location | Excel Discussion (Misc queries) | |||
VBA to ask for file location and use to open DB | Excel Worksheet Functions | |||
Open File from FTP Location | Excel Discussion (Misc queries) | |||
Open From Read-Only Location ? | Excel Discussion (Misc queries) |