Would someone explain why the following code creates a runtime error
The error is
Please Login or Register to view this content.
-----------
Run-time error"-214467259(80004005)':
Automation error
Unspecified error
I could add the WMP on a worksheet mannually.
Thanks
Last edited by Leith Ross; 04-28-2013 at 01:37 PM. Reason: Added Code Tags
Does this help any? (obviously position and size were arbitrary to testing)
BTW - All I did was record the manual placement of the controlPlease Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks