Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
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.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - Openning XL I get a Run Time error 1004

Reply
 
Old 03-10-2009   #1 (permalink)
Bobby


 
 

Openning XL I get a Run Time error 1004

Hi,

Running the following code I get a Run time error. I understand the
reason(the module that I want to execute is in my personal.xls) but
don't know how to fix it!
Thank you for your support.

Option Explicit

dim app,workbook,objWMIService,colProcessList,objShell
dim strComputer, objProcess

strComputer = "."

Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" _
& strComputer & "\root\cimv2")

Set colProcessList = objWMIService.ExecQuery _
("Select * from Win32_Process " _
& "Where Name = 'Excel.exe'")

For Each objProcess in colProcessList
'WScript.Echo "Excel est terminé" 'Pour Debuggage
objProcess.Terminate()
Next

Set app = CreateObject("Excel.Application")

Set workbook = app.Workbooks.Open("D:\Robert\DOCUMENT\XLS\Budget" &
Year(now) & ".xls")


My System SpecsSystem Spec
Old 03-10-2009   #2 (permalink)
Bobby


 
 

Re: Openning XL I get a Run Time error 1004

On Mar 10, 8:09*pm, Bobby <rpq...@xxxxxx> wrote:
Quote:

> Hi,
>
> Running the following code *I get a Run time error. I understand the
> reason(the module that I want to execute is in my personal.xls) but
> don't know how to fix it!
> Thank you for your support.
>
> Option Explicit
>
> dim app,workbook,objWMIService,colProcessList,objShell
> dim strComputer, objProcess
>
> strComputer = "."
>
> Set objWMIService = GetObject("winmgmts:" _
> * * & "{impersonationLevel=impersonate}!\\" _
> * * & strComputer & "\root\cimv2")
>
> Set colProcessList = objWMIService.ExecQuery _
> * * ("Select * from Win32_Process " _
> * * & "Where Name = 'Excel.exe'")
>
> For Each objProcess in colProcessList
> * * 'WScript.Echo "Excel est terminé" 'Pour Debuggage
> * * objProcess.Terminate()
> Next
>
> Set app = CreateObject("Excel.Application")
>
> Set workbook = app.Workbooks.Open("D:\Robert\DOCUMENT\XLS\Budget" &
> Year(now) & ".xls")
Houps! Found it!
Regards.
My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
openning Excel or Access files directly Vista General
openning install.wim in Windows SIM Vista installation & setup
Screen flashes black when openning or closing ie Vista performance & maintenance
Error openning Office 2003 Vista General
Openning XP backup files in Vista Vista installation & setup


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46