![]() |
problems with "CurDir"
I have the following code from Excel 2003 and can not seem
to get it to work in Excel 2007. I get the error "Can't find project or library" on "CurDir". Any clues as to what I am doing wrong or what it got changed to? ' save the Drive letter and path strTmp = ActiveSheet.Evaluate(ActiveWorkbook.Names("drive.p ath").RefersTo)(1) If (strTmp < CurDir) Then ActiveWorkbook.Names.Add Name:="drive.path", RefersToR1C1:= _ "={" & Chr(34) & CurDir & Chr(34) & "}" End If |
All times are GMT +1. The time now is 06:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com