Migrating from Office 2013 to 2016 and VBA problems in Excel

[mark hansen]

One section using worksheets I created has moved from Office 2013 to 2016 and started experiencing issues. Are they any coding differenced I need to look out for?

Their spreadsheet renames a data file, imports that data file and moves it to backup location. All of this happens when the receiving file is opened to get any new data. (This data text file receives information from another spreadsheet used by many people and the renaming allows the people sending data to have a datafile to send information into. If it's not there, it recreated.)

Due to the recent Covid issues, most are working at home via a VPN and I originally thought this was due to any possible delay in actions, on the network storage folders, because of network traffic. But they say they have been working from home for two months and the errors started after they got upgraded to Office 2016, two weeks ago.

When the proper files are moved to the backup location, and I walk through the code, it all works. The code is running much slower and the network storage folders, through the VPN, have time to react. I'm on the VPN too. At least that's my thought, it may not be the cause.

Any where in particular I should look?

Thanks,
Mark

 

[Joe4]

I am in a similar situation, where I used to work in the office, but now working from home via VPN.

One of the first issues I encountered was that I was not automatically mapped to all the network drives. So the Security folks created a little executable file that I need to click after logging it to map my drives. So you may want to verify that they all still have acccess to all the drives the files and macros need.

When upgrading to a newer version of Excel, most of the time, the code will still work (downgrading is a different matter). However, there are two things you may need to check for:
1. Make sure that Macros/VBA are still being enabled (security settings may have changed)
2. Make sure that all the same VBA libraries are selected

For this second item, go to a computer where everything works properly, open the Excel file with VBA, go into the VB Editor and go to the Tools menu, and select References. Note all the References that are selected. Then go to a computer that is NOT working correctly, and do the same thing and check if all the same references are selected. If not, you may need to select the missing ones from the list (the version number may change slightly).

Hope one of these things helps with your predicament!

 

[mark hansen]

Joe,
Thanks for your input, I didn't think about the references. I'll check on that.

I use many folders in the network drives and use UNC addresses for all of them, so hopefully it's not that.

I appreciate your ideas, thanks!!
Mark

 

[Joe4]

You are welcome.

I use many folders in the network drives and use UNC addresses for all of them, so hopefully it's not that.

You may just want to check to confirm that they still have access to them all.