+ Reply to Thread
Results 1 to 3 of 3

Let user select worksheets which a macro should work with.

  1. #1
    Registered User
    Join Date
    11-29-2010
    Location
    Belgium
    MS-Off Ver
    2010
    Posts
    87

    Question Let user select worksheets which a macro should work with.

    Hi,

    I've got a bit of a problem. I know that the below code will allow a user to select a workbook in a specific folder.

    Please Login or Register  to view this content.
    However is there a VBA code which allows the user to select variable worksheets within that workbook?

    The workbook they will select is containing multiple sheets based on weeknumbers. They need to be able to select variable worksheets which will then need to be processed by the macro.

    Can you pls help me out?

    Regards,
    Tino XXL

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Let user select worksheets which a macro should work with.

    Hello Tino XXL,

    However is there a VBA code which allows the user to select variable worksheets within that workbook?
    Yes, there are several ways to do it. Please upload a sample WorkBook, showing your exact setup and requirements, and let us see how we can help you.

  3. #3
    Registered User
    Join Date
    11-29-2010
    Location
    Belgium
    MS-Off Ver
    2010
    Posts
    87

    Re: Let user select worksheets which a macro should work with.

    Improvement tool.xlsxOrders dummy.xlsxHi Winon,

    Company policy doesn't allow me to release customer info, therefore I can only provide you with the workbooks without actual data.
    The user will be working out of the improvement tool. When he clicks the button the macro should take him to an "open file" dialogue box as described in my initial post. In the selected file (orders dummy) you'll find 4 seperate sheets. The user has to be able to define which 2 sheets he wants to work with. So he would be selecting them using the cntrl button.
    The macro then has to copy the contents of the selected AF sheet to the AF sheet in the tool, and also for the SF sheet he has to do the same.

    I hope my explanation makes some sense.

    Kind regards,
    Tino XXL

+ Reply to Thread

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