I currently use the following VBA code to import and export the database to excel to make a backup copy:
and
On this form, I have four text boxes that the user can input their own path and file name:
Import: IFileLocation and IFileName
Export: EFileLocation and EFileName
Is there a way to be able to use these text boxes in an import/export VBA code?
Thank you for reading,
-Huey
Code:
DoCmd.RunSavedImportExport ("Backup Export")
Code:
DoCmd.RunSavedImportExport ("Import Backup")On this form, I have four text boxes that the user can input their own path and file name:
Import: IFileLocation and IFileName
Export: EFileLocation and EFileName
Is there a way to be able to use these text boxes in an import/export VBA code?
Thank you for reading,
-Huey
