How to use clipboard data to Populate specific cells in Excel?

[Excelody]

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:

• Error message: permission to use object declined.

So now, I am scratching my head thinking how they managed code that without the use of VBA reference libraries?

 

[Micron]

Possibly the tool contains class objects, which are things that you can create that have their own properties and methods. A userform would be an example of a class object, which you probably know has tons of properties (width, height, background properties, name, caption) and so on. There must be at least 30 of them. Class objects can have intrinsic methods as well. Provided their code does not rely on anything that is blocked (i.e. a reference library), it should be able to function as long as it can be installed on the system.

 

[Excelody]

Possibly the tool contains class objects, which are things that you can create that have their own properties and methods. A userform would be an example of a class object, which you probably know has tons of properties (width, height, background properties, name, caption) and so on. There must be at least 30 of them. Class objects can have intrinsic methods as well. Provided their code does not rely on anything that is blocked (i.e. a reference library), it should be able to function as long as it can be installed on the system.

Ah now that's interesting. The excel tool was essentially a "form" so from your advice, it sounds like it may actually use these class objects. Thank you so much for your insight. I will make a prototype to test this.

Is there a method to find out what reference libraries are installed on excel where the developer tab disabled/ removed by the firm?
I tried to enable the developer tab via the ribbon but seems like it's disabled by the firm. Again, rightly so but it makes my job difficult.

 

[Micron]

Sorry, no idea on how to determine what they block where you work. It would seem to me that IT typically blocks by file type (e.g. no xlsm allowed) not by project reference, and as you probably know, only xlsm files can contain macros.

If your supervision expects something from you and IT is making that difficult, it would seem to me that your boss needs to chat with the IT boss, or your boss needs to collaborate on what's reasonably expected from you given the constraints imposed on you. Then again, I'm using logic, which doesn't always prevail across corporate environments.