I have the Excel App and Work book defined as global objects.
I am in a function where I need the full path to the workbook.
msgbox xlwb.name gives me the name of the WB.
I thought that I remember seeing something such as fullname to get the entire path. Can someone remind me how to get this please?
When in Florida, Don't Tampa with the code. I made this up.
Not at a pc Kevin but if you watch the xlwb object does it give you a field with the path value in.
Quite often I will use the Excel VBA IDE for this kind of research.
These might work.
I will also what the xlwb object.
Returns the name of the object, including its path on disk, as a string. Read-only String."
... just another Tester ...
Information is appreciated.