I have an xls Filename C:// ... that is referrenced in my current workbook. However, I need to change the filename based on values of certain cells, i.e.:
2009 Q2 Laptop
2010 Q2 Laptop
2009 Q3 Keyboard
etc.
I have a string in one cell that contains the changing file name based on cells using C3 & " Q" & D3 (a concatenation)
How do I turn this string into a function, as if I had typed = and then entered the string myself???
Bookmarks