Guest_imported
New member
- Jan 1, 1970
- 0
GREETINGS:
Am working on a present project and need to create adobe objects of some forms. the data sits in a sql2k database. i was told to use vba/excel to create templates and then dump them into adobe distiller for the creation.
i am kinda new to vba, can anyone pl give me a struct to work with.
the main points here are:
1) create connection to sql2k database 9 ( i guess with ado i can do this)
2) create a excel object
3) create the layout , like cell(1,1).value="name" and cell(1,4).value=dbname.tablename.name
4) print to ps format
5) close the excel object
6) can i call adobe distiller inside vba itself, or do i need to have it running in the background?
am i going down the wrong path??
pl advice.
tia
-r
Am working on a present project and need to create adobe objects of some forms. the data sits in a sql2k database. i was told to use vba/excel to create templates and then dump them into adobe distiller for the creation.
i am kinda new to vba, can anyone pl give me a struct to work with.
the main points here are:
1) create connection to sql2k database 9 ( i guess with ado i can do this)
2) create a excel object
3) create the layout , like cell(1,1).value="name" and cell(1,4).value=dbname.tablename.name
4) print to ps format
5) close the excel object
6) can i call adobe distiller inside vba itself, or do i need to have it running in the background?
am i going down the wrong path??
pl advice.
tia
-r
