Need Comand line or VB Script

  • 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
 
For vBscript, use automation.

http://support.microsoft.com/?id=167223
OFF97: Microsoft Office 97 Automation Help File Available (Q167223)

http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available (Q260410)

http://support.microsoft.com/support/kb/articles/Q184/2/73.ASP
ACC97: How to Use Automation to Create a Microsoft Excel Chart

http://support.microsoft.com/support/kb/articles/Q210/1/48.ASP
ACC2000: Using Automation to Create and Manipulate an Excel Workbook
 

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 1
comand line 2
Refresh Bloomberg data in an excel file from a script 4
Run program on save/close 3
Search Macro or VB script 2
VB script 3
Run file from VB in Excel 4
copy excel 4

Back
Top