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

Thanks.

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