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
Per Jessen - 25 Jan 2008 13:08 GMT
> Hi,
>
[quoted text clipped - 10 lines]
> 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
Richard - 25 Jan 2008 14:25 GMT
Fantastic thanks
> > Hi,
> >
[quoted text clipped - 22 lines]
>
> Per