Attention: TDR Forum Junkies 
All I want to do is make MS Excel a print engine for my reports. I pass it a CSV file and want it to print it then close without questions.
I can't figure out which module(?) to put the code in, in the VBA editor? Not in the thisworkbook "Worksheet_open" module. This displays an empty report. I tried the sheets1 module "worksheet_calculate" and it prints most of the report, but misses some of the data (report date, title. . ) eradically (the empty data changes each time you open the spreadsheet. )
Where/what module/object/procedure can I put my print and close code so that it first, completes loading all my data, second automatically runs my code? Any help is appreciated. I've looked in VBA Unleashed, VBA help files, MS knowledge base...
Using Win98SE, Excell 2000 standard ed...
Thanks,
Pat
------------------
2001. 8 White Sport RAM 2500HD QC SLT 4X4 LB 3. 54 LSD Cummins Auto
My Ram Page
1999 21' Terry Lite Towable 5400# GVW
1990 Kawasaki KLR 250 Enduro
I can't figure out which module(?) to put the code in, in the VBA editor? Not in the thisworkbook "Worksheet_open" module. This displays an empty report. I tried the sheets1 module "worksheet_calculate" and it prints most of the report, but misses some of the data (report date, title. . ) eradically (the empty data changes each time you open the spreadsheet. )
Where/what module/object/procedure can I put my print and close code so that it first, completes loading all my data, second automatically runs my code? Any help is appreciated. I've looked in VBA Unleashed, VBA help files, MS knowledge base...
Using Win98SE, Excell 2000 standard ed...
Thanks,
Pat
------------------
2001. 8 White Sport RAM 2500HD QC SLT 4X4 LB 3. 54 LSD Cummins Auto
My Ram Page
1999 21' Terry Lite Towable 5400# GVW
1990 Kawasaki KLR 250 Enduro
Last edited by a moderator:
