Consulting

Results 1 to 2 of 2

Thread: Save Word Document Using Vba Excel

  1. #1
    VBAX Regular
    Joined
    Oct 2016
    Posts
    8
    Location

    Question Save Word Document Using Vba Excel

    Hi everyone

    i was written a code that fill Word document and save it . But now I want to save word documents in a Patch that i have written in a cell (Excel 2013)

    For example :
    i used this code for save word document : doc.save as "C:\...\..." & ....&...

    Sheet 1 >> Data (for words document and PDFs)

    Control Sheet >>

    A B C
    1 Words File : C:\....\...\..
    2 PDF File : D:\...\...


    and the code i am using for this work is :

    Dim Fpathword as String

    Fpathword=Worksheets("Controlsheet").Cells(3, 3).Value

    1-doc.SaveAs Filename:=Fpathword & ... & ".docx"
    2-doc.SaveAs Fpathword & ... & ".docx"

    But it's not Working both of them (1 ,2 )
    Last edited by MH123; 05-02-2017 at 09:39 AM.

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    The lack of code and the vague details you've provided don't supply anywhere near enough information for anyone to know where the problem is.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •