>My users are entering data into a database application. I would like the application to enter that data into a already pre-generated/created Excel spreadsheet. Is there a way I can print the pre-generated excel spreasheet with the data that's being entered?
Hi Jeffrey,
Having to deal with the same situation over and over again I wrote
tool rep2excel which is posted here in download section.
It is simple (unpolished) library with common automation tasks.
It let you access excel file like 3D matrix and write as easy as
oXl=createobject...
oXl.open_excel('C:\yourdir\yourtemplate.xls')
oXl.make_cell(1,1,3,'Hello')
oXl.make_cell(2,1,3,'There')
oXl.close_excel()
Also it can write whole arrays or tables at given position
draw & paint boxes, format cells etc.
Secondary it have whole reporting mechanisam (class) that (similar to frx)
can output structured (grouped) reports directly to excel and other tyoes of files.
Only problem is that excel OLE automation is slow writing mechanisam and can be kind of 'slow' with biger tables.
In case u hv problem implementing it
you can contact me any time.
Best Regards
Sergio