+ Reply to Thread
Results 1 to 1 of 1

Close "already open pdf file" using macro made in excel 2010

  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    Gurgaon
    MS-Off Ver
    Excel 2010
    Posts
    6

    Close "already open pdf file" using macro made in excel 2010

    Hi friends,

    I am having problem in closing a "already open pdf file" using macro in excel 2010, can you guys help me in solving this.
    This problem is a small part of bigger program, in which i need to replace a pdf file with new pdf (basically overwrite), but i gets error if file is already open. So i have to close pdf file first, only then my program runs.

    Code that i am using is:-

    Please Login or Register  to view this content.
    Instead this code closes my vba application and neither brings pdf window upfront.

    Any help will be really appreciated.
    Last edited by Baghel; 07-17-2014 at 02:54 PM.

+ 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. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. Replies: 10
    Last Post: 11-22-2013, 04:58 AM
  3. [SOLVED] Must open and close UserForm twice for the other codes in the "Open..." Macro to execute
    By tnuis in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2013, 09:28 AM
  4. need VBA code to open a file type then do a "=countA(A:A)-1" and close it
    By BrandonFromSingapore in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2012, 12:19 PM
  5. how to close a file opened with "Workbooks.Open Filename:=sWb"
    By ggremel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2011, 10:37 PM

Tags for this Thread

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