Search found 2 matches
- Thu Aug 02, 2012 7:24 pm
- Forum: Scripts and Tips
- Topic: Automate Excel with VBScript
- Replies: 3
- Views: 37206
- Wed Jul 25, 2012 4:28 pm
- Forum: Scripts and Tips
- Topic: Automate Excel with VBScript
- Replies: 3
- Views: 37206
Re: Automate Excel with VBScript
Contributed By: Marcus Tettmar mtettmar@mjtnet.com Submitted On: 21/02/03 VBSTART Sub ExcelExample Dim xlApp Dim xlBook Dim xlSheet Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Add Set xlSheet = xlBook.Worksheets(1) xlApp.visible = True 'optionally make the sheet visib...