Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
VB.NET; ADO and Excel 2000
Name: mking (by mkingrey) Date: November 29, 2005 at 08:09:06 Pacific OS: XP Pro CPU/Ram: 1.4
Comment:
Hello,
I would like to use vb.net to take an excel file, convert specific data into variables and then write the data out to certain parts of another excel file. Can anyone tell me how to make this connection as if I was using Access and Jet 4.0 OLE DB.
Name: Chi Happens Date: November 29, 2005 at 10:01:42 Pacific
Reply:
With an ODBC connection to the excel sheets, you don't need access or the jet driver. Simply connect to the Excel sheet like it was a database table, get your values, connect to the destination excel sheet and plug em in.
Summary: I have source for a C project that I have compiled as a DLL and am accessing its functions from a VB.NET Program. I have successfully been able to call the DLLs functions that I need. However, I nee...
Summary: Being a super sharp Cobol coder i start VB.net cold turkey today - any one have some good advice on VB.net? should i go VB.net first and skip VB 6? - any good Books,online Classes? ...
Summary: I have the VB code below (that runs as a macro in Excel) It separates each sheet and saves each sheet of the workbook by it's tab name as an Excel file in c:tmp - and emails each sheet to the email ...
0 
