Update links

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I have a problem trying to update links when it comes to
every month. I would like to create a program that
enables to change the tab sheet name (representing each
month) ... Let me give you an idea what I'm trying to do:

I've created a userform list down - to select a month and
from there, it should be able to update the links
afterwards.

The main workbook (='C:\\My Documents\Agencies\Bridges &
Tunnels\[ MTA Analysis.xls] contains a table with 10 rows
and 5 columns.

Each cell shows as follows...

='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$F$10
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$F$11
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$F$12
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$G$10
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$G$11
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$G$12

And now, I want to change the month from Jan to Feb and
update links afterwards (from another workbook which have
12 tab sheets).

='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb!$F$10
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb'!$F$11
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb'!$F$12
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb'!$G$10
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb'!$G$11
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb'!$G$12

Thanks in advance

Susan
 
Couldn't you just Edit|replace Jan with Feb (or whatever month you need).

But just to make sure, you may want to make it unique enough to not cause other
problems:

This looks like a pretty unique(?) string to me: "mta.xls]jan'!".

If you wanted a macro, record it when you select the range and make the change.


I have a problem trying to update links when it comes to
every month. I would like to create a program that
enables to change the tab sheet name (representing each
month) ... Let me give you an idea what I'm trying to do:

I've created a userform list down - to select a month and
from there, it should be able to update the links
afterwards.

The main workbook (='C:\\My Documents\Agencies\Bridges &
Tunnels\[ MTA Analysis.xls] contains a table with 10 rows
and 5 columns.

Each cell shows as follows...

='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$F$10
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$F$11
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$F$12
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$G$10
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$G$11
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Jan'!$G$12

And now, I want to change the month from Jan to Feb and
update links afterwards (from another workbook which have
12 tab sheets).

='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb!$F$10
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb'!$F$11
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb'!$F$12
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb'!$G$10
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb'!$G$11
='C:\\My Documents\Agencies\Bridges & Tunnels\[2003
MTA.xls]Feb'!$G$12

Thanks in advance

Susan
Click to expand...
 
Back
Top