Macro with formula??? 2

[Tuff]

Hi Guys,

Just wondering if it is possible to link a macro to a cell value within a spreasheet.

ie change the following:
"\\finance\group\Accounts\TH\Uploads\MUP\2003-04\Nov03\M03105.xls"

To say something like this??
"\\finance\group\Accounts\TH\Uploads\MUP\2003-04\Nov03\="b5".xls"

Changing the final file name to a formula??

 

[dyarwood]

Yes.

use

filenam = Range("B5&quot.Value
"\\finance\group\Accounts\TH\Uploads\MUP\2003-04\Nov03\" & filnam & ".xls"

That will add in the value of B5 to the filename in the place you wanted it

dyarwood

 

[TonyJollans]

Hi Tuff,

You can refer directly to the cell like this ..

 "\\finance\group\Accounts\TH\Uploads\MUP\2003-04\Nov03\" & [b5] & ".xls"

Enjoy,
Tony

 

[Tuff]

Thanks heaps guys.

Much appreciated.