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
- Nfsu2 save file location - Guide
- Elden ring save file location - Guide
- Ms word mod apk for pc - Download - Word processors
- Cs 1.6 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 ?
    
    