open workbook

[LSGC]

Hi I have about 500 workbooks all of which are numbered with a number like 12345 I would like to put a
Number in cell a1 and for it to open the workbook corresponding to the contents of this cell .

Can anyone help?

[Aardigspook]

Best I can suggest is using HYPERLINK.
Format is =HYPERLINK(link location , friendly name)

Let's say all your files are in this folder: C:\LSGC\Data\Excel files
and that they are all .xlsx files
In B1, use this:

Please Login or Register  to view this content.

If A1 contains 12345, this will make B1 display '12345.xlsx', with a hyperlink to the file.

If you have a combination of file types (.xlsx, .xlsm, .xls, etc) then you could put a drop-down in A2 of the various types then use this:

Please Login or Register  to view this content.

Similarly, if the files are in different locations, but not too many, you could put those locations in a drop-down list in another cell and combine that in the formula:
A1 - file number
A2 - file type (.xlsx, etc)
A3 - folder drop-down (put a back-slash \ after each folder name)

Please Login or Register  to view this content.

In this case, you probably don't need the 'friendly name' part of the hyperlink, as you'll want to see all the details.

Hope that helps.