Is there a simple way to display all supported methods and/or properties for elements like activesheet or activecell or whatever? The compiler shows them but shows EVERYTHING regardless of the element we are currently dealing with. Or am I wrong?
Sorry for the lack of formal use of terminology...
Ok, here is the deal.
User picks up to item 4 items form an iterative InputBox.
He may actually pick less than 4.
I store choices in OptVal(4).
Then I access a mainframe data base and based on choices resolve user choices.
Result would be to paste to an Excel cell the returned value from the...
I am experimenting with accessing IE from VBA. My company has some web based applications I am trying to access, read and interact with from VBA. Simple stuff. No frames at this stage.
But how may I find the properties of the IE.document and where to put data or where to retrieve from.
I have...
We receive PDF files resembling Excel files. Same position, same data type, over and over again.
Has anyone developed a means of opening a PDF file from VBA and getting data into variables? After that generating the Excel file with just the data I need is simple enough. (PDF documents go from 5...
Hello, everyone there ...
I receive about one hundred e-mails per day where, most of the time, I need to pick up order numbers (7 digits) and paste it to Excel or to navigate another appliication (Hummingbird) - I have succeded in interfacing Excel with Hummingbird but I have failed miserably in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.