+ Reply to Thread
Results 1 to 1 of 1

VBA - Macro to Save Multiple Template Files

  1. #1
    Registered User
    Join Date
    04-06-2021
    Location
    East Coast, USA
    MS-Off Ver
    Office 365 2016
    Posts
    1

    VBA - Macro to Save Multiple Template Files

    As with most people, I'm new to VBA and I'm looking for some guidance.

    I created a master template which will generate and then save a version for each department I oversee. To do this, I embed a macro which will:

    1. Pull information from an Essbase Retrieve tab​
    2. Populate that information in a Summary tab​
    3. Hide zero sum rows on Summary Tab​
    3. Save the information as it's own filename​
    4. Unhide all rows, then move on to the next BU listed on a BU List tab and repeat​

    For some reason, I keep running into an error at the end of the script: Run-time error '1004'. I've been trying to remove .Select from my code, which is reflected below, but maybe I didn't do this properly? I've inserted a scrubbed version of my BU list to give context to my code.

    One final issue is the last line of code - application.statusbar. For some reason it stops at 86% and will not update the status beyond that. I also attached a screen shot of my 'BU List tab.' Any advice is appreciated!

    Please Login or Register  to view this content.
    Attached Images Attached Images

+ 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. Macro to PDF multiple tabs and save in same file as the template is saved in
    By kdobler in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-21-2018, 11:16 PM
  2. Macro to save multiple text files
    By sunny81 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2015, 03:47 PM
  3. Macro to open multiple files, remove header and save multiple files in a new format
    By twocircles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 05:24 PM
  4. Macro To save multiple Excel sheets to multiple (individual) PDF Files
    By Keith Edgar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-21-2014, 12:51 PM
  5. Macro to copy rows from mastersheet to standard template and save as different files
    By makesure in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2012, 06:49 AM
  6. Run Macro on multiple files and save filename
    By anrivel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2011, 03:03 PM
  7. Macro on multiple files and save in other fileformat
    By soreno in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-10-2010, 04:59 AM

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