Hello everyone! I am hoping someone can help me figure this out. The codes below saves my worksheet as a text delimited file on my desktop. Specifically it is used to remove the quotations around values that have commas in them. The problem I am having is that the code only works on my machine because the file path is directly referencing MY desktop. I need to alter this to work on anyone's machine. Any help will be much appreciated! Thank you!
Please Login or Register to view this content.
Hello,
This link might help:
http://stackoverflow.com/questions/1...rdless-of-user
Based on that, you could use :
Please Login or Register to view this content.
GC Excel - My blog
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Thank you GC Excel!! I got it to work using your suggestion. Perfect!
Hello, any idea how to have in names destination the current date and hour as well?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks