0

Upgrade to VS 2017 and now I there is no references available to Microsoft.Office.Interop.Excel

Where did the reference go?

user3207693
  • 33
  • 1
  • 4
  • Did you try add reference > select "Assemblies" > "Browse" > C:\Program Files (x86)\Microsoft Visual Studio 17.0\Visual Studio Tools for Office\PIA\Officexx ? – QHarr Mar 27 '18 at 13:47
  • The installation did not create a a folder \Microsoft Visual Studio 17.0\. I reinstalled the program twice. I also Installed the Office developer tools for Visual Basic. Under Individual componets in the Visual Studio 2017 Installer. – user3207693 Mar 27 '18 at 13:55
  • see answer below. (It's a good idea to check Google before asking.) Remember the folder path may vary on your machine. You might need to poke around a bit, both on your machine, and on Google. – ashleedawg Mar 27 '18 at 13:55
  • 1
    where are the VS program files housed then? Should be listed on your environment path I am guessing if not search .... – QHarr Mar 27 '18 at 13:57
  • The visual studio is in C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional. I searched for the Visual Studio Tools for Office and the folder does not exist. – user3207693 Mar 27 '18 at 14:07
  • 1
    Did you select Microsoft Office Developer Tools for installation initially? https://stackoverflow.com/questions/21986323/cannot-find-microsoft-office-interop-visual-studio?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa – QHarr Mar 27 '18 at 18:17

2 Answers2

0

You should be able to "Add reference", select "Assemblies", press the "Browse" button, traverse to a path along this line (most likely close to your machine but slightly different):

C:\Program Files (x86)\Microsoft Visual Studio 14.0\Visual Studio Tools for Office\PIA\Office15

Then you should see to select:

img

(Source Stack Overflow user: @karen-payne)

ashleedawg
  • 20,365
  • 9
  • 72
  • 105
  • @karen-payne **"ping!"** (I wasn't sure if the in-answer tag would ping you.) – ashleedawg Mar 27 '18 at 13:55
  • The issue was resolved by removing any reference This includes deleting from the registery. The uninstall did nor remove everything.to a previous version of Visual Studio. – user3207693 Mar 28 '18 at 15:21
0

Go to Visual Studio Installer under Individual Components and click 'Office Developer Tools for Visual Studio. This solved it for me after lots of headaches.

Go to Visual Studio Installer under Individual Components and click 'Office Developer Tools for Visual Studio.

Dan
  • 174
  • 1
  • 2
  • 11