Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Source File Off'97 vs '03
Have an xl source file that is used in a mail merge and is located on a network drive (at
work). The Word template resides in the workgroup templates directory. Prior to Off'03, once the merge was set up it functioned easily (user selected the template-File-New) and away it goes. In '03 it comes up with the "Opening this file...sql..Select * from" message - which is fine, but; on my machine it works - shows the directory/file (say ok and it proceeds). On the user's machine it presents the message but the file name is shown with quotes and an appended "$" sign - no directory is indicated. Saying "ok" causes it to bring up the "Select Data Source" dialogue forcing the re-selection of the file-which is a PITA for the user. After that it works ok. The differences are that; - I have local admin rights - I "manufactured" the Word template & XL workbook. Would either of these differences cause the situation, or is there something else afoot here that I (obv.) don't understand. -- Regards; Rob ------------------------------------------------------------------------ |
#2
|
|||
|
|||
See the following Knowledge Base article:
"Opening This Will Run the Following SQL Command" Message When You Open a Word Document - 825765 at: http://support.microsoft.com?kbid=825765 The user's problem may result from their having at one time clicked on No when the above message appeared. -- 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 "RWN" wrote in message ... Have an xl source file that is used in a mail merge and is located on a network drive (at work). The Word template resides in the workgroup templates directory. Prior to Off'03, once the merge was set up it functioned easily (user selected the template-File-New) and away it goes. In '03 it comes up with the "Opening this file...sql..Select * from" message - which is fine, but; on my machine it works - shows the directory/file (say ok and it proceeds). On the user's machine it presents the message but the file name is shown with quotes and an appended "$" sign - no directory is indicated. Saying "ok" causes it to bring up the "Select Data Source" dialogue forcing the re-selection of the file-which is a PITA for the user. After that it works ok. The differences are that; - I have local admin rights - I "manufactured" the Word template & XL workbook. Would either of these differences cause the situation, or is there something else afoot here that I (obv.) don't understand. -- Regards; Rob ------------------------------------------------------------------------ |
#3
|
|||
|
|||
Thanks Doug, but I guess I didn't explain it well enough.
I have no problem with the message-I was aware of the change (and the KB). The problem is that it displays the filename with oddball quotes and an appended "$" sign (no directory). Saying OK brings up the "Select Data Source" dialogue. Browsing and selecting it allows the merge to run. The next day (it's run daily) the same thing happens. It's as if it is loosing the connection to the source file. As noted, it works ok for me. I'm thinking now that the format of the file name in the warning box is giving me a hint but I don't know what it is. ex. the path and file name are -\\networkdrive\SourceFile.xls The warning screen shows just`'SourceFile.xls$'`. Guess I'll have to do some playing around as it appears I'm missing something (probably the obvious!). Again, thanks. -- Regards; Rob ------------------------------------------------------------------------ "Doug Robbins" wrote in message ... See the following Knowledge Base article: "Opening This Will Run the Following SQL Command" Message When You Open a Word Document - 825765 at: http://support.microsoft.com?kbid=825765 The user's problem may result from their having at one time clicked on No when the above message appeared. -- 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 "RWN" wrote in message ... Have an xl source file that is used in a mail merge and is located on a network drive (at work). The Word template resides in the workgroup templates directory. Prior to Off'03, once the merge was set up it functioned easily (user selected the template-File-New) and away it goes. In '03 it comes up with the "Opening this file...sql..Select * from" message - which is fine, but; on my machine it works - shows the directory/file (say ok and it proceeds). On the user's machine it presents the message but the file name is shown with quotes and an appended "$" sign - no directory is indicated. Saying "ok" causes it to bring up the "Select Data Source" dialogue forcing the re-selection of the file-which is a PITA for the user. After that it works ok. The differences are that; - I have local admin rights - I "manufactured" the Word template & XL workbook. Would either of these differences cause the situation, or is there something else afoot here that I (obv.) don't understand. -- Regards; Rob ------------------------------------------------------------------------ |
#4
|
|||
|
|||
Has the user saved the main document after taking the necessary steps to
attach the datasource? -- 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 "RWN" wrote in message ... Thanks Doug, but I guess I didn't explain it well enough. I have no problem with the message-I was aware of the change (and the KB). The problem is that it displays the filename with oddball quotes and an appended "$" sign (no directory). Saying OK brings up the "Select Data Source" dialogue. Browsing and selecting it allows the merge to run. The next day (it's run daily) the same thing happens. It's as if it is loosing the connection to the source file. As noted, it works ok for me. I'm thinking now that the format of the file name in the warning box is giving me a hint but I don't know what it is. ex. the path and file name are -\\networkdrive\SourceFile.xls The warning screen shows just`'SourceFile.xls$'`. Guess I'll have to do some playing around as it appears I'm missing something (probably the obvious!). Again, thanks. -- Regards; Rob ------------------------------------------------------------------------ "Doug Robbins" wrote in message ... See the following Knowledge Base article: "Opening This Will Run the Following SQL Command" Message When You Open a Word Document - 825765 at: http://support.microsoft.com?kbid=825765 The user's problem may result from their having at one time clicked on No when the above message appeared. -- 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 "RWN" wrote in message ... Have an xl source file that is used in a mail merge and is located on a network drive (at work). The Word template resides in the workgroup templates directory. Prior to Off'03, once the merge was set up it functioned easily (user selected the template-File-New) and away it goes. In '03 it comes up with the "Opening this file...sql..Select * from" message - which is fine, but; on my machine it works - shows the directory/file (say ok and it proceeds). On the user's machine it presents the message but the file name is shown with quotes and an appended "$" sign - no directory is indicated. Saying "ok" causes it to bring up the "Select Data Source" dialogue forcing the re-selection of the file-which is a PITA for the user. After that it works ok. The differences are that; - I have local admin rights - I "manufactured" the Word template & XL workbook. Would either of these differences cause the situation, or is there something else afoot here that I (obv.) don't understand. -- Regards; Rob ------------------------------------------------------------------------ |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the Source file path for inserting pictures? | Microsoft Word Help | |||
How to creat relative and shorthand file path names? | Microsoft Word Help | |||
How to create relative and shorthand file path names | Microsoft Word Help | |||
avoid includetext from making changes to the source file | Microsoft Word Help | |||
mail merg file list | Mailmerge |