Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-17-2016, 12:04 PM
Katherine1995 Katherine1995 is offline Run-time error '-2147467259 (80004005)': Method 'Insert' of object 'BuildingBlock' failed Windows 10 Run-time error '-2147467259 (80004005)': Method 'Insert' of object 'BuildingBlock' failed Office 2016
Novice
Run-time error '-2147467259 (80004005)': Method 'Insert' of object 'BuildingBlock' failed
 
Join Date: Nov 2016
Posts: 4
Katherine1995 is on a distinguished road
Thumbs up Problem resolved....(RCA: ActiveX content controls in Building Block)


Hi,

The above change in Range did not work either. The problem was the content controls in the building block. INSERT does not work in a loop if building block has any ActiveX component as it has to assign unique name for each of them at every INSERT in the document and I was initializing them on document OPEN & NEW event. So, when I redefined the blocks with non-ActiveX drop downs it just worked.

@ guessed : Thanks for all your help.

Cheers
Reply With Quote
Reply

Tags
bookmark, building blocks, insert



Similar Threads
Thread Thread Starter Forum Replies Last Post
ADODB import of Excel data results in "Run-time error -2147467259: <sheet> is not a valid name." misaak Excel Programming 3 06-20-2016 07:55 AM
Run-time error '-2147467259 (80004005)': Method 'Insert' of object 'BuildingBlock' failed Run-time error '424': Object required zlodeh Excel Programming 1 02-24-2016 01:58 AM
Run time error - Pivot Cache Failed patrick1063 Excel Programming 0 02-08-2016 07:56 PM
Run-time error '-2147467259 (80004005)': Method 'Insert' of object 'BuildingBlock' failed Run Time Error 424 - Object Required Doug Needham Excel Programming 4 01-12-2015 10:54 PM
OUTLOOK : the operation failed. an object cannot be found luotzabl Outlook 0 02-28-2010 02:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft