Hi there,
I'm helping a friend out. Basically another programmer setup a spreadsheet to create some reports in excel. I have never done programming with excel or working with vba. This is my problem. When the user runs this spreadsheet they're getting this error:
Compile Error
Can't Find project or library
Then it brings up the "Microsoft Visual Basic" program, I guess it's vba. And there's a window ("Workbook","Open" method) with code and it highlights the first "Format" in this code:
sdatestr = Format(Year(Sheet1.SDate), "0000") & Format(Day(SDate), "00") & "0000"
Basically for me it seems that the program is looking for a function called "Format" but isn't this function built into excel vba? Any ideas which file/function is missing?
Thanks!
I'm helping a friend out. Basically another programmer setup a spreadsheet to create some reports in excel. I have never done programming with excel or working with vba. This is my problem. When the user runs this spreadsheet they're getting this error:
Compile Error
Can't Find project or library
Then it brings up the "Microsoft Visual Basic" program, I guess it's vba. And there's a window ("Workbook","Open" method) with code and it highlights the first "Format" in this code:
sdatestr = Format(Year(Sheet1.SDate), "0000") & Format(Day(SDate), "00") & "0000"
Basically for me it seems that the program is looking for a function called "Format" but isn't this function built into excel vba? Any ideas which file/function is missing?
Thanks!