VBA to print and replace....

[Closed]
Report
-
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
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 reply

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
have a look here for some ideas on your problem
https://www.itprotoday.com/data-analytics-and-data-management
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month