Recent content by bartrein

Thanks a lot Hugh - CreateObject is something i haven't thought about. Still I will explore Binary Compatibility link Many thanks

Hi Fumei Let's start again :) application - excel 2003 dll library written/compiled in VB6 classes (?)- standard class modules i guess (i'm not using any of the on_connection methods as it's an automation addin not com) reference added in VB editor in Excel after changing and recompiling...

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

Hey Skip I've finally done some proper homework on this advancedfilter tool and now got a bit better idea. The key thing was that I didn't realize that criteria property works in the same way as in data functions (DSUM etc), i initially thought that it would do the same as autofilter i.e...

Exactly

The original table: ABE.MC B 125 ABF.L B 126 ABZ.L A 127 ABG.MC A 128 ABR.MC B 129 And what i would like it to look like after filtering : ABE.MC B 125 ABZ.L A 127

I might be wrong but i thought that by specifying criteria range you tell the filter in which column to look for unique values?

Thanks Skip I didn't explain properly what i wanted I want to extract UNIQuE values (so if something appears twice on my list it will only appear once after the macro) The reason for VBA is that i want this routine to be part of a larger structure of code and i wanted to write it in a way that...

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...

Thanks genomon. I am using excel 2003 and antivirus shouldn't have anything to do to with it (i think). When i rename my DLL i can compile it no problem, and even without renaming, it allows me to compile. it's usually when i close excel to add some changes in VB6 and then compile when i...

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?

Thanks DOUG not exactly what i wanted but definately useful.

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...

Depending who 'owns' the code you are trying to access it might be a good idea to acutally contact the author. You are saying that you can't access the file - is it dll library? Check the folder where your .dll file is stored perhaps you will find there another file with .vbp extension - that...

You can use OFFSET function e.g. tmp.Offset(0, 11).Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Assuming "tmp" is your range with a sought number in col A Offset (0,11) moves your reference from col A to col L (1+11) hope this helps