VB and Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

I have a VB app that needs to export data via ADO to a pre-defined Excel
2003 spread*** (has captions/headers to describe the data). The
spread*** has pre-defined cells for where the data goes. I also need it to
be flexible to allow the user to modify the excel spread*** (move data
around) without having to change my program. So, I cannot hard code these
cell locations in my code (ws.Range("J4").Value = rs!value1). I thought
about creating a template file that holds all the cell locations for the
data which would allow the user the ability to move data around. I also
looked into using pivot tables and XML however I do not like these solutions
for this app. Any other ideas?

Thanks


.

Quantcast