Any help would be greatly appreciated

I am getting an error when I close the Excel file which contains my macro.
The file will open and run the macro fine.
The macro enables the user to browse for a csv file using the GetOpenFileName function.
It also allows the user to browse for folders using an API call.
It then opens the csv file selected from the GetOpenFileName dialog box and transfers the data to a new workbook and saves the new workbook in the folder selected using the API call.
The new workbook sucessfully saves and closes without problem

The problem I am encountering is when I try to close the workbook which contains the macro. If I save then close it closes without problem.
If I try to close without saving changes then I get an error that "Microsoft Excel for Windows has encountered a problem and needs to close". And it prompts to send an error report to Microsoft...

I have sent the report and updated my Office apps from the Office update.

Any suggestions?

I am running Windows XP Professional and Excel 2000

Thanks