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