Can anyone describe ALL the various functions or methods for loading a spreadsheet using VBA code?

I think there's a Workbook.open() command. But what about using something like: Shell("excel.exe file.xlsm", vbNormalFocus")???

Are there any other methods? Is any method better than the other(s)?

-Robert

Can anyone describe ALL the various functions or methods for loading a
spreadsheet using VBA code?

I think there's a Workbook.open() command. But what about using something
like: Shell("excel.exe file.xlsm", vbNormalFocus")???

Are there any other methods? Is any method better than the other(s)?

-Robert

Workbooks.Open() is the best way to load a file into your running instance of
Excel because it exposes options to you for doing so.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion