+ Reply to Thread
Results 1 to 3 of 3

Save Macro Related question in Excel 2010

  1. #1
    Registered User
    Join Date
    09-23-2014
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    31

    Save Macro Related question in Excel 2010

    Hi All,
    I would like to thank you all for your help in advance here is my problem:

    I have a data coming from SQL
    All Data is displayed under the DATA tab
    I have created a table under Interface tab as well as some filter criteria using offset and count a. Filter is referencing Category tab.
    Rest of the tabs created are Pivot reports referring to the table on the interface tab depending on how it is filtered.

    Problem:
    I have many sites within the drop down as seen on screenshot #2

    I would like to create a macro where when the user clicks on export the spreadsheet should save a file for each site.
    - Export button pressed
    - First site selected
    - all reports generated (this is being done already per the selected site)
    - File saved as the Site name
    - Second site selected
    - File saved as site name.... and goes until all sites completed.

    I tried doing this manually by creating a macro and doing all manual however, during a macro record session the buttons I created are disabled.

    I would appreciate all the help.

    Report_1.jpgReport2.jpg

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Save Macro Related question in Excel 2010

    So, where exactly are you having difficulty?

    Also, post a workbook and not screenshots.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    09-23-2014
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    31

    Re: Save Macro Related question in Excel 2010

    The problem I am having is I can not create the macro where I can click on a button and it selects from the drop down saves the file1 then selects second item from drop down saves it as file2....etc.

+ 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 Excel 2010 Form as an Interactive Web Page - With Functioning Macro?
    By Herman Merman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2014, 12:15 PM
  2. [SOLVED] Save/Closed only macro related files and leave unrelated files open in excel?
    By rdowney79 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2013, 04:17 PM
  3. removing the save as option from Excel 2010 document with VB Macro
    By highnoon1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-04-2013, 02:52 PM
  4. PLEASE Help excel pro's (Macro, excel related)
    By msu4life in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2012, 02:42 PM
  5. Macro save to pdf excel 2010
    By areyoui in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2011, 11:16 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