Question: loading a file into a Object?

  • Thread starter Thread starter Michael Vaughan
  • Start date Start date
M

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
 
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
 
Back
Top