Printing

[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.

 

[BrianB]

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

Go from ther

 

[Tom Ogilvy]

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

 

[Nath]

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

Go from there


---
Message posted

.
Hi there,

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.