How do I reference a file in a macro that is in the same folder, so instead of C:/something/sometigng/abc/ababab/"files are in here" it uses /"files are in here" , the same folder, as the drive letter changes.
How do I reference a file in a macro that is in the same folder, so instead of C:/something/sometigng/abc/ababab/"files are in here" it uses /"files are in here" , the same folder, as the drive letter changes.
Last edited by frank35; 11-18-2013 at 03:15 PM.
The Path attribute will provide the path name of a workbook. ThisWorkbook is the workbook containing the macro being run.
So to refer to file "myfile.xlsx" in the same folder as the file with the macro:
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks