VBA Copyfile with admin rights

[VBANewbie123]

Hi all

I have a simple line of code that doesnt work because I meed admin rights to place file there.

Anyone able to help me to resolve please?

File location to copy from:C:\Users\User1\Documents\Work\
Destination path: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup

Code:

FileCopy "C:\Users\User1\Documents\Work\AutoPrompt.vbs", "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup\AutoPrompt.vbs"

Thanks in advance

 

[sijpie]

Do you have admin rights for the PC?

If so you could start Excel with Admin rights.

if not, why do the files need to be in this directory?

Also note that from July 2016 Excel 2016 (and Excel 365) use different default directories.