Runtime error 438 after installing Microsoft Office 2013

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Hello all and thanks in advance for the help. I have a program that I use for work (I did not create the program nor am I extremely talented with excel coding) but there is a portion of the code that activates a new sheet, opens two websites within that sheet and the fills data into those websites. There are 2 instances within the program that do this, and both now generate the same error. This process worked in Excel 2010, but our work computers recently updated to Excel 2013 and I am now getting a runtime error 438. The only thing that has changed is the update from 2010 to 2013. Attached is a screenshot of the VBA code with the error highlighted for both instances. On the second screenshot, the user id and password, as well as the web address have been removed for security reasons.

    Any ideas on how to fix this? And please let me know if you need more information and I will do my best to provide it.

  • Re: Runtime error 438 after installing Microsoft Office 2013

    I have seen this when a fresh install took place where a reference to a library i used in my code needed to be added back in order to complete the task.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!