Excel

[FoxStudent]

could some one solve this problem for me!!!
I have a technical problem with Excel. I have got it all working quite
well. Part of the process is to load a second worksbook that contains
all the stored files.
Is there a way of loading it using some simple letters, just simply
looking at the same folder where the first workbook is stored.
At the moment I load it using the whole pathway starting from C.
This will cause problems when I try to get others to try it out.

thank u

 

[RobBroekhuis]

I think what you're looking for is the

ThisWorkBook.Path

property. You can use it to construct the full path-filename of any related files in the same folder.
Rob

 

[Mossoft]

If you need to process all the workbooks in a directory.....

Dim strFileName As String

strFileName = Dir(<path of files> & &quot;\*.XLS&quot;, vbNormal)

While strFileName <> vbNullString
'<open and process workbook indicated by strFileName>

strFileName = Dir
Wend

M