I work for a large firm in the UK. I am building an excel tool to automate tasks to enable my team to focus on customer care.
The biggest problem is that my firm have 'disabled' most objects in the VBA reference library (understandable - due to security concerns).
However today, I spotted an excel tool our firm uses whereby you can:
1. Click inside our "intranet" appointment portal webpage
2. Select all of the text in there (by pressing the Ctrl + A keys at the same time)
3. Copy all of the selected text (by pressing the Ctrl + C keys at the same time)
4. Click on "Import data" and this Excel Tool, pastes 2-3 pieces information into specific cells
for example, it imports Customer appointment time, date, location etc
I know I can solve this by importing:
- Microsoft html object Library
At home, my tool uses this and works fine. When I test my tool in the office, it gives me the following error:
The biggest problem is that my firm have 'disabled' most objects in the VBA reference library (understandable - due to security concerns).
However today, I spotted an excel tool our firm uses whereby you can:
1. Click inside our "intranet" appointment portal webpage
2. Select all of the text in there (by pressing the Ctrl + A keys at the same time)
3. Copy all of the selected text (by pressing the Ctrl + C keys at the same time)
4. Click on "Import data" and this Excel Tool, pastes 2-3 pieces information into specific cells
for example, it imports Customer appointment time, date, location etc
I know I can solve this by importing:
- Microsoft html object Library
At home, my tool uses this and works fine. When I test my tool in the office, it gives me the following error:
- Error message: permission to use object declined.