Results 1 to 6 of 6

VBA for file save as macro enabled to a specifi path and folders

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    116

    VBA for file save as macro enabled to a specifi path and folders

    Hi All
    Can you please assist me with writing a vba script that will save the workbook as a macro-enabled workbook to a specific path and folder and sub folders.
    The workbook name should default to the same as Final Sheet, Cell B4, followed by space hyphen space and Cell B9 in format yyyymmdd OR can be user defined. I tried using a borrowed code, but it would not let me save as a file name, but came up to the Folder name only.
    Can you please help? Thanks

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Save a Macro Enabled Template to a custom location with a custom file name.
    By andcha in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-24-2013, 11:46 AM
  2. Macro to save sheet as CSV using a dynamic file name and file path
    By chris.tinta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2013, 10:45 AM
  3. Replies: 5
    Last Post: 03-21-2013, 07:34 AM
  4. Macro to paste name of all the folders in a particular Path
    By ganeshmendon8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-10-2012, 05:58 AM
  5. File path of DIrectory and Folders only
    By teachMeExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2009, 11:02 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