Carlee,
Check the help for Application.GetOpenFilename.

Then set a variable (instead of your current Const) to the return value.
Then .Open that, assuming the user did not cancel.

NickHK

"Carlee" wrote in message
...
Hi all,

I used the following code to open a file called 'Copreco Daily Submission
Reading' and import the ensuing record into the Daily Reading Master Log.

Question: I need to change the code, (and I dont know how), such that
rather than looking for the 'Copreco Daily Submission Reading' file, I
want
the user to be able to use the Browse feature to select any .xls file,
then
continue the process.

Cany anyone help me on this one?


Sub CopyFromCoprecoReading()
Call PasswordOff
'these have to do with THIS workbook
'name of the sheet to get data from
Const destSheet = "Daily Reading Master Log" ' in HQ master workbook
'****
---------------- CUT --------------------