Issue opening excel files via VBA

[Assamita]

Hi Excel gurus.
I have an automated process that, among a whole lot of other things, at one point, long story short, it opens some files from a network, copies the content from them and closes them again.

This process was working no issues in a local machine where the network servers were located. Recently, this process was moved to a virtual machine with access to this network, but in another server location.
Ever since then, looks like this process has some troubles opening some of these files, they get stuck in the Downloading screen, and don't open up until I hit "Cancel", which odd enogh, opens the file.

I suspect it might have to do with cache memory or something like that.
My code doesn't include any Set Excel.Application or Set wb = Nothing, or anything like that. It just opens the workbooks and closes them (I'm not a programmer, I'm just a self-learner with some-but-not-much programming knowledge). Could that be a reason? I don't know what the above statements actually do.

Thank you in advance

 

[baitmaster]

Please post your code

SET is used to assign a value to an object. So you have a workbook object (variable) called wb. Unlike a normal variable you can't just give it a value, you have to assign something to it so you would e.g.

Set wb = workbooks("workbook name")

to create the object variable. Then to clear memory later you would

Set wb = nothing

to clear it from memory.