Hello,
I have a VB 6 app that creates Excel files to export data that works
fine. When I ported it to VB.NET it creates the file, but seems to
finish writing the data and releasing the file only after a random
length period of time. If I use the code in the discussion "ADOX in
Office XP??" I get the same result. My code is very similar to that.
Some programming languages have a method to flush the output buffer
and close the file, but I don't see a way to do that in VB.
If I continue running the .NET app it does release the file
eventually, which makes me wonder if it has something to do with
garbage collection, but that is just a guess.
Any ideas?
Thanks
I have a VB 6 app that creates Excel files to export data that works
fine. When I ported it to VB.NET it creates the file, but seems to
finish writing the data and releasing the file only after a random
length period of time. If I use the code in the discussion "ADOX in
Office XP??" I get the same result. My code is very similar to that.
Some programming languages have a method to flush the output buffer
and close the file, but I don't see a way to do that in VB.
If I continue running the .NET app it does release the file
eventually, which makes me wonder if it has something to do with
garbage collection, but that is just a guess.
Any ideas?
Thanks