VBA error by opening other workbook on the network

[FvdF]

Dear forum readers,

I have a very annoying problem with an excel sheet. It contains a lot of vba code and macros but it often goes wrong with one specific code.
That code opens another sheet on our network and copies data into it, to which all further actions must proceed.

Can someone help me with this short information? Why does it always go wrong on this line? I almost always have to reboot my PC, but sometimes a second time works too

Kind Regards,
FvdF

[Greg M]

Hi there,

Posting your code is much more useful than posting a screenshot of it - who wants to try to recreate that highlighted line by typing it in manually?

I can't suggest how to stop the error from occurring, but you could use "Dir" to determine whether or not the file can be located before trying to open it:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M