Calling Access VBA subroutine from an Excel VBA subroutine

[richard_yolland]

Hi



Does anbody know how to do this?

I've written a Sub bulk_import() routine in a module called Module1 in Access VBA.

I'm using an Excel file (of about 20,000 rows and 50 columns) as the source of the data to import, and I have Excel VBA code (in Excel 2002) which performs various operations on the file.

Now, essentially, when the Excel VBA code has finished running on the Excel file, I would like it to run the Access VBA code which basically just does a DoCmd.TransferSpreadheet acImport and hence does a bulk import of the Excel data.

Is this possible?

Thanks

Richard