Need Comand line or VB Script

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

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
Comand line or Vb 0
Refresh Bloomberg data in an excel file from a script 4
Search Macro or VB script 2
Passing SQLPlus script location using Windows Script Host Object Model 11
Run program on save/close 4
Drag-n-Drop_XLA_Install (VB Script) 0

Top