Workbooks.Add (mytemplate) problem.

[Ian Coetzer]

My Problem (I only have this problem with one Excel template and can not
get around it!!)

I am opening an Excel workbook via automation from VB.NET

xlObject.Workbooks.Add ("LOCATION OF MYFILE")

But one of my templates does not open, the code never passes the line
above
I have found the cause but do not know what to do to try and resolve it.

* The template contains 75 Checkboxes =EMBED("Forms.CheckBox.1","") each
with a unique id because I have to programmatically set their checked
states
* Now if I remove all 75 checkboxes the Excel template opens immediately
using the Workbooks.Add method.

In this case I have to use checkboxes and cannot replace them with text,
is
there anything I can do to try and get it to open the template?

Any advice would be appreciated

 

[Ian Coetzer]

Thanks for the greate response guys and gals .....

I had to replace all the checkboxes (well technically not all of them as I'm
using an image with a lot of check ... pictures in a bunch for each group)
with pictures! and add them to the template via automation at run time which
works amazingly fast! even though it is late bound and on ASP.NET!

my problem is therefore solved thanks to nobody ......

Cheers