Addressing Excel on screen from VB
I just downloaded a table.csv from Yahoo via VB6.
I have it on the screen and shows on the taskbar, but cannot figure out how to read or write to it from VB.
I have tried to 'CreateObj' as I have successfully done many times before.
I cannot find the table.cvs using XP search of my computer.
I can write an Excel macro in another Excel file, e.g:
and this finds the table.csv and will allow me to copy & paste.
However, VB will not recognize: Windows("table.csv").Activate
Incidently, XP wants to sae this in TEMP as table.csv and succesive tables as table-1 and -2, etc.
I do not have want to go this route.
I also want to Kill this file from VB after I have extracted the data.
Kill filename, but I don't know what the file name is since I can't find it.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL