Environ UserProfile

[Dryver14]

Hi

When I try to operate this line of code

.ActiveDocument.SaveAs2 Environ("UserProfile") & "\ThisPC\Desktop\Movie Report.docx"

I cant get it to go to desktop. It should be \desktop......I have tried putting \thisPC in to help the situation.

essentially it opens a save file dialog box in the onedrive folder and stops waiting for me to select a location.

I think part of the problem is that userprofile only identifies user.

I am sure I have seen somewhere that I can change this somewhere in the system and I would appreciate being advised through this procedure,
I have a concern that should I ever try to write code for someone else it would stall for them too.

 

[Macropod]

Try:

.ActiveDocument.SaveAs2 "C:\Users\" & Environ("UserName") & "\Desktop\Movie Report.docx"

 

[Dryver14]

Thanks

But it still takes me to the Onedrive folder, I don't even use onedrive...GRRR

 

[Macropod]

Not when I use it ...

 

[Dryver14]

I have tried allsorts even the full path without environ

.ActiveDocument.SaveAs2 "C:\user\owner\Desktop\Movie Report.docx"

 

[Dryver14]

I am not ignoring any response......Bed time.

Look forward to any assist tomorrow, thanks