Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    1

    Unanswered: Call to open specific file

    I need an excel macro to allow the user to input the name of the file to open since it will change weekly.

    Thanks.

  2. #2
    Join Date
    Feb 2006
    Posts
    113
    Hi Renee.

    Maybe try one of Excel's built in dialog boxes, or an input box, or a custom form. Or could the user simply enter the name in a worksheet cell?

    GetOpenFilename is sometimes used for this sort of thing.

    There are a number of approaches depending on your situation.

    I hope these leads are enough to help you.

    regards,
    Fazza

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •