Opening Open File Dialogue box from Excel97

S

Scampa7

I am trying to develop an extension to a database in Excel97 that woul
display the contents of a folder showing all Word files for
particular record.

I need to setup a macro to open some sort of 'Open File' dialogue bo
that would show all these Word files in the specific folder relating t
that record. The folder name would be defined by a variable from a cel
on the worksheet e.g. ABC-1254-03 where 1254 is the cell's value.

Obviously it would then need to allow any of these Word files to b
opened from this box.

Any help with this would be most gratefully received
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top