display file open box
I want a macro that will display the box that allows you to choose a file and
the open it.
When I record the macro I get:
Workbooks.Open Filename:= _
"C:\Documents and Settings\PC User\My Documents\Electricity Bill.xls"
However, I wish the user to be abloe to choose the file and its location
within the box and then continue running the rest of the macro.
How do I do this?
Thanks in advance.
|