By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,570 Members | 999 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,570 IT Pros & Developers. It's quick & easy.

VB and Excel

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies

P: n/a

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" <br************@roche.com> wrote in message
news:#u**************@TK2MSFTNGP12.phx.gbl:
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


Nov 21 '05 #2

P: n/a
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

"scorpion53061" <sc************@nospamhereyahoo.com> wrote in message
news:eP**************@TK2MSFTNGP10.phx.gbl...

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" <br************@roche.com> wrote in message
news:#u**************@TK2MSFTNGP12.phx.gbl:
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

Nov 21 '05 #3

P: n/a
Bradley,

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

Office
http://support.microsoft.com/default...b;EN-US;311452

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

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

Excel dataset fill and updat
http://support.microsoft.com/default...b;EN-US;316934

Excel naar dataset
http://msdn.microsoft.com/library/de...ntodataset.asp

Excel object model
http://msdn.microsoft.com/library/de...l/ExcelObj.asp

Access Automate
http://support.microsoft.com/default...b;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
Nov 21 '05 #4

P: n/a
Cor,

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

Brad
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Bradley,

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

Office
http://support.microsoft.com/default...b;EN-US;311452

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

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en
Excel dataset fill and updat
http://support.microsoft.com/default...b;EN-US;316934

Excel naar dataset
http://msdn.microsoft.com/library/de...ntodataset.asp
Excel object model
http://msdn.microsoft.com/library/de...l/ExcelObj.asp
Access Automate
http://support.microsoft.com/default...b;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

Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.