Runtime Error 91- Object variable or With block variable not set
I am getting “Runtime Error 91- Object variable or With block variable not set” while trying to print a report using data direct Add-ins.
I can explain a little bit more. We have installed 800xA software(6.0.3.2) first then only installed excel.
Initially while opening excel itself error ,“Runtime Error 91- Object variable or With block variable not set” was getting. To takeout this I have unchecked COM-Add-ins (Parameter Manager Add-In)
Now I have enabled DataDirect System 800xA Add-in.
If I am trying to print the report using action aspect I am getting the error “Runtime Error 91- Object variable or With block variable not set”.
How I can fix this issue ?
Answers
When you print the report using an Action Aspect, then excel runs on the server where the scheduler is installed under the Service Account.
Log on to that server as the service account and remove the add-in again.
Log on to that server as the service account and remove the add-in again.
Add new comment