Recent content by aetiger

Unfortunately I am getting a compile error of "Sub or Function not defined" when I attempt that method. Is GetOpenFile a function in Access2003?

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel2003, "FY07", "C:\FY07.xls", True How do I replace "C:\FY07.xls" with a user-selected excel file so that it doesn't always have to be located in the same path using the same file name?

I am trying to do something similar. I want the user to click a button in a form, and then select the excel file to import. I created the basFunctions module, but I am very new to VBA, so I am unsure how to reference that module in the TransferSpreadsheet command. Thoughts?