![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| 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. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | 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 Specs![]() |
| | #2 (permalink) |
| | 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") Regards. |
My System Specs![]() |
![]() |
| 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 | |||