For example, I want to open the spreadsheet W.xls, and run the macro x()

I really want a string that looks something like

C:\Spreadsheets\W.xls #x#

That will open W.xls then run x()

Is this possible?