Results 1 to 10 of 10

Export as Fixed Format macro not getting existing file prompt

Threaded View

httdy1 Export as Fixed Format macro... 08-21-2009, 02:22 PM
shg Re: Export as Fixed Format... 08-21-2009, 02:46 PM
shg Re: Export as Fixed Format... 08-22-2009, 04:55 PM
httdy1 Re: Export as Fixed Format... 08-24-2009, 02:02 PM
shg Re: Export as Fixed Format... 08-24-2009, 02:10 PM
  1. #1
    Registered User
    Join Date
    08-20-2009
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Angry Export as Fixed Format macro not getting existing file prompt

    I am using a macro (excel 2007 sp2) to export an excel document of a purchase order to a PDF and saving it to a specific location on the server with the name of the file coming from a cell range to name the file as the purchase order number. The problem is that if the PDF already exists of the same name, I am not getting the prompt to replace the existing file and it is just overwriting the file. Here is the code of my macro:


    Sub Macro1()
    
    Application.DisplayAlerts = True
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, OpenAfterPublish:=True, Filename:= _
    "S:\Office Documents\Purchase Orders\" & ActiveSheet.Range("F5").Value
    Quality = _
    xlQualityStandard
    IncludeDocProperties = True
    IgnorePrintAreas = False
    
    End Sub

    I would greatly appreciate any help I can get so I can release this document for use in our office. I just really want to make sure that no files are that easily overwritten.
    Last edited by httdy1; 08-21-2009 at 04:40 PM. Reason: Needed to use tags

Thread Information

Users Browsing this Thread

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

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