B
bigpalooka
I'm currently distributing an XL Template along with an Access 2000 db each
month. I occasionally modify the template which contains formatted sheets
and vba code, change the filename and distribute it with the db. I'd like to
store the XLtemplate itself in a table as an ole object and then do something
like:
set wkb=xlApp.workbooks.add(rs![Template]) to open the new workbook in a
separate process but I don't know how to run the ole object stored in the
database. It would make my distribution more compact and eliminate the
clutter from previous templates.
Can it be done?
??
month. I occasionally modify the template which contains formatted sheets
and vba code, change the filename and distribute it with the db. I'd like to
store the XLtemplate itself in a table as an ole object and then do something
like:
set wkb=xlApp.workbooks.add(rs![Template]) to open the new workbook in a
separate process but I don't know how to run the ole object stored in the
database. It would make my distribution more compact and eliminate the
clutter from previous templates.
Can it be done?
??