+ Reply to Thread
Results 1 to 3 of 3

VBA code to open some pdf files and rename it in a different path

  1. #1
    Registered User
    Join Date
    07-10-2018
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    1

    VBA code to open some pdf files and rename it in a different path

    Dear all I need your help.
    I'm trying to write a VBA code to open some Pdf Files, and rename them, Using Excel Vba editor.
    I have divided the code in two parts
    the first part concern to getting the name of pdf file, saved in a folder, as list in excel file (this part of code is already developed and its works).
    The second part of job is to open the files (using a path gotten from the first part of the code) and then rename them and save in adifferent directory.
    Coould you help me? Please

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: VBA code to open some pdf files and rename it in a different path

    You can check here for your 2nd part.
    https://stackoverflow.com/questions/...-save-as-close
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: VBA code to open some pdf files and rename it in a different path

    Good afternoon Frank_smera

    You don't have to open the file to resave as a different filename - you can just rename if required, thus :

    Please Login or Register  to view this content.
    HTH

    DominicB

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VB code to open a file from a path which contains certain texts
    By shreeja178 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-15-2016, 08:03 AM
  2. Macro to open consecutively .TIFF files in 1 folder and rename them?
    By tedikoleva in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-09-2014, 03:28 PM
  3. VBA Code for file open, read, rename, delete
    By curiosity4learning in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2014, 11:05 AM
  4. [SOLVED] Open multiple PDF files from certain path
    By amoxia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2013, 07:36 PM
  5. Trying to Open Files Not Located in Specified Path
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2013, 12:40 AM
  6. [SOLVED] VBA - Open Excel Files with file path from Named Ranges
    By bbg22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-06-2012, 11:41 PM
  7. How to set GetOpenfile dialog start path to current open files path.
    By Michael Wise in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2010, 02:24 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1