simple script

MacschedStudent · Post by **MacschedStudent** » Fri Oct 12, 2007 6:39 pm

Guys look at this simple code:

ExcelFile = "test.xls"
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.workbooks.open(ExcelFile)

Thats it! thats the entire code and yet I get the "object required objExcel" how is that possible. I'm setting the object before I call on it. Any ideas..??

JRL · Post by **JRL** » Fri Oct 12, 2007 8:32 pm

I assume you're not trying to run VBScript as Macro Scheduler Script. If you are, look up VBSTART, VBRun and VBEVal in help. Also the file "test.xls" needs a path. I put test.xls in the root of C: (windows XP) and the following opens the file for me.

There is no Excel GUI available but looking in Task Manager, I can see that excel is running.

Code: Select all

VBSTART
Sub OpenExcel
ExcelFile = "c:\test.xls"
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.workbooks.open(ExcelFile)
End Sub
VBEND

VBRun>OpenExcel

Post by **Marcus Tettmar** » Fri Oct 12, 2007 8:34 pm

If you want to make Excel visible modify as follows:

Code: Select all

VBSTART
Sub OpenExcel
  ExcelFile = "c:\test.xls"
  Set objExcel = CreateObject("Excel.Application")
  objExcel.Visible = true
  Set objWorkbook = objExcel.workbooks.open(ExcelFile)
End Sub
VBEND

VBRun>OpenExcel

MacschedStudent · Post by **MacschedStudent** » Sat Oct 13, 2007 5:35 am

thanks marcus I had not put the code in MacSched yet I was simply confused as to why it would not work as a vbs file. Thanks again!!

MacschedStudent · Post by **MacschedStudent** » Sun Oct 14, 2007 8:59 pm

Marcus, I placed test.xls onto C drive and pasted your entire code into the editor and compiled in Msched and I still get the same response.

"line 5 Column2 object required objExcel" could the excel server be damaged somehow???