Can not compile the VBA module

[DWResource]

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").

 

[PHV]

Check the references.
usually for microsoft VBEditor, menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DWResource]

Tools --> References

is grayed out ???

 

[PHV]

Seems the code is halted. Reinitialize the project.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DWResource]

I am a newbie to the VBA ??

How do I Reinitialize the project ??

Thanks Much

 

[PHV]

for microsoft VBEditor, menu Execution -> Reinitialize

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DWResource]

Thanks PH

I could not find the Execution Menu from within Business Objects and I don't have VB loaded.

But I did re-open the report and somehow this time the TOOL--> References Menu was highlighted, so I included some Microsofy libraries and it worked fine.

Thanks for your help....