Word 2003 Macro - need save file path code
Closed
VirtualInsanity
-
May 22, 2012 at 04:50 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 30, 2012 at 03:09 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 30, 2012 at 03:09 AM
Related:
- Word 2003 Macro - need save file path code
- Save as pdf office 2007 - Download - Other
- Windows 10 iso file download 64-bit - Download - Windows
- Battery reset code - Guide
- Word apk for pc - Download - Word processors
- Samsung volume increase code - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 26, 2012 at 07:59 AM
May 26, 2012 at 07:59 AM
It is saving in this line
.SaveAs Filename:="MergeResult" & CStr(docCounter)
you can prefix it with hard coded value or you can use special folders location like (desktop, my documents etc"
.SaveAs Filename:="c:\MergeResult" & CStr(docCounter)
.SaveAs Filename:="MergeResult" & CStr(docCounter)
you can prefix it with hard coded value or you can use special folders location like (desktop, my documents etc"
.SaveAs Filename:="c:\MergeResult" & CStr(docCounter)
Hi there - thanks for this. I've tested it in quite a few ways but it doesn't seem to be paying attention to the file path I've give it and saves it in random places.. sometimes in the My Documents folder - sometimes in the same folder as the template file depending on the file path I've given it (neither of which saved it in the right place). I can't make out the pattern though. Here's the line that I have:
With newdoc
.SaveAs FileName:="Interviewees" & CStr(docCounter)
.SaveAs FileName:="C:\Documents and Settings\RicharAn\My Documents\Merged Letters" & CStr(docCounter)
I even tried directing it to the i: drive which is where I really want to save it but it still saved the resulting files to my My Documents folder on the c: drive!
With newdoc
.SaveAs FileName:="Interviewees" & CStr(docCounter)
.SaveAs FileName:="C:\Documents and Settings\RicharAn\My Documents\Merged Letters" & CStr(docCounter)
I even tried directing it to the i: drive which is where I really want to save it but it still saved the resulting files to my My Documents folder on the c: drive!
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 30, 2012 at 03:09 AM
May 30, 2012 at 03:09 AM
could you post a sample document on some file share site on which this macro can be ran ?