I use win 7 on a 64bit in my home office, and it has come very complex macro's, i just purchased a mac air book (was the lightest and most powerful computer i could find 3 ghz overclocked with 8 gb if ram i dont travel all that much but when i do i do need to run and support my web site and acquire data using this macro. One i got everything up and installed and tried to run any of those macro none of them would execute it's important that i keep the same revision on my clowd service for that i can access any of them etc i can supply you with any of the excel files so that you can see the error for yourself.
Microsoft Office is available in two ways: a one-time purchase of a specific version, and as a subscription service. For the Student one-time purchase version, you will get Microsoft Office Word, Excel, PowerPoint and OneNote. The Home & Business version has those listed above, plus Outlook. Microsoft Excel 2019 for Mac. Microsoft Office 2019 Home and Business for Mac. BACK TO THE TOP. Microsoft Office for Mac Software. Functionality and Flexibility. Microsoft Office for Mac software is the perfect array of business and study tools for Apple users. I just purchase Microsoft.
It's in module for and ref page formatting and all the other that are normally created when you setup any macro my only option if i can get this to work would be to return the air book as it was a condition of my purchase, although i only have a week to resolve it. I'm not in agreement with Bob's statement that query tables are not supported on the Mac in VBA. QueryTabels are supported, but the set of features supported is smaller. There is a code sample on this page that shows all of the QueryTable properties supported: what you are saying is true, and i do agree.
I just dont want the extra added steps and the possibility of having multiple copies of the same spreadsheet i took a easy way out and setup VM fusion on the mac (didnt want to take it back, just a very nice light and easy computer to use, ran the macro as they are working fine. So for 10 day as year i have what i need to get the job done and still have light and easy. My only extra expense was a additional 64 bit version of windows lic for the mac, i'm happy now as all is working fine tks for all the help in my fire drill.
Work with anyone. Every Mac comes with Pages, Numbers, and Keynote — powerful productivity apps from Apple that help you create stunning documents, spreadsheets, and presentations.
You can collaborate with one person or many people to create and edit Pages, Keynote, and Numbers files. And everyone can work on the same document at the same time — from across town or across the globe. You can also open, edit, and save Microsoft Word, Excel, and PowerPoint files with these apps, so you can easily work with others, regardless of whether they’re on a Mac or PC. A Mac can even run Windows. Have a Windows application you need to use once in a while?
Every new Mac lets you install and run Windows at native speeds, using a built-in utility called Boot Camp. Setup is simple and safe for your Mac files. After you’ve completed the installation, you can boot up your Mac using either macOS or Windows.
(That’s why it’s called Boot Camp.) Or if you want to run Windows and Mac applications at the same time — without rebooting — you can install Windows using VMware or Parallels software.