Excel Macro Problem

[Annette]

I have a database with 98 sheets. One sheet for each bus in our fleet. I
need to updated the links for each sheet from xls to xlsm without changing
the bus number in the link. I used to be able to create a macro to make a
change in a few sheets in the old Excel and run it a couple of times until I
had changed each sheet. In the new Excel , I try to do that & it also
changes the bus number in the formula. Why and how can I stop it from doing
that? Example: the old link is ='F:\HOME\Passarea\MILEAGE\Mileage
08.09\[NOV08.xls]3'!$B$35. I need to change it to
='F:\HOME\Passarea\MILEAGE\Mileage 08.09\[NOV08.xlsm]3'!$B$35, 98 times. The
above example is for bus 3. In the past, I could change just one item in the
link and it would only change the one thing. Now it changes the number after
the ] (the bus number)on it's own. How can I stop it from doing that?

 

[ShaneDevenshire]

Hi,

I'm not sure why a macro is necessary, you could select all the sheets in
the workbook and press Ctrl+H, enter [NOV08.xls] in the Find what box and
[NOV08.xlsm] in the Replace with box, and click Replace All.

If this helps, please click the Yes button

 

[Annette]

Thank you so much. I was not aware that I could use that function on more
than one tap at a time. It works!
--
Annette

Hi,

I'm not sure why a macro is necessary, you could select all the sheets in
the workbook and press Ctrl+H, enter [NOV08.xls] in the Find what box and
[NOV08.xlsm] in the Replace with box, and click Replace All.

If this helps, please click the Yes button
--
Thanks,
Shane Devenshire

I have a database with 98 sheets. One sheet for each bus in our fleet. I
need to updated the links for each sheet from xls to xlsm without changing
the bus number in the link. I used to be able to create a macro to make a
change in a few sheets in the old Excel and run it a couple of times until I
had changed each sheet. In the new Excel , I try to do that & it also
changes the bus number in the formula. Why and how can I stop it from doing
that? Example: the old link is ='F:\HOME\Passarea\MILEAGE\Mileage
08.09\[NOV08.xls]3'!$B$35. I need to change it to
='F:\HOME\Passarea\MILEAGE\Mileage 08.09\[NOV08.xlsm]3'!$B$35, 98 times. The
above example is for bus 3. In the past, I could change just one item in the
link and it would only change the one thing. Now it changes the number after
the ] (the bus number)on it's own. How can I stop it from doing that?

 

[ShaneDevenshire]

Glad to help!
--
Thanks,
Shane Devenshire

Thank you so much. I was not aware that I could use that function on more
than one tap at a time. It works!
--
Annette

Hi,

I'm not sure why a macro is necessary, you could select all the sheets in
the workbook and press Ctrl+H, enter [NOV08.xls] in the Find what box and
[NOV08.xlsm] in the Replace with box, and click Replace All.

If this helps, please click the Yes button
--
Thanks,
Shane Devenshire

I have a database with 98 sheets. One sheet for each bus in our fleet. I
need to updated the links for each sheet from xls to xlsm without changing
the bus number in the link. I used to be able to create a macro to make a
change in a few sheets in the old Excel and run it a couple of times until I
had changed each sheet. In the new Excel , I try to do that & it also
changes the bus number in the formula. Why and how can I stop it from doing
that? Example: the old link is ='F:\HOME\Passarea\MILEAGE\Mileage
08.09\[NOV08.xls]3'!$B$35. I need to change it to
='F:\HOME\Passarea\MILEAGE\Mileage 08.09\[NOV08.xlsm]3'!$B$35, 98 times. The
above example is for bus 3. In the past, I could change just one item in the
link and it would only change the one thing. Now it changes the number after
the ] (the bus number)on it's own. How can I stop it from doing that?