Hi Jangid, In VB dot Net this is probably much easier, but in Classic VB-6 I always fell back on Randy Birch's API code to determine the usable work space...
Hello I have a comboBox with a list of names in it, the names are moving down the combobox and this is throwing off my SelectCase list, can anyone tell me why...
Unless the contents of the combobox is fixed, if your using the index number to determine which name is selected, I think you're making a mistake. You should...
Good Morning Fred, VB-6 or dot Net ? If you are adding new names to the CBO but the index remains zero, you may be adding each new item to the top of the list....
I'm guessing he uses VBFred. From: helpwithvb@yahoogroups.com [mailto:helpwithvb@yahoogroups.com] On Behalf Of Steve Manser Sent: Friday, November 06, 2009...
I thought Adelle was the only one who wanted to write their own version of VB :) ________________________________ From: helpwithvb@yahoogroups.com On Behalf...
As I've been working on this Excel project, I run my app, which opens an Excel spreadsheet and populates it. And It appears to be working pretty well. So I...
Guessing that this is using VB6. Make sure that your are closing all your objects and destroying the instances in your program. Something similar to this: Set...
Good guess. I'll be moving on to the VB.Net version later. In the mean time, all my excel objects are local variables of a function. Don't they get destroyed ...
No.as is evident from your experience. All variables are objects; however, all objects are not variables. It's fairly easy to manage a variable or reference to...
I concur with both Tim and Ken: you HAVE to completely close the instance of Excel each time, or you end up with several open instances that don't go away...
Then what you're saying is that all excel objects/variables have to be globally public in scope. That is the only way I will be able to set them to Nothing in...
Tell me again why must it take place in the unload event? From: helpwithvb@yahoogroups.com [mailto:helpwithvb@yahoogroups.com] On Behalf Of Steve Trigero Sent:...
…And VB6 doesn’t allow you to call a cleanup subroutine from the unload event? From: helpwithvb@yahoogroups.com [mailto:helpwithvb@yahoogroups.com] On...
I have used several recordsets in many subroutines in a project with the same reference name rs declared within the subroutine as dim rs as new ADODB.recordset...
I believe it does, but I don't see how that doesn't changes anything. The Excel object has to have global scope in order to be destroyed after my function...
... This is different from a Globally declared/created RS. or an ADO RS that is Module Wide in scope, as in Form Wide. Adelle is going to spank me if I get...
The Form's Terminate Event fires last, and I was told that is where we should perform the clean-up of our Objects. However, since your Excel Objects are...
I am using webbrowser control and sent text to a textbox in a webpage by using getElementById but i want to get the data from a html table and store it to my...
... Are you referring to the code that sets all excel objects to Nothing, since that's the only code I've seen from Tim? Wouldn't that kill excel before it was...
I recall this as well... but, for the life of me, I cannot recall why it can be potentially harmful to set the rs to Nothing explicitly... If the variable is...
I would like to know this also.... I to always close up and set to nothing.... I've not seen any problem, but who's to say there were not any that I have not...
I had closed the recordset as rs.close but is it necessary to set rs to nothing because i never did that and didnt face a problem for that Sent from my Nokia...
Way back when, I was taught that if you did not set it to nothing it was still hanging around thus causing a memory leak. I do not know if this is the case, I...
... Provided the recordset is declared locally and there are no other variables outside that scope (i.e. global variables or byref arguments to that routine)...
Thanks! From: helpwithvb@yahoogroups.com [mailto:helpwithvb@yahoogroups.com] On Behalf Of Adelle Hartley Sent: Tuesday, November 10, 2009 5:41 AM To:...