Question: loading a file into a Object?
 

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

Question: loading a file into a Object?
 

Look at excel vba help on the shell command.

--
Regards,
Tom Ogilvy


"Michael Vaughan" wrote in message
. ..
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

Question: loading a file into a Object?
 

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


"Michael Vaughan" wrote in message
. ..
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