![]() |
|
#1
|
|||
|
|||
|
Word 2010, Access 2010. I have VBA code that successfully opens up Word, merges my document with my template, but then does not save the file with the values I am supplying. This IS working for my 200 users, but it is not working on my workstation. I am wondering if there is some setting in Word that I need to change so that this code will work.
'This is not working, the file is not saving wordapp.ActiveDocument.SaveAs ReportDir & LabNumber & "_" & ItemNumber & "_" & CATEGORY & ".doc", , , , , DecryptPIN(DLookup("PIN_NUMBER", "ANALYST", "FULL_NAME='" & ana_txt & "'")) wordapp.ActiveDocument.Close The file itself wants to save as the words that appear in my heading. All of my values show as valid in the immediate window in Access. What am I missing here? I admit I am cross-posting, UtterAccess had no replies for me. And that is unheard of. Thank you. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How to suppress saveas dialog from VB6
|
steveneashcraft | Word VBA | 15 | 05-09-2014 07:01 AM |
Using With ActiveDocument.Tables()
|
SuzeG | Word VBA | 1 | 01-08-2014 02:00 PM |
Saveas error handling
|
jillapass | Word VBA | 7 | 03-30-2012 03:24 PM |
saveAs ChDir _
|
tinfanide | Excel Programming | 4 | 11-05-2011 01:40 AM |
Array into ComboBox + Macro-Text into ActiveDocument
|
Vivi | Word VBA | 1 | 01-27-2010 07:03 AM |