4 The updates will be delivered to you via a free Web Edition of this book, which can be accessed with any Internet connection. Note: "Moving to another computer" simply consists of copying the DOCM or XLTM file to the device and opening it. 4 As Microsoft makes significant updates to Excel 2016, sections of this book will be updated or new sections will be added to match the updates to the software. Not sure if once I fix the above if I will need to re-write it in a 64bit version of Office. This appears to be related to the same error, as it errors on the same line of the ListView code. ClassFactory cannot supply selected class.
Though we have very few 64bit versions of Office, a different error is raised if opened on a device running the 64bit version of 2010: Available references: Visual Basic for Applications (checked) Microsoft Excel 15.0 Object Library (checked) OLE Automation (checked) Microsoft Office 15.0 Object Library (checked)If it is in a different location than it was previously, uncheck the old MISSING reference and browse to the new location and add a reference to the file, making sure.
If I can't find a way to get this control to register programmatically, then this application I wrote is just not going to get acceptance. Copy/install the relevant file on your new computer if it is not present. There is no package and deployment wizard available in the Office version of the IDE, and even though I can probably find this, my end users will not go through the process of "installing" an Excel or Word document.
#REFERENCES VBA PROJECT EXCEL 2016 CODE#
You can probably guess that when I add it and name it the same as how my code is addressing it, this will then work on the other computer as designed. If I were to go into the IDE on the "foreign" computer and open up the form in design, the ListView is not there.
#REFERENCES VBA PROJECT EXCEL 2016 WINDOWS 7#
All are using the same version of office, using Windows 7 Enterprise, and all will have the ListView 6.0 under the component's menu, just not selected. It functions perfectly on my device, but when I execute the program on another computer, the code raises an object error on the first line that addresses my ListView control:Īll the computers in my company are configured/imaged the same way.
In trying to load into a corporate environment it errors at the point where it calls the object. It then became available to add as a component. I created an excel vba project that uses a number of scripting objects. In order to do this I had to open the tools window, right click on it, and select ListView as a component. Within the VB IDE I created a form for which I added a ListView control to. I developed a program in Word and Excel version 2010 using VBA.