Running a Visual Basic excel sheet on Mac
Running a Visual Basic excel sheet on Mac
Author
Discussion

andygo

Original Poster:

7,422 posts

286 months

Monday 29th October 2018
quotequote all
I have Office 2016 for mac and need to run an Excel spreadsheet from work on my mac that originally was written for windows.

I can open it on my mac but can't input the values into the spreadsheet that has been custom built. I don't think the sheet is too complicated in itself, its just designed with a nice UI and is a finance payment calculator - eg money borrowed/term/interest rate inputs cough out the monthly payments and interest rates etc.

Is there any way to get this to run?

At the moment I have to use my Windows lappy to run it and then faff about with printer cables to get it to print instead of my Mac and use an usb stick to copy the quote over to Mac.

Oh, the third world problems of working from home 2 days a week!

a7x88

795 posts

179 months

Monday 29th October 2018
quotequote all
Excel is awful on OSX. Anything with VBA is disastrous - I usually resort to a Windows 10 VM when i need to run anything like that

andygo

Original Poster:

7,422 posts

286 months

Monday 29th October 2018
quotequote all
I gathered that from my pal google that may be the case, but thought that the 2016 office iteration had sorted the issue out.

That’s a pain, don’t really want a Windows install near my Mac, lol

Murph7355

42,082 posts

287 months

Monday 29th October 2018
quotequote all
Excel 2016 is fine on a Mac, except..... VBA smile

I wouldn't worry about Windows 10 though. It's a decent OS. So you must run VBA equipped sheets, spin one up smile

andygo

Original Poster:

7,422 posts

286 months

Tuesday 30th October 2018
quotequote all
I have a W7 disc, can someone point me in the direction of how to do the VM thing please?

a7x88

795 posts

179 months

Tuesday 30th October 2018
quotequote all
There's a few options - bootcamp (free I think), parralels and VMWare. I use VMWare solely as its what I get provided by work.

Bootcamp would probably be the cheapest / easiest to try. Run a Google search and there's plenty of walkthrough guides for setting it up

a7x88

795 posts

179 months

Tuesday 30th October 2018
quotequote all
Murph7355 said:
Excel 2016 is fine on a Mac, except..... VBA smile
I find even large sheets with a couple of pivot tables and macros are painfully slow - especially compared to windows. It's getting to the point I'm considering going back to windows 10. It's not like the MacBook is old either - it's a late 2016 MBP Touch with the 2.7Ghz i7 quad core and 16Gb ram.

andygo

Original Poster:

7,422 posts

286 months

Tuesday 30th October 2018
quotequote all
I have got parallels installed on my mac now. However my office software is on dvd and my mac doesnt have a dvd drive.

I have copied the Office DVD to an external USB disk drive, but cant find a way for the parallels control centre to install it.

Any ideas folks?





Du1point8

22,982 posts

223 months

Tuesday 30th October 2018
quotequote all
andygo said:
I have got parallels installed on my mac now. However my office software is on dvd and my mac doesnt have a dvd drive.

I have copied the Office DVD to an external USB disk drive, but cant find a way for the parallels control centre to install it.

Any ideas folks?
https://kb.parallels.com/en/119310
https://kb.wisc.edu/page.php?id=46058

andygo

Original Poster:

7,422 posts

286 months

Tuesday 30th October 2018
quotequote all
I worked it out by using windows as, er, windows, lol.

My spreadsheet works fine!

Thanks for the pointers chaps, although parallels is a bit pricey at £70.

Murph7355

42,082 posts

287 months

Tuesday 30th October 2018
quotequote all
a7x88 said:
Murph7355 said:
Excel 2016 is fine on a Mac, except..... VBA smile
I find even large sheets with a couple of pivot tables and macros are painfully slow - especially compared to windows. It's getting to the point I'm considering going back to windows 10. It's not like the MacBook is old either - it's a late 2016 MBP Touch with the 2.7Ghz i7 quad core and 16Gb ram.
I had a not dissimilar spec machine and used Excel a lot and it seemed fine to me.

Still, Win10 in Pro form is a decent enough OS, so I wouldn't worry about that.

Lenovo's X1 Carbons are excellent machines to go with it. Only real shortfall is no ambient sensor for they keyboard back-light. (A bearable but dumb omission).

a7x88

795 posts

179 months

Wednesday 31st October 2018
quotequote all
My previous laptop was an X1 Carbon and I was a big fan. I ony went with OSX as I'm in networking and the native terminal with SSH (and telnet after adding homebrew) was much nicer than having to use putty or similar.