View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fullers fullers is offline
external usenet poster
 
Posts: 30
Default 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.