LinkBack URL
About LinkBacks
hi
i try adapt code make by expert jindon, but I did not get success.
hi
i try adapt code make by expert jindon, but I did not get success.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Well jindon writes pretty advanced codes...
Guess only he or some other VBA gurus will be able to guide you through..
Cheers!
Deep Dave
Hi NeedForExcel , download my file to uderstand.
marreco,
Where is jindon's code? It is not in the book you uploaded, and maybe with that we can help modify.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Hi I recommend downloading the file
Please Login or Register to view this content.
I have downloaded the file... it didn't have that code in it. Thanks.
in my i show before and after result, if you can help, I am grateful.
Ok marreco,
I understand your example, column F has unique list of ndoc. But columns H to K, which date goes there? The PREVISAO_DATA date? or the ATUAL_DATA date?
Two columns F and G (ndoc | PREVISAO_DATA) uniq.
ATUAL_DATA date.But columns H to K, which date goes there?
My coding is not as good as Jindon's but try this and let me know...
Oh you do have to go to VBA editor, click tools, references, and put check in box next to "Microsoft Scripting Runtime"Please Login or Register to view this content.
Last edited by Arkadi; 04-01-2015 at 09:05 AM.
Is this how you wanted?
Please Login or Register to view this content.
Why display RunTime error?user-defined type not defined
It must be Arkadi's code. Arkadi use early binding which requires to reference scripting in tools-reference.
marreco,
As said in my previous post, you nee to go to VBA editor, click tools, references, and put check in box next to "Microsoft Scripting Runtime"
I wondered AB33, I am very partial to early binding, and aside from occasional confusion due to reference not being set, I find it more convenient. BUT, is there a significant advantage to either method?Originally Posted by AB33
Yes,
Early binding gives you auto pop-up or intellisense. If you do not know the methods and properties of the object, this is could be very handy. Lost of people also claim that Early is faster than late.
The main disadvantage is what you have got in to. All users of the code have to enable the reference(connection). There is an issue of incompatibility too.
What most developers do this way: write the code first using early to get all the help you can get, then after you run it and works and convert it in to late.
I use early lots of time when I try to code using ADO as I do not know most of the properties and methods.
Last edited by AB33; 04-01-2015 at 10:03 AM.
hi need say thank you for all great experts (AB33, Arkadi and jindon), thank very much !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
marreco,
De nada! Glad we could help
AB,
Thanks. I think in future I will convert to late binding to avoid confusion, and yes the intellisense can help lots. Like you, I use it very often for ADO.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks