VBA to print and replace....

Closed
PM - Oct 9, 2009 at 04:52 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Oct 10, 2009 at 10:27 AM
Hello,

I use the below code to open a .lst file in notepad, what i need to know is how i can print this file using vba?

code:

RetVal = Shell("C:\WINDOWS\notepad.exe K:\Output\Data.lst")

This code opens the file in notepad, however how do i get it to print?

Also if anyone is able to tell me the code on how i can replace a letter on the new notepad file created and then print then that would be great!!

thanks in advance

PM

1 response

sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Oct 10, 2009 at 10:27 AM
have a look here for some ideas on your problem
https://www.itprotoday.com/data-analytics-and-data-management
1