Excel macro to allow user to open different files

[dzuspann]

I need a macro that allows a user to select a file to open and then macro will run its course.

I have it working now but the file name is fixed. I want to allow the user to open any file.

[broro183]

hi,

Welcome to the Forum

Look up "GetOpenFilename" in the VBE Help Files or do a site/google search for it.

Goodluck
Rob