BrianCP
01-15-2016, 12:57 PM
How can I return the desktop path?
I have a macro that imports and parses a desktop text file in Excel. The macro is tied to a button within a macro workbook which will be distributed to other users that have different desktop addresses than mine. Hence, they either would have to change the VBA script manually - not desirable, or possibly I can run some script that will return the desktop path?
Please advise.
Thanks!
Brian
I have a macro that imports and parses a desktop text file in Excel. The macro is tied to a button within a macro workbook which will be distributed to other users that have different desktop addresses than mine. Hence, they either would have to change the VBA script manually - not desirable, or possibly I can run some script that will return the desktop path?
Please advise.
Thanks!
Brian