Hi All, Can we use "SEEK" method to speedup in finding record in excel file ?
Thank you MUL ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 22, 2004 12:30 PM Subject: Re: [vbhelp] My First Exe... > > > Thank you, I set all of my forms = Nothing and I even iterated through each object on each form and set them each to nothing just in case. I still have one hanging on somewhere. I'll keep looking and I'll try the End statement. > > Dave > ----- Original Message ----- > From: Rick Rose > To: [EMAIL PROTECTED] > Sent: Monday, November 22, 2004 2:07 PM > Subject: RE: [vbhelp] My First Exe... > > > If that doesn't work, put "end" as the last line in your form unload event. > That is not exactly good coding etiquette, but it works. > > Rick Rose > -------Original Message------- > > From: [EMAIL PROTECTED] > Date: 11/22/04 14:27:45 > To: [EMAIL PROTECTED] > Subject: RE: [vbhelp] My First Exe... > > You've got objects that are still holding onto memory. You should have > a closing subroutine that iterates the Forms collection making sure > every form is unloaded. Also, any objects your application has created > should be set to nothing. > > -----Original Message----- > From: four_blades [mailto:[EMAIL PROTECTED] > Sent: Monday, November 22, 2004 8:48 AM > To: [EMAIL PROTECTED] > Subject: [vbhelp] My First Exe... > > > > > Background: > Up till now I worked only with Excel but... > I just converted one of my Excel Programs to an Executble in VB. > (The Program Was All Forms and Related Code--No Excel Objects). > After a few minor code changes it runs, but dosn't properly close... > > Question: > If my program continues to run in the Task Manager when I close All > Forms, what have I done that's incorrect? > > Dave > > > > > > > > > > > '// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [EMAIL PROTECTED] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] > '// ======================================================= > > Yahoo! Groups Links > > > > > > > > > > > > > '// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [EMAIL PROTECTED] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] > '// ======================================================= > > Yahoo! Groups Links > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > '// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [EMAIL PROTECTED] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] > '// ======================================================= > > > > Yahoo! Groups Sponsor > ADVERTISEMENT > > > > > > -------------------------------------------------------------------------- ---- > Yahoo! Groups Links > > a.. To visit your group on the web, go to: > http://groups.yahoo.com/group/vbhelp/ > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > [Non-text portions of this message have been removed] > > > > > > > > > '// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [EMAIL PROTECTED] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] > '// ======================================================= > > Yahoo! Groups Links > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
