Colo...help with html maker?

[Von Pookie]

Hi Colo. I got the file, thanks for that

I put it in my add-ins folder, and I can select it in the add-ins list. However, when I click OK, it gives me an error 91 and object variable or with block variable not set.

I can't figure out what I'm missing. I've got to be totally brain-dead and overlooking something...

Thanks,

 

[Ivan F Moala]

On 2002-05-18 15:13, Von Pookie wrote:
Hi Colo. I got the file, thanks for that

I put it in my add-ins folder, and I can select it in the add-ins list. However, when I click OK, it gives me an error 91 and object variable or with block variable not set.

I can't figure out what I'm missing. I've got to be totally brain-dead and overlooking something...

Thanks,

Hi Von Pookie
Do you know where it is stopping at?
If not then I suggest going into the VBA.

1) Alt + F11
2) Ctrl + F4
3) Select the addin
4) double click [ModMenu] Module
5) Run [CreateMenu]
See what happens
6) If nothing then run [CreateReferences]
See what happens

Let me know

 

[Von Pookie]

Hi, Ivan. I meant to mention you in the original message as well, but got a tad distracted while typing, sorry

I went in and found Create Menu and ran it. That seems to work fine. It pops up a little Macro screen where I choose run again, and then brings up the dialog box for selecting the range, which I can do. It seems to work, as I can get the screen which has the code to copy/paste.

When I ran CreateReferences, the error message popped up. It also pops up as soon as I open Excel.

Thanks for the help,

 

[Ivan F Moala]

On 2002-05-18 22:10, Von Pookie wrote:
Hi, Ivan. I meant to mention you in the original message as well, but got a tad distracted while typing, sorry

I went in and found Create Menu and ran it. That seems to work fine. It pops up a little Macro screen where I choose run again, and then brings up the dialog box for selecting the range, which I can do. It seems to work, as I can get the screen which has the code to copy/paste.

When I ran CreateReferences, the error message popped up. It also pops up as soon as I open Excel.

Thanks for the help,

I'll send the latest amendments.....