09-14-2010, 01:35 AM
I am getting the following message when trying to connect to Excel:
Error (RT) in VV_LoadExcel: Failed to connect to Excel.
Excel must be running. If fails anyway, try to run this macro in separate process as User. Set it in Properties.
This is the code that generates the error:
/exe 1
function int'Row
out "VV_LoadExcel: Row is %i" Row
int WaitTime = 0.2
str data
ExcelSheet VV_Survey.Init("Work") ...... fails here.
...
I am running Vista/Excel 2007 and Excel is up and running. This function is called by another macro, and it worked fine under XP/Excel 2000. I have selected to run the macro in a separate process as User, but still get this error.
I run under an account without admin privileges, but I am able to connect with Excel using a simple demo program from the Help topic on Excel and it works fine.
Any ideas on what might be wrong?
Error (RT) in VV_LoadExcel: Failed to connect to Excel.
Excel must be running. If fails anyway, try to run this macro in separate process as User. Set it in Properties.
This is the code that generates the error:
/exe 1
function int'Row
out "VV_LoadExcel: Row is %i" Row
int WaitTime = 0.2
str data
ExcelSheet VV_Survey.Init("Work") ...... fails here.
...
I am running Vista/Excel 2007 and Excel is up and running. This function is called by another macro, and it worked fine under XP/Excel 2000. I have selected to run the macro in a separate process as User, but still get this error.
I run under an account without admin privileges, but I am able to connect with Excel using a simple demo program from the Help topic on Excel and it works fine.
Any ideas on what might be wrong?