Path not found err 76 in excel/vba

[taupirho]

My excel/vba sheets are all erroring with this message
Run Time Error 76 Path Not found

It happens when I do an application.quit from vba

I created a test case with a blank worksheet and a
one line macro

sub test()
application.quit
end sub

On stepping thro the macro sure enough the run time error appears on the quit line

Anyone seen this before? I'm running EXCEL 2003 SP2 on windows XP Pro.

 

[taupirho]

This is now sorted. Problem was linked to a 3rd party add-in

 

[rani14]

taupirho,

I am having a similar problem. What was your solution? I also have 3rd party software installed. Thanks.

 

[taupirho]

My problem concerned some add-ins from Bloomberg. I don't know why it happened in the first place, but basically deleting the add-ins and re-applying them (by browsing for them - not just re-clicking the check-boxes) fixed my problem.

 

[rani14]

I actually have Bloomberg as well, so I must be having the same problem. What exactly did you do? You just uninstalled the add-ins, and then re-installed them?

 

[taupirho]

In EXCEL Tools->Add-ins

Unclick the checkboxes corresponding to your BB add-ins

Assuming you have the same or similar problem as me e.g error on application.quit try out a test spreadsheet with this line in a macro and see if your problem disappears. If it does go back to your add-ins pop-up and click on the browse button. Search for your bloomberg add-ins - on my system these were in c:\blp\api\dde and c:\blp\api\office tools - double click on the appropriate files to add them back in. Say YES to any messages about them already existing. Retry your test spreadsheet and see if it now works.

As you probably know BB have recently upgraded a lot of their API's etc and IMHO the've made a right a**e of it.