| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Link
Can anyone help me solve this problem please. When I type a month in
cell "A1", say for example "August", how can I get it to change the "July" in the link below to "August". =+'[2XDA_Adults_Services July Monitoring Summary.xls]2XDB'!$P$73. Many thanks, Ola. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Link
Sub updatelinks()
Myformula = Range("A1").Formula Myformula = Replace(Myformula, "July", "August") Range("A1") = Formula End Sub "Ola2B" wrote: Can anyone help me solve this problem please. When I type a month in cell "A1", say for example "August", how can I get it to change the "July" in the link below to "August". =+'[2XDA_Adults_Services July Monitoring Summary.xls]2XDB'!$P$73. Many thanks, Ola. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Link
Check your other post.
Ola2B wrote: Can anyone help me solve this problem please. When I type a month in cell "A1", say for example "August", how can I get it to change the "July" in the link below to "August". =+'[2XDA_Adults_Services July Monitoring Summary.xls]2XDB'!$P$73. Many thanks, Ola. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link from Chart File to Data File / Format Problem | Charts and Charting in Excel | |||
| Hyperlink Link Field to link to file on website | Excel Programming | |||
| Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
| Link footer of one file to cells in another file | Excel Discussion (Misc queries) | |||
| How to make a routine that will automatically print a word file after it has been changed via an ole link to an excel file? | Excel Programming | |||
Linear Mode
