I have macro that has been working perfectly, but when I moved the excel file to a new computer and tried to run it I get a compile error.
Here is the line that is in question:
strDate = Format((Date), "dd MMM yyyy")
The error looks like this.
Cant find project or library
and the date is highlighted blue
Does anyone know why this is suddenly happening?