rjfields
asked on
Excel 2010 "Can't find Project or Library"
I have a worksheet that worked fine in XP Pro but fails in Windows 7 at the "trim(str(.,.)"
at the bottom of this snipppet saying "Can't find Project or Library". I thought trim and str were internal functions.
Thanks for any help and happy thanksgiving!
Private Sub cmdOutPut_Click()
Dim fname As String
Dim TParkId As String
Dim wsTabFile As Worksheet
Dim rngInput As Range
Dim rngDepDate As Range
Dim a As Currency
Dim i As Integer
Dim j As Integer
Dim vData As Variant
Set wsTabFile = Worksheets("Computer")
Set rngInput = Range("tblInput")
Set rngDepDate = Range("depDate")
TParkId = wsTabFile.Range("PropNum")
fname = "\OT" & Trim(Str(Month(rngDepDate) )) & Trim(Str(Day(rngDepDate))) &
Trim(Str[(Year(rngDepDate) )) & "R" & Range("ReportNum") & ".txt"
at the bottom of this snipppet saying "Can't find Project or Library". I thought trim and str were internal functions.
Thanks for any help and happy thanksgiving!
Private Sub cmdOutPut_Click()
Dim fname As String
Dim TParkId As String
Dim wsTabFile As Worksheet
Dim rngInput As Range
Dim rngDepDate As Range
Dim a As Currency
Dim i As Integer
Dim j As Integer
Dim vData As Variant
Set wsTabFile = Worksheets("Computer")
Set rngInput = Range("tblInput")
Set rngDepDate = Range("depDate")
TParkId = wsTabFile.Range("PropNum")
fname = "\OT" & Trim(Str(Month(rngDepDate)
Trim(Str[(Year(rngDepDate)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Referencing Access because that's where I do most of my VBA coding, by the way -- still relevant to Excel. (for clarity) :)
http://support.microsoft.com/kb/283806
The functions you referenced are "internal" in the sense that they're housed in an object library for Excel that's "checked" by default in the references page. If the KB article doesn't work, try unchecking the MS Excel Object Library that's already marked, saving your changes, and "re-checking" it.
If it's not checked in yours, you may want to just scroll down in the Tools -> References dialog and look for the MS Excel Object Library ##.# (highest number) and try that.
References are tricky sometimes and I've had them give odd errors in the past since Access 2007 (Good 'ole Access '97 never gave those errors!!!). :)
Sean