How to save file dynamically in My Documents directory which is in D drive?

[bunty_1244]

Hi Guys,

I have some line of code that works best for my machine as I have "My Document" directory in C drive. Now that I have been given a new laptop in which my macro doesn't work because here directory in D drive. Below is the error message:

Error.png

When I click on "My Document" folder of my D drive I get this path: D:\UserData\PAREKHKE\Documents. I am running Windows 7 Enterprise.

How do I tweak the code? Please help I have created a nice macro and everything is working fine except this - driving me crazy

I appreciate your time!!

Best,
Bunty

[Olly]

Change the bit of code that says

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

(and please, in future, post your code as text, not as a picture!)

[bunty_1244]

Thanks for the prompt reply Olly, and please accept my apology I would make sure to paste the code as text moving forward.

I have tried changing it and it gave me run time error saying that "This extension cannot be used with the selected file type." hence I changed the code like below:-

Please Login or Register  to view this content.

I think the "Environ" function taking the default directory as C drive which is the problem.

[Olly]

That code works for me - albeit with the prompt to remind you that macros will not be saved, using this file type...

What's the error you are getting, with the modified code?

[bunty_1244]

The macro worked for you may be because you have "My Document" directory in C drive, in my case it is in D drive (D:\UserData\PAREKHKE\Documents) The Environ function is looking for path in C drive in my case. Below if the error message:

Run-time error "1004":
Microsoft excel cannot access the file
C:\Users\PAREKHKE\Documents\CD339000