DWResource
Programmer
Hi,
I am trying to run a VBA macro from within Business Objects. This macro runs fine in windows 2000 but in XP pro it gives following error :
"Compile error"
"Can't find project or Library"
and it points to following line which appends a date field at end.
temp_file = "C:\temp\" & Rep.Name &
Format(Date, "yyyymmdd") & ".xls"
So basically it gives error in Format(Date,"yyyymmdd").
I am trying to run a VBA macro from within Business Objects. This macro runs fine in windows 2000 but in XP pro it gives following error :
"Compile error"
"Can't find project or Library"
and it points to following line which appends a date field at end.
temp_file = "C:\temp\" & Rep.Name &
Format(Date, "yyyymmdd") & ".xls"
So basically it gives error in Format(Date,"yyyymmdd").