VBA Can't Find Project Or Library

[jo15765]

I copied a worksheet that I use all the time on another laptop to a flash drive and copied it to a new pc. The VBA runs perfectly on the other pc but on this 2nd pc I get a VBA Compile error of Can't find Project Or Library on this line of code

                .SaveAs Filename:="C:\" & "_" & VBA.Left(ActiveWorkbook.Name, VBA.InStrRev(.Name, ".") - 1) & "_" & VBA.Format(Date, "mmddyyyy") & ".xls"

And it is highlighting the word Date...Any ideas why it works on one PC and not on another?

 

[diddi]

in the VBE goto to tools>References
scroll down the list and there will be on which is ticked but "MISSING". untick at save the workbook.

thats it done. there must have been a 3rd party ocx on the other puta

 

[xenou]

One would imagine the missing library is "Visual Basic for Applications" here...

sometimes for reasons that will probably never be known this library gets de-referenced.

 

[jo15765]

It was Visual Basic for Applications. Thanks!