Results 1 to 5 of 5

saving file in a macro

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-25-2008
    Location
    texas
    Posts
    178

    saving file in a macro

    How do I save the spreadsheet with the current name of the spreadsheet in a macro?

    Example:
    I want to save the spreadsheet to a network drive using the current name of the spreadsheet (it changes every other day). But I dont know to put the name in the SAVE statement. Here is what I have now:
    ActiveWorkbook.SaveAs Filename:="X:\DPR master.xlsm", FileFormat:= _
            xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
    So it always saves as "DPR master". I need it to replace this with the current name of the spreadsheet.

    Thanks
    Last edited by jartzh; 12-08-2008 at 04:08 PM.

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