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

1 Answers1

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
  • 18,752
  • 7
  • 68
  • 96
  • @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