| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable File Name Activation
Fantastic thanks
"Per Jessen" wrote: "Richard" skrev i en meddelelse ... Hi, When running a query from a proprietry system, the rusltant file is opened with a name of, for example, default(1).xls The file is opened as a temp internet file and therefore the file name could be, for example, default(2).xls From a file called, for example, myfile how do I activate the default file when the default file name is variable. Thanks in Advance Richard Hi Richard You can find the filename of the file using this code after the file is opened (and before other files are opened). wb = Workbooks.Count TempFile = Workbooks(wb).Name regards, Per |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| activation key | Excel Discussion (Misc queries) | |||
| Macro Activation | Excel Programming | |||
| PASSING VARIABLE TO .xlT FILE FROM .xlA FILE (CONTAINS 'Auto_Open' PROCEDURE) | Excel Programming | |||
| implicit activation | Excel Programming | |||
| UserForm Activation | Excel Programming | |||
Threaded Mode
