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?

You could add the code to Workbook_Open, it will then automatically run when
you open the workbook


Private Sub Workbook_Open()

End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"DannyS" wrote in message
...
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?

Maybe put a InputBox in the WorkbookOpen macro and it will pop-up and ask for
user to input a MacroName as the file is opened............

Vaya con Dios,
Chuck, CABGx3




"DannyS" wrote:

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?