Question: loading a file into a Object?

[Michael Vaughan]

Hello Everyone,

I inserted an object into my Excel workbook. It will boot up my NOTEPAD.EXE
program. Is there a way to execute it and have it automatically load a file
name into Notepad??? I want to execute notepad, and then automatically load
a .bat file into it so that I can edit it.

Hope you can help... Michael

 

[Tom Ogilvy]

Look at excel vba help on the shell command.

 

[Chip Pearson]

Use the Shell statement.

Shell "notepad.exe 'h:\test\text.txt'", vbNormalFocus



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com