Michel Angelosanto schreef:http://www.microsoft.com/technet/scr...in/ss0406.mspx
> 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
Re: how to send command to a workbook excel wich is open
- 24 May 2009 #1
Luuk GuestMy System SpecsRe: how to send command to a workbook excel wich is open
Re: how to send command to a workbook excel wich is open
| Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| excel workbook error / office standard 07 | eurosid | Microsoft Office | 0 | 13 Dec 2008 |
| Copying one worksheet from one excel 2007 workbook to another work | jgiddyup | PowerShell | 2 | 04 Dec 2008 |
| Excel and Powershell Open Workbook with Multiple Sheets | OldDog | PowerShell | 11 | 26 Aug 2008 |
| COM. Can't open an Excel workbook | =?Utf-8?B?Um9tYW4gS3V6bWlu?= | PowerShell | 12 | 08 May 2008 |
| Vista ASP.NET 2.0 Cannot open Excel File using Microsoft.Excel 12.0 COM object | ckellywilson | Microsoft Office | 0 | 26 Mar 2008 |
