Hi again all.
I am using the code below to save a worksheet to my desktop, which is working fine. Is there a way to change the path, so that it will copy/save to any computers' desktop? Thank you so much for any help.
Please Login or Register to view this content.
Last edited by fremarco; 07-20-2012 at 10:59 AM. Reason: Code tags not quote tags.
Like this
Please Login or Register to view this content.
Thanks Kyle. What if I only want to save/copy the worksheet only?
Last edited by Cutter; 07-20-2012 at 11:33 AM. Reason: Removed whole post quote
Just use the above to set your strfpath variable instead of your fixed string and th usevyourcode as it is
Thanks again Kyle. The code works fine but can it be saved to a specific folder on the desktop (i.e pending) Sorry for taking so long to answer but wife wanted to go out...as they do. Cheers.
Yes, of course, but you should check that the folder exists first:
Please Login or Register to view this content.
great! thanks a bundle Kyle
no probs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks