If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Integration of Word, Excel & VB
I have a project centred around an Excel database. It has lots of VB code associated with it.
The worksheet is the source data for a series of word mail merge reports. Here is where I hope you folks can help me ... The data worksheet is volatile. Active worksheets are user based. They select a date, and that date is used as part of the file name to be loaded as the merge source. (ie 15-07-07 represents the source database 15-07-07.xls to be accessed.) Challenge # 1 - how can I use my reports with more data source flexibility? Second challenge ... I have 4 different reports, all relying on the same datasource, but differeint recipient criteria. Without saving individual reports for each different query, how can I allow the user to define the criteria? (ie This is all part of a project that is intended to be simple to use by those not familiar with features and buttons of each application. Jenn |
#2
|
|||
|
|||
Integration of Word, Excel & VB
From the very sparse information that you provide, it seems to me that it
can all be done using the Mail Merge Interface that Word provides. All you need do is provide instructions to the users. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "MaxArk" wrote in message ... I have a project centred around an Excel database. It has lots of VB code associated with it. The worksheet is the source data for a series of word mail merge reports. Here is where I hope you folks can help me ... The data worksheet is volatile. Active worksheets are user based. They select a date, and that date is used as part of the file name to be loaded as the merge source. (ie 15-07-07 represents the source database 15-07-07.xls to be accessed.) Challenge # 1 - how can I use my reports with more data source flexibility? Second challenge ... I have 4 different reports, all relying on the same datasource, but differeint recipient criteria. Without saving individual reports for each different query, how can I allow the user to define the criteria? (ie This is all part of a project that is intended to be simple to use by those not familiar with features and buttons of each application. Jenn -- MaxArk |
Thread Tools | |
Display Modes | |
|
|