Hi All,
I would really appreciate some advice on modifying the code below.
Is there a way to get it to save to any users desktop, for example if I send the file to a friend I would like to save to their actual desktop not the public desktop without having to change the code each time.
Also it seems to save the file with "desktop" at the beginning of the file name instead of just the text in cell C2.
As always thanks in advance.
Please Login or Register to view this content.
Last edited by JohnDoh; 05-19-2013 at 01:05 PM.
Play something with this.
Please Login or Register to view this content.
Kind regards, Harry.
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Nice short solution @patel45.
Would it also work on other international versions?
My previous Pc Desktop (The Netherlands) was called "Bureaublad".
I don't think so.
Last edited by HSV; 05-19-2013 at 01:17 PM.
Forgive my ignorance but i'm new to this ,what bit if code does this replace?Originally Posted by patel45
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by patel45; 05-19-2013 at 12:17 PM.
Hi, patel45,
could you please explain
againstPlease Login or Register to view this content.
why the brackets in the first line and why on earth a variable when a range could be used (as no Dim had been used)? And why the doubled up Filename?Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Last edited by HaHoBe; 05-19-2013 at 01:22 PM. Reason: code added
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks