Migrating from Windows 7 to 365 (re: excel vba macros)

bravura

Board Regular
Joined
Jan 27, 2010
Messages
51
Good morning. first, many thanks for all the support in the past.

Our satellite office is migrating from Windows 7 to 365. The vba programmer there says that it's a large task to update the macros for this transition. if he's trying to run macros off multiple spreadsheets, he should be able to run them per normal - just change the file locations is what i'm thinking. Am i right or is there more to it. The macros don't do anything fancy, just reading from one or more excel workbooks and then update the open file. when people running the macro, they only need to open in excel (rather than sharepoint), correct?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Firstly, Windows 7 is an operating system and 365 is an Office subscription, so you can't move from one to the other.

It really shouldn't be a massive change in terms of the macros unless you're moving from a very old version of Excel in which case you might run into deprecated features.
 
Upvote 0

Forum statistics

Threads
1,223,693
Messages
6,173,868
Members
452,536
Latest member
Chiz511

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top