Search results for query: *

Do i need to reload (remove and add reference) to my dll file every time i compile it ? I am getting an error if i don't do it - something like "class does not support automation" thanks

Hi - I have a table of data in range a1:d20000 - Column "B" contains duplicate & unique values - I want to delete entire-rows with duplicates in col B - TO do that i create a temporary sheet, using ADVANCED autofilter i extract and paste rows with unique values into that sheet, remove...

Hi I'm having a problem compiling my VB6 library which i am using in excel VBA. Excel application is closed, i've set class = nothing at the end of my vba macro. any idea why is this happening?

So i have written number of functions in VB6 and would like to use them in VBA. The library is growing and at some stage i may loose track of what does each of my functions exactly do. Is there a way to add context help or function description that could be accessed witin VB editor - e.g...

Hi It is probably a common question and i had done some research before posting however what i have found does not seem to work for me. So the situation is : - I have created a library of some reusable VBA functions/subs and stored it in .XLA addin, at the moment they are only to be used in...

I've been recently reading a lot about excel addins written in other languages which are widely considered to be quicker than VBA. I understand that this is because VBA is being interpreted line by line as opposed to the languages compiled to the machine code. But then what is the reason for...

HI I have the following function that allows printing internet websites. It works fine however i can't find anything that would help me to define print out settings on the fly (e.g. fit to 1 page change orientation to landscape etc). I couldn't find anything amongst .ExecWB arguments maybe i...

is this possible without a loop? let's say i wanted to return the content of : vaData= range("a1:a65000").value to another range as integers (loosing decimals). many thanks

HI I found a very useful piece of code which allows you to extract information from websites and return it into your spreadsheet as long as you know the element ID of the field from the HTML document. The code below works on the yahoo finance website where at the moment it navigates to Vodafone...

Hi I have got a macro which basically does the following : - finds and selects all the numbers in one column using special cells (column contains numbers and some text comments) - copies all those numbers and corresponding codes located in another column(Offset(0, -3)to another sheet...

Is there a simple way of doing this? I want to find a particular word on the page of the website and highlight it just as if i was using ctrl+f within internet explorer. I would like to send this command from excel though - is this possible? thanks Sub FindMyText() Dim appIE As...

Hi Everyone I have a little macro which opens internet explorer and finds the relevant website using data from my spreadsheet. It works fine however the problem is that each time you run this macro it creates a new instance of IE object i.e. opens new window. There are times that you have to...