•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 456,554 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,457 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 156302 | Replies: 23 | Solved
 |
•
•
Join Date: Mar 2006
Posts: 5
Reputation: 
Rep Power: 0
Solved Threads: 1
Newbie Poster
I forgot to say you need
Imports System.Runtime.InteropServices.Marshal for
ReleaseComObject()
Also I'm not sure if you actually need xlApp = nothing. Seems ok without it.
Dan
Imports System.Runtime.InteropServices.Marshal for
ReleaseComObject()
Also I'm not sure if you actually need xlApp = nothing. Seems ok without it.
Dan
•
•
Join Date: Dec 2004
Location: Lincoln Park, Michigan
Posts: 1,744
Reputation:
Rep Power: 7
Solved Threads: 108
Nope, that's for .NET, which doesn't apply. Imports doesn't work in Legacy Vb's. However, setting the objects back to nothing is the proper way to go about this. Otherwise, you'll have tons of exe's (as objects) just floating around and eating up Ram.
•
•
Join Date: Mar 2006
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
Yep. Sorry,
I should check which forum I'm in before trying to be clever.
I should check which forum I'm in before trying to be clever.
•
•
Join Date: Mar 2006
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
•
•
•
•
Originally Posted by Comatose
Nope, that's for .NET, which doesn't apply. Imports doesn't work in Legacy Vb's. However, setting the objects back to nothing is the proper way to go about this. Otherwise, you'll have tons of exe's (as objects) just floating around and eating up Ram.
As you have mentioned VB 6 does not support import.
So what should I do for solving my problem?
I want to put my excel cells in an array.
I added this code also but still Exel.EXE is remaining in memory
System.Runtime.InteropServices.Marshal.ReleaseComObject (xlSht) System.Runtime.InteropServices.Marshal.ReleaseComObject (xlWBook) System.Runtime.InteropServices.Marshal.ReleaseComObject (xlApp)
•
•
Join Date: Dec 2004
Location: Lincoln Park, Michigan
Posts: 1,744
Reputation:
Rep Power: 7
Solved Threads: 108
System.Runtime.InteropServices.Marshal.ReleaseComObject (xlSht) System.Runtime.InteropServices.Marshal.ReleaseComObject (xlWBook) System.Runtime.InteropServices.Marshal.ReleaseComObject (xlApp)
set xlSht = nothing set xlWBook = nothing set xlApp = nothing set xltmp = nothing
•
•
Join Date: Mar 2006
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
I have written this code but still Excel.EXE is in task manager
If I run the program 3 times 3 EXCEl.EXE is in task manager
I have another problem also
As I said I want to store the cells in an array as the form loads
The code is :
But I have run time error '9' : Subscript out of range
Would you please help me?
Thanks.
If I run the program 3 times 3 EXCEl.EXE is in task manager
I have another problem also
As I said I want to store the cells in an array as the form loads
The code is :
ReDim Preserve Ucode2(101, 100)
For i = 2 To xlSht.Rows.Count
Ucode2(i, 0) = xlSht.Cells(i, 1).Value
Ucode2(i, 1) = xlSht.Cells(i, 2).Value
NextBut I have run time error '9' : Subscript out of range
Would you please help me?
Thanks.
•
•
Join Date: Dec 2004
Location: Lincoln Park, Michigan
Posts: 1,744
Reputation:
Rep Power: 7
Solved Threads: 108
Attach your project.
•
•
Join Date: Mar 2006
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
•
•
•
•
Originally Posted by Comatose
Attach your project.
I have attached my project.
I want to store the cells of the Excel file in an array named Ucode2
but there is runtime error 9 : subscript out of range.
•
•
Join Date: Dec 2004
Location: Lincoln Park, Michigan
Posts: 1,744
Reputation:
Rep Power: 7
Solved Threads: 108
And the excel document.
|
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 4 (0 members and 4 guests)
Linear Mode
•
•
•
•
3d apple blue screen cocoa computer crash dell development drivers email enterprise eudora firefox framework games gnu graphics ibm intel internet java linux microsoft microsystems mozilla news next open open source open-source opengl openoffice operating os penelope programming red hat rhel server software source step sun super system ubuntu vista wesnoth windows xp
- Open Excel File (VB.NET)
- "Cannot Open Include File" MS Visual C++ error (C++)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: SPI data transfer to Atmega8 by VB6 through parallel port
- Next Thread: Visual Basic Timer/Clock/Countdown.
