Search : in
By :

VBA to print and replace....

Last answer on Oct 10, 2009 3:27:26 pm BST PM, on Oct 9, 2009 9:52:14 am BST 
 Report this message to moderators

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

Configuration: Windows XP Internet Explorer 6.0
Excel 2003

Best answers for « VBA to print and replace.... » in :
[VB6/VBA] The CommonDialog control Show [VB6/VBA] The CommonDialog control The available functions with CommonDialog Getting started An example of a standard module The various functions of control CommonDialog Here is a list of all the available constants,although...
Find and Replace a Range on Excel Show
EXCEL Macro - Find and replace function -Help Show
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Epson parts inside your printer are at the end of their life ShowEpson – parts inside your printer are at the end of their life After a certain period of time and of consequent use of your printer, you may have come across the error message parts inside your printer are at the end of their life. In...
VBA: Finding Hdc in an Excel worksheet or UserForm ShowVBA: Finding Hdc in an Excel worksheet or UserForm Here are two small examples on how to find Hdc in a worksheet: By clicking on Sheet1 the UserForm is displayed. Put the pointer on UF, hold the left mouse button down and drag the...
Download Printer Driver Laser HP LaserJet 4345xs Show
Download HP Universal Print Driver (UPD) PCL ShowThe HP UPD drivers (Universal Print Driver) are compatible unified drivers with all the printers of the range of HP LaserJet and HP Color LaserJet. Alternative spelling: HP universal print driver, HP UPD, HP universal printing pcl.
Download Printer Driver HP LaserJet P4015x Show
The Printer ShowPrinters The printer is a peripheral that allows you to make a print-out (on paper) of computer data. There are several printer technologies, the most common of which are: the daisy wheel printer the dot-matrix printer (also called impact...
Quoted-printable encoding ShowQuoted-printable encoding Quoted-printable encoding (somtimes QP) involves using US-ASCII 7-bits encoding (non-accented letters) to encode a text that requires an alphabet of 8-bit characters (accented letters), such as ISO-Latin-1, which is used...
Ask your question Reply

1

 sharpman, on Oct 10, 2009 3:27:26 pm BST
   
Reply to sharpman
Ask your question Reply
They need your help