I have this code on the opening of a database, it checks the version and if not up to date it downloads and runs an installer for the current version: -
Dim Fso As New FileSystemObject
Fso.CopyFile "\\Server\Share\Install.exe", "C:\Folder\Install.exe", True
Shell "C:\Folder\Install.exe", vbNormalFocus
This was working fine but now I get "invalid procedure call or argument"
If I just navigate to the .exe and run it works fine. If I copy the code to a fresh database it runs fine. Can anyone help?