Limitations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am planning to import a large number of excel speadsheets using macros at
certain times of the month.

Is there a limitation to how many spreadsheets any one macro can handle at
any one time?

Thanks
 
Check Access HELP, searching for "specifications" to see the maximum number
of steps a macro can contain.

Or you could look into using VBA and creating a procedure that imported the
spreadsheets.

Do you actually mean "import" (make a copy in Access), or are you looking at
linking to (i.e., "looking at") the spreadsheets?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top