philfer
05-14-2010, 04:41 AM
Hello,
I am trying to save a database in vba but having some problems.
When the user open the previous months database and enters a new run date I use a FileSystemObject to create a new folder for that date and want to then use saveas to save the database in that folder.
I have tried
Set myDB = CurrentDb
MyDB.SaveAs
but it doesnt work
Any help??
Also, I use CreateObject to create a scripting object to create the folder, how do I remove the object from memory after I'm done?
Is it just Set fso=Nothing
Cheers guys
Phil
I am trying to save a database in vba but having some problems.
When the user open the previous months database and enters a new run date I use a FileSystemObject to create a new folder for that date and want to then use saveas to save the database in that folder.
I have tried
Set myDB = CurrentDb
MyDB.SaveAs
but it doesnt work
Any help??
Also, I use CreateObject to create a scripting object to create the folder, how do I remove the object from memory after I'm done?
Is it just Set fso=Nothing
Cheers guys
Phil