Thread: file name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Couchman[_4_] Robert Couchman[_4_] is offline
external usenet poster
 
Posts: 64
Default file name

hello all,

please can i have some help??

i have a word document that is used to mailmerge
information from my spredsheet, all the letters produced
use the same sheet but they have querystrings.

can anyone please tell me how i can get rid of the
following as it will be put in the same folder (and both
files will be moved onto local computers from a network)

activedocument.mailmerge.datasource.querystring = "SELECT
* FROM C:\documents and settings\87956308\desktop\AO
Program.xls WHERE ((passfail_application = 'Fail'))" & ""

sorry for the bother..

Thank you,

Robert Couchman
)