Need Comand line or VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Run program on save/close 3
DOS..BAT VB Progamming problem 3
Search Macro or VB script 2
Run file from VB in Excel 4
Excel 2007 printing does not scale properly 5
2007 VB Controls Backwards Compatibility 4

Back
Top