how do i set up opening a file from a cell in excel spreadsheet

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

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
 
Back
Top