Updating files automatically using data from another workbook

Hi

I wonder if anyone can help?

I need to update the contents of several worksheets in an Excel workbook using data from another existing workbook. I can do this manually but it is rather tedious. I wish to build a macro to do it automatically and my problem is that I cannot remember the VBA code to open the filer window (directory) dialog box that will then allow me to browse for the file I want and to select it. I was shown how to do this once - a long time ago - but I cannot remember!

Does this make sense?

If anyone can help I would be extremely grateful

Thanks in anticipation

Andrew

Perhaps you mean GetOpenFilename? From Excel help:

This example displays the Open dialog box, with the file filter set to text files. If the user chooses a file name, the code displays that file name in a message box.

Please Login or Register  to view this content.

Stephen


Many thanks. That is just what I wanted - but couldn't remember.

Thanks for your prompt reply.

On with the work....

Andrew