Importing data from multiple worksheets in excel

[tuftee]

Is it possbile to import data from multiple worksheets at the same time?

[Lee Smith]

Hi

Are the worksheet names going to be consistent in their names (i.e. ABC.ws, DEF.ws, GHI.ws). If so, you could create an import script for each worksheet by first doing the import manually, and immediately creating a script (I would call the scripts Import ABC.ws, Import DEF.ws, and so on). Once you have each script set up, create another script that you can then attach a button to that runs all of the other scripts as subscripts. If you set them all up to run without dialog it will appear to be all at once.

HTH

Lee