Putting Excel file in Windows startup folder with VBA

[hasanlianar]

Hello,

I need help with VBA code to put file to Windows Startup folder so that the file is open-ed automatically on every Windows start up.

Thank you,
Anar

 

[Jake Blackmore]

This video seems quite comprehensive https://www.youtube.com/watch?v=7j1VRyadTyw
Jake

 

[hasanlianar]

Thank you,

But, the video is about Excel Startup folder, not Windows Startup folder.

This video seems quite comprehensive https://www.youtube.com/watch?v=7j1VRyadTyw
Jake

 

[shg]

Maybe ...

  FileCopy Source:="C:\myPath\MyFile.ext", _
           Destination:=CreateObject("Wscript.Shell").SpecialFolders("Startup") & "\"

 

[hasanlianar]

Thank you, shg

I am not that proficient in VBA, could you state a more complete answer?

Maybe ...

  FileCopy Source:="C:\myPath\MyFile.ext", _
           Destination:=CreateObject("Wscript.Shell").SpecialFolders("Startup") & "\"