+ Reply to Thread
Results 1 to 4 of 4

USERFORM to create new Book as a New report

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Montreal QC
    MS-Off Ver
    Office 365
    Posts
    25

    USERFORM to create new Book as a New report

    Hi I need help with this code: I have an Userform that shows when I click Button 1. This userform is created to be able to pull a report from the TAB: FIELDS. I do have problems getting the filter to work properly. The filter I need is in column B (Status) I need to be able to pull the report according with the code and save the new Book in a new file (Temp) if possible in a new FOLDER in the desktop. If anybody there can give me a hand... THANKS!! (see attached file)Test Financial Reporty.xlsm

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: USERFORM to create new Book as a New report

    Hi alopecito

    You were filtering on the wrong Column

    Try the attached...change this line of Code in AddBook
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    09-05-2012
    Location
    Montreal QC
    MS-Off Ver
    Office 365
    Posts
    25

    Re: USERFORM to create new Book as a New report

    Thanks my friend!

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: USERFORM to create new Book as a New report

    You're welcome...glad I could help.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    If this resolves your issue please mark your Thread as SOLVED.

    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:
    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ 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. Userform - Address Book
    By nancyching1711 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-18-2018, 11:39 AM
  2. Replies: 2
    Last Post: 12-04-2012, 10:21 AM
  3. Replies: 2
    Last Post: 06-29-2011, 04:35 PM
  4. Replies: 3
    Last Post: 08-23-2008, 06:01 PM
  5. how do i create an index for my book?
    By piodds in forum Excel General
    Replies: 2
    Last Post: 04-01-2005, 02:06 PM

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