List All Properties in Object

crazypabs

Board Regular
Joined
Mar 6, 2007
Messages
109
Hi

I need to list all the properties in an object. Anyone got any VBA code to do this.
I dont want to just look up the OB as this wont then allow me to export and compare the results for any changes in the object's properties.

Any thoughts?

Cheese

Pabs
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Pabs

As far as I know there's no code that will do this.

What objects do you want to compare?
 
Upvote 0
I have a reference to the IE HTML library and I have set the object as follows...

Set s3 = myIE.Document.all.tags("TEXTAREA").Item(1)

where myIE is the IE explorer object and textarea is the area I am attempted to evaluate.

I am trying to assess all the properties of s3 before, during and after interaction of the user. Once I have a full list of the properties at each stage i then want to compare the properties to see why and where it changes.

Cheese

Pabs
 
Upvote 0
Pabs

Since this is, I think an HTML element it might be able to loop through the properties but I don't know if it would be worth it.

A lot of the properties will have their own properties which will have their... and so on.

I attempted something similar once and ended up with some crazy looping.:)
 
Upvote 0
found some MS code that kind of worked, but didnt.

I will just have to give it some trial and error, I have so far spent about 60hrs on trying to figure out this bug, and it is the last thing stopping me from taking over the world mwah-ha-ha-ha-ha

:-)

crazyPabs
(aka Matt, but that is less interesting)
 
Upvote 0
Matt

What is it you are trying to do?

Is there no other way than comparing every property of the object(s) before/after?

What code did you find and what's the 'bug'?
 
Upvote 0
I am going to be sent a series of text files containing quotes, e.g. "I have nothing to proclaim except my genius", I want the code to open IE link to my Facebook page click on the text area for putting comment on the wall then click post.

I have everything in place except the process that clicks on the textarea, whenever I do this and attempt to set the HTML Text area element properties innertext, outertext or value then the text appears in the text area but when the code clicks the Input element to post the wall comment it just sits there.

I can see that the textarea properties change but I cant get the value to be set then post.

Really discombobluated.

I will have another crack at it tomorrow night.

Cheers

Matt
aka Pabs
 
Upvote 0
Matt

I honestly don't know why you want to list all the properties, I don't think it will help.

How about concentrating on the button you are clicking?

Perhaps it's something that's triggered by that which is the problem.

If you do want to find out more about textArea http://msdn.microsoft.com/en-us/library/ms535904(v=VS.85).aspx.
 
Last edited:
Upvote 0
Hi Norie,

Thankyou for all your help, very much appreciated. Eventually I found the solution.

FYI The developers of the website had created a text box area in html with one name, but for some reason when the button ******* event was triggered the values were transfered to a hidden INPUT object and the content of the extarea was ignored.

I have now solved my problem and I am going live with my code this week. Thanks Again

Pabs
 
Upvote 0

Forum statistics

Threads
1,224,564
Messages
6,179,547
Members
452,925
Latest member
duyvmex

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top