VB and Excel

[Bradley]

I'd like to read in an Excel based xls template, add data to specific cells
then write the information out to a different filename. In addition to a
request for some sample code, I have the following questions that I hope
somebody can help me with:
1) Do all versions of excel export an interface? I'm using Excel 2002
2) Do I need to require that all users have Excel on the system or can I
interact with the spreadsheet without it?

TIA

Brad

 

[scorpion53061]

1. I do not understand what you mean by "export an interface"

2. All users must have the Excel library installed that is either the
same or backwards compatible with the one you are writing against (if
you are using automation). Some platforms such as Crystal Reports I
believe allow you to write excel spreadsheets without Excel being
installed.

 

[Bradley]

Thanks for the response. My question must not have been clear. All that I
want to do is programmatically open an Excel file, modify the contents then
write the info to another Excel file (could be the same one.) This doesn't
seem like it should be difficult. I thought that there would be an MS Office
SDK, but the only information I find is related to Office 2003, whereas I
need to support earlier versions of Excel.

Thanks again.

Brad

 

[Cor Ligthert [MVP]]

Bradley,

They are not new, and I did not check them lately.

Office
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/...1e-3060-4f71-a6b4-01feba508e52&displaylang=en

Excel dataset fill and updat
http://support.microsoft.com/default.aspx?scid=kb;EN-US;316934

Excel naar dataset
http://msdn.microsoft.com/library/d...tskcodeexamplereadingexceldataintodataset.asp

Excel object model
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/ExcelObj.asp

Access Automate
http://support.microsoft.com/default.aspx?scid=kb;EN-US;317113

HOW TO: Call a Visual Basic .NET Class Library from Visual Basic for
Applications in Microsoft Office
http://support.microsoft.com/?kbid=317535

I hope that one of those helps a little bit?

Cor

 

[Bradley]

Cor,

This is a lot of useful information. Thanks for the assistance!

Brad