Macro to replace part of a formula

[Pedro Morais]

Hey guys,

I'm trying to create a macro to replace a link on a formula.
The formula is as below
='[Players Report 31121999.xls]Player1'!$AK$23

Where 31121999 is the date. there's a workbook everyday with different sheets for every player
I want to have a macro that gets the date I inputed in another cell and changes the date in the formula I displayed above (just changing the date).
Do you guys think thats possible?

Cheers
Pedro

 

[Greg Truby]

Is the other workbook (Players Report 23112007.xls) open? If not, open it and see if that solves the problem. If this is going to be a problem, see schielrn's first post about trying out morefunc.

 

[Pedro Morais]

yeah..it's open

 

[Pedro Morais]

DONE!!!

 

[Pedro Morais]

It's working now!
there was missing a [ in the formula...

Brilliant job guys!