Need Comand line or VB

C

Chris

Hello ,

I am looking for a command line I can run in a batch file or a VB script
that I can open a excel file (name_todays Date.XLS) add to it , Print
Portrait, fit to one page wide, Legal, and to print gridlines, then save the
settings then close out of excel.


Any help would be so appreciated.

Chris
 
T

Tom Ogilvy

you would have to open a workbook that has code in the workbook open event
to do all that.

then the command would be

Excel.Exe "C:\Myfolder\Trigger.xls"

as an example.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Comand line or VB Script 1
comand line 2
Comand line or Vb 0
Problem with SET & REF function 0
Run program on save/close 4
Excel - BREAK in macro/VB 1
2007 VB Controls Backwards Compatibility 4
EOF behaviour 1

Top