My VBA macro and excel is crashing when Inam trying to open an file from the network location.It is working fine in windows 7 but not in windows 10

[Saswat Das]

My VBA macro and excel is crashing while opening a file from network in windows 10 but it works smoothly in windows 7


I am able to open if I run step by step using f9.

Actually the goal of the macro is to make a list of files having a certain date (which I figure out as the date is present in the file name) in the network and then by opening one by one file from that list copy paste and consolidate them in the master file.

Kindly help me in resolving the issu

 

[Yongle]

welcome to the forum
if you want help fixing a macro we need to see it
click on <vba/> icon and paste ALL of the macro between the code tags
do not try to format the code

[ CODE=vba ]YOUR CODE HERE [/CODE ]