A Runtime error 91 – (Object variable or with block variable not set ) is thrown when trying to create WebADI document.
Solution 1
In Excel 2010, under Developer, go to Code tab and click on Macro Security icon. Check Trust access to VBA project object model under Developer Macro Settings.
Steps
Steps
1. Click the Office Button (top-left button in the window)
2. Click the Microsoft Excel Options button.
3. Click Trust Center in the menu on the left.
4. Click Trust Center Settings in the window on the right.
5. In the new window that opens click Macros in the menu on the left.
6. Under 'Macro Settings' check 'Disable all macros with notification'.
7. Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'.
8. Click 'OK'
9. Click 'OK'
Solution 2
To turn off Protected View on the desktop and to prevent this message appearing uncheck the following
Excel option:
Options-> Trust Center -> Trust Center Settings -> Protected View -> Enable Protected View for files
located in potentially unsafe locations
I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. Thank you for the post.
ReplyDeleteQuickBooks in Key West
The conceded installments are utilized as a wellspring of financing little costs which are to be paid instantly. 13d
ReplyDeleteI've never had so much angry because of extremely simple error but my patience almost has run out, when I have a brainstorm, led me to api-ms-win-crt-runtime-l1-1-0.dll download https://fix4dll.com/apimswincrtruntimel110_dll. That's it, I just didn't get some files and needed to load its as soon as possible,
ReplyDeleteit can't be I thought, but God bless, well, or at least blessed is the one who shared the DLL files before I lost my mind)
Feels great in hand, very ergonomic. funny phone cases
ReplyDelete