+ Reply to Thread
Results 1 to 2 of 2

PDF Export with overwrite existing file prompt

  1. #1
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    PDF Export with overwrite existing file prompt

    Hi,

    I have some code which creates a PDF copy of a worksheet (found on the net) but if the file exists already the Save As prompt doesn't give an 'Are you sure?' message to overwrite that file.
    As a result users may not realise what they are doing before its too late.

    Please Login or Register  to view this content.
    If anyone can offer an insight on how to solve this it would be mucho appreciated.

    Thanks
    Harribone
    Say thanks, click *

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: PDF Export with overwrite existing file prompt

    Maybe you can use File System Object library to check the file existence first before proceed.
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Save As-Overwrite existing File
    By loulorisgomez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2012, 07:24 AM
  2. [SOLVED] Macro with "save as" --- Need excel to overwrite a file without a prompt to overwrite
    By tsmith1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2012, 10:54 AM
  3. VBA Code to export Excel to OVERWRITE an EXISTING PowerPoint
    By rick_tiger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2012, 04:49 AM
  4. Export as Fixed Format macro not getting existing file prompt
    By httdy1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-24-2009, 04:03 PM
  5. Export And Overwrite Existing file
    By okelly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2007, 11:19 AM

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