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