Printing

N

nath

Hi,

I am running a module whilst i am not in the office each
evening. It creates a log to a text file of what has
happened and how it went i.e. Success/Fail.

How do i open this text file and print it once the module
is complete?

TIA

Nath.
 
B

BrianB

make sure the file suffix is .txt and use File/Open (perhaps .csv wil
work ?)

Go from ther
 
T

Tom Ogilvy

workbooks.open "C:\MyLogs\Myfile.txt
ActiveSheet.Printout
ActiveWorkbook.Close SaveChanges:=False
 
N

Nath

-----Original Message-----
make sure the file suffix is .txt and use File/Open (perhaps .csv will
work ?)

Go from there


---


.
Hi there,
Click to expand...

I was enquiring about how to print with code, so it is
printed when i come in in the morning.

Is this possible.

Thanks

Nathan.
 
Top