VBA Access Compile Error variable not defined
I have this script that I want to use to move folders for archive this is
my code
Public Function modbalsmovearhive()
Set FSO = CreateObject("Scripting.FileSystemObject") FSO.MoveFile
"H:\Credit_Bals*.xls", "H:\Bals_Archive\"
End Function
Now when I go to run it I get the Compile Error variable not defined. Can
someone assist me with the best way to resolve this error. Thanks
No comments:
Post a Comment