I'm having no success with Microsoft on this issue. I have Office 2016 Pro on my PC. I run macros on a weekly basis using it. I downloaded a spreadsheet from a very reputable source and he said that he used Office 365 to write the code for the macros, I tried to run his macros and I get a compile error: Can't find project or library. I've tried to update the Visual Basic for Applications only to find out that VBA isn't even on my PC. I have checked the VBA permissions text in the Trust Center and in going to the directory that I was told that VBA would be in, there's no VBA folder, like VBA isn't even on my PC. Updating the version of VBA is impossible because the update isn't reading that VBA is on the PC to update.
My question is two-fold. 1) I downloaded Visual Studio thinking that it would contain the necessary files to activate VBA on my PC. That didn't happen! So I need to understand the difference between VS and VBA? 2) Where can I get the regular VBA program? From everything that I've researched it should be included in my download of Office 2016 Pro. I've run the repair/modify option in Apps & Features and still no VBA on my PC.
Help Please!
My question is two-fold. 1) I downloaded Visual Studio thinking that it would contain the necessary files to activate VBA on my PC. That didn't happen! So I need to understand the difference between VS and VBA? 2) Where can I get the regular VBA program? From everything that I've researched it should be included in my download of Office 2016 Pro. I've run the repair/modify option in Apps & Features and still no VBA on my PC.
Help Please!