|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
05-24-2009
| #1 (permalink) |
| | Re: how to send command to a workbook excel wich is open Michel Angelosanto schreef: Quote: > in a script vbs i try to use getobject instead of createobject, because > my workbook is already open but it does not work. > Do you know how to use an open window Excel/workbook/sheet ? > > Dim xlapp, classeur, feuille > > Set xlapp = getObject("Excel.Application") > xlapp.Visible = True > Set classeur = xlapp.activeWorkbook > Set feuille = xlapp.ActiveSheet > feuille.Range("A1") = "Put text here in A1 for testing" > Classeur.Saveas "c:\tmp\MonClasseur" > classeur.Close True 'quitte en sauvant > > xlApp.quit > Set classeur = Nothing > Set xlapp = Nothing > > -- Luuk |
My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| excel workbook error / office standard 07 | Microsoft Office | |||
| Copying one worksheet from one excel 2007 workbook to another work | PowerShell | |||
| Excel and Powershell Open Workbook with Multiple Sheets | PowerShell | |||
| COM. Can't open an Excel workbook | PowerShell | |||
| Vista ASP.NET 2.0 Cannot open Excel File using Microsoft.Excel 12.0 COM object | Microsoft Office | |||
