CSV to Excel to print daily report. How to set default printin mar

[-K- The One And Only]

Hello,
I have a program that needs to generate reports on a daily basis.
It:
1. Runs Excel
2. Opens XXX1.csv
3. Prints from Excel
4. Exit from Excel
I would like to set default Printing Margins from Excel.
How do I achieve this?
Are there any other ways besides setting a default customized template for
when Excel starts up?

Thank you,
-K-

 

[JE McGimpsey]

Oh, I forgot to mention that the csv filename gets replaced everyday. For
instance, on monday it would be XXX1.csv , on tuesday it would be XXX2.csv
and so on..

Would it then reset to xxx1.csv the following Monday?

 

[-K- The One And Only]

Would it then reset to xxx1.csv the following Monday?

-----------------------------------------------------------------------

Well, the program has just been modified. How it works now is that, the CSV
filename remains the same, however it will be overwritten everyday when
printing.

Thanks,
-K-

 

[JE McGimpsey]

Well, the program has just been modified. How it works now is that, the CSV
filename remains the same, however it will be overwritten everyday when
printing.

That makes things much easier - just record a macro in which you read in
the CSV file, set the margins, and print.

Reading the CSV file via Data/Get External Data/Import text file... will
give you options for how each column is to be interpreted.

 

[-K- The One And Only]

That makes things much easier - just record a macro in which you read in
the CSV file, set the margins, and print.

Reading the CSV file via Data/Get External Data/Import text file... will
give you options for how each column is to be interpreted.

-------------------------------------------------------------------------------

Thank you for your help so far.

I manage to record a macro and save it as a personal one, so all I have to
do now is to get my program to run excel, and run the macro right?

s there a default code to call the macro, or does it differ depending on the
program that I am using?

Thanks,
-K-