Wednesday, 21 August 2013

VBA Access Compile Error variable not defined

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