Word 2003 Macro - need save file path code
Closed
VirtualInsanity
-
22 May 2012 à 16:50
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 30 May 2012 à 03:09
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 30 May 2012 à 03:09
Related:
- Word 2003 Macro - need save file path code
- Save as pdf office 2007 - Download - Other
- Elden ring save file location - Guide
- Nfsu2 save file location - Guide
- How to open .ps file - Guide
- Ms word mod apk for pc - Download - Word processors
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
26 May 2012 à 07:59
26 May 2012 à 07:59
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
30 May 2012 à 03:09
30 May 2012 à 03:09
could you post a sample document on some file share site on which this macro can be ran ?