Open existing workbook
hi,
here is a way to call the open dialog box.
Application.Dialogs(xlDialogOpen).Show
You can work it into your code.
reguards.
-----Original Message-----
Hi all experts,
I have a set (3) of workbooks that open from a shortcut
on the desktop. When
the workbooks are open I want to give the user the
possibility to open an
already existing workbook to replace one of the open
workbooks (the one on
the button to open an existing book) and leave the 2
other workbooks that
are already open. So the user needs to see a windows file
list to choose
from, select a file and than the macro should run further.
I have no idea on how to start on this.
Thanks for any valued help.
Daniel
.
|