I am trying to link files to a spreadsheet, I want to be able to type a file
name into a box and then have a formula or macro to open up that file. these
files will change with every spreadsheet, as they are for a quoting system

What's happening with your previous post

Sub Macro()
Workbooks.Open Cstr(Activeworkbook.Sheets("Sheet3").Range("a1"))
End Sub

If you are new to macros..

--Set the Security level to low/medium in (Tools|Macro|Security).
--From workbook launch VBE using short-key Alt+F11.
--From menu 'Insert' a module and paste the below code.
--Get back to Workbook.
--Run macro from Tools|Macro|Run <selected macro()

If this post helps click Yes
---------------
Jacob Skaria


"Scott" wrote:

I am trying to link files to a spreadsheet, I want to be able to type a file
name into a box and then have a formula or macro to open up that file. these
files will change with every spreadsheet, as they are for a quoting system