Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
file name
Robert
Can you use ....querystring = "SELECT * FROM " & ActiveDocument.Path & "\AOProgram.xls WHERE ((passfail_application = 'Fail'))" -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Robert Couchman" wrote in message ... 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 ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
I saved file A over file B. Can I get file B back? | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . | Excel Discussion (Misc queries) | |||
i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) |