Thread: Copying sheet from file round 2!!!
View Single Post
 
Old 01-21-2021, 07:45 PM
SoMany SoMany is offline Windows 7 64bit Office 2016
Advanced Beginner
  
Join Date: Oct 2016
Posts: 51
SoMany is on a distinguished road
Default
Quote:
Originally Posted by Purfleet View Post
Hi SoMany

Try uzer = Environ("Username")

before the filename assign

Or ,ideally, use a network drive location it will probably be more reliable

That did the trick. Thank you.
Reply With Quote