SQL Server Stored Procedure calls VBA to update Word Files?

A

AirDuster101

Hi,

We are using SQL Server 2005 Standard Edition. We stored about 10,000 Word
documents as image data type in this FileDB database. There is a SQL Server
stored procedure will export out the selected word documents into a network
folder then zip and email these word files to needed users. Between the
export and zip steps, we need to add a programming step to open each Word
doc and update the Header text. Unfortunately, we can't move this update
step to the front end UI.

Does anyone have any VB related suggestion on how we may accomplish this? I
am just thinking with my little VBA/Macro knowledge, we need to setup a VBA
module that can be called SQL Server Stored Procedure that opens and do a
global replaced on these files.... is this possible?

Any suggestion or comment is very welcome...

Thanks
AD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking data in MS Word into Excel 5
Run a SQL Stored Procedure from VBA 0
how to code a button to export results of stored procedure to excel file 0
SQL Server Stored Procedure timeout 3
VBA to SQL Stored Procedure function 0
SQL Server Stored Procedure 5
Accessing Stored Procedure via VBA 4
Making form based on stored procedure 0

Top