Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a cell "F10" on sheet 1 that contains the PATH for the file. I
have the following code which is working fine: Private Sub Workbook_Open() Application.Caption = ThisWorkbook.Path Sheet1.Range("F10").Value = ThisWorkbook.Path End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Upon opening the book, the Path is listed in the caption bar and updates F10 with the location. Upon closing it removes it from the caption bar. What I want to do is have that cell updated anytime the file is saved. I tried the following code. It did not give me an error but it also did not give me my desired result. Private Sub Workbook_AfterSave() Sheet1.Range("F10").Value = ThisWorkbook.Path End Sub What am I missing? Thank you for your help. RU |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup - Update Path | Excel Worksheet Functions | |||
Excel problems after winXP sp3 update | Excel Discussion (Misc queries) | |||
auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
Recurring Problems with Links with Full Path Names | Excel Discussion (Misc queries) | |||
More UDF problems; some won't update, some won't stop running! | Excel Programming |