Good Morning!
I'm trying to make an auto Normal.dotm copy file routine when I open a excel file because sometimes i lost my saved macros. Since the file Normal.dotm has all the macros saved seems to me a good idea to save it from time to time.
The code is the follwing
Private Sub Workbook_open() Dim a As Integer a = Range("A1").Value + 1 Range("A1").Value = a FileCopy "C:\Users\njesus\AppData\Roaming\Microsoft\Templates\Normal.dotm", "C:\Users\njesus\Dropbox\Setcontrol\VBA\Normal" & Range("A1").Value & ".dotm", strDBLocation End Sub
When the macro runs i'm getting the error:
"Compile error
Wrong number of arguments or invalid property assignment"
maybe because of the Windows folder properties.
Also i don't have Administrator rights because it is my work desktop
Is there a better way to solve it?
Regards