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.

--
Regards,
Tom Ogilvy


"Michael Vaughan" <michael@mvaughan.net> wrote in message
news:aLSdnVGNKMbkxCzenZ2dnUVZ_sednZ2d@comcast.com...
> 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
>
>

[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


"Michael Vaughan" <michael@mvaughan.net> wrote in message
news:aLSdnVGNKMbkxCzenZ2dnUVZ_sednZ2d@comcast.com...
> 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
>
>