Replies

a control array is only possible in vb

for vba you could name the controls e.g textbox1 thru textbox10 and then this code inside the userform (untested)

for loopc=1 to 10
thisworkbook.sheets(1).range(“a1”).offset(loopc+1,0).value=controls(“textbox” & cstr(loopc))
next

a control array is only possible in vb

for vba you could name the controls e.g textbox1 thru textbox10 and then this code inside the userform (untested)

for loopc=1 to 10
thisworkbook.sheets(1).range(“a1”).offset(loopc+1,0).value=controls(“textbox” & cstr(loopc))
next

hi Henrik,

“I have a customized toolbar that is attached to the activedocument’s attachedtemplate and resets itself when documents based on the template are active.”

could you explain this further?

as i am interpreting it now, it seems to me you don’t need to create a beforesave event at all, but your code that resets “itself”?? needs a customizationcontext to prevent other templates from getting dirty. this will prevent word from asking to save the template.

‘pseudocode:
prevcc=customizationcontext
customizationcontext=activedocument.attachedtemplate
‘your reset code
activedocument.attachedtemplate.saved=true
customizationcontext=prevcc

as to why the event is not firing, try Hans’ suggestions. also when you’re debugging, public variables tend to reset easily. if you have an end statement or an unhandled error somewhere (might be another template or addin), public vars will be reset and you’ll lose the event as well.

hi Henrik,

“I have a customized toolbar that is attached to the activedocument’s attachedtemplate and resets itself when documents based on the template are active.”

could you explain this further?

as i am interpreting it now, it seems to me you don’t need to create a beforesave event at all, but your code that resets “itself”?? needs a customizationcontext to prevent other templates from getting dirty. this will prevent word from asking to save the template.

‘pseudocode:
prevcc=customizationcontext
customizationcontext=activedocument.attachedtemplate
‘your reset code
activedocument.attachedtemplate.saved=true
customizationcontext=prevcc

as to why the event is not firing, try Hans’ suggestions. also when you’re debugging, public variables tend to reset easily. if you have an end statement or an unhandled error somewhere (might be another template or addin), public vars will be reset and you’ll lose the event as well.

we’ll need to see the full code this time i think if we want to solve the problem.

we’ll need to see the full code this time i think if we want to solve the problem.

hi Kyle,

dim Newdoc as document
set newdoc=documents.add
‘…
‘…
newdoc.activate
application.activate

hi Kyle,

dim Newdoc as document
set newdoc=documents.add
‘…
‘…
newdoc.activate
application.activate

hi Ronny.

i’ve got the impression he’s pretty savvy. if he choses his wordfile password long and complicated enough the students will not gain access in a million years. several million years in fact, even with all their computers combined into one password cracking machine.

hi Ronny.

i’ve got the impression he’s pretty savvy. if he choses his wordfile password long and complicated enough the students will not gain access in a million years. several million years in fact, even with all their computers combined into one password cracking machine.

hi Howard,

i noticed you also posted this to a few newsgroups but did not yet get an adequate response. i’m afraid there’s not much to suggest.
what you could try is late binding (app as object iso app as euapplication), and leaving out version (.1) in the getobject (and createobject) statements.
also something to check is wether you the getobject is successful when eudora is already running the 1st time the code is executed, or if it produces an error and the createobject is called erronously.

this is not the only mail program with ole problems it seems. for instance, lotus notes does not allow early binding, allthough that functionality is provided.

hi Howard,

i noticed you also posted this to a few newsgroups but did not yet get an adequate response. i’m afraid there’s not much to suggest.
what you could try is late binding (app as object iso app as euapplication), and leaving out version (.1) in the getobject (and createobject) statements.
also something to check is wether you the getobject is successful when eudora is already running the 1st time the code is executed, or if it produces an error and the createobject is called erronously.

this is not the only mail program with ole problems it seems. for instance, lotus notes does not allow early binding, allthough that functionality is provided.

for reference, i retrieved the star post from my personal archives

==============================================
Subject: Docking Floating Windows in VBE Editor [#19683]
Poster: LegareColeman
Posted on: 01/03/02 02:00

I just undocked my Project Explorer and Properties windows, and I had the same problem. However, I was finally able to get them redocked where they are supposed to be. I did it by right clicking on the window and then clicking on the Dockable command on the pop up menu. This caused the window to dock to the top of the VBE window, across the complete width of the window. I then grabbed the top right of the title bar, just to the left of the close window X and dragged to to lower left of the VBE window until the drab box changed to a smaller box and released. The window then docked on the left side where I wanted it. I did the same thing with both windows and got them back where they belong.

Legare Coleman
==============================================

for reference, i retrieved the star post from my personal archives

==============================================
Subject: Docking Floating Windows in VBE Editor [#19683]
Poster: LegareColeman
Posted on: 01/03/02 02:00

I just undocked my Project Explorer and Properties windows, and I had the same problem. However, I was finally able to get them redocked where they are supposed to be. I did it by right clicking on the window and then clicking on the Dockable command on the pop up menu. This caused the window to dock to the top of the VBE window, across the complete width of the window. I then grabbed the top right of the title bar, just to the left of the close window X and dragged to to lower left of the VBE window until the drab box changed to a smaller box and released. The window then docked on the left side where I wanted it. I did the same thing with both windows and got them back where they belong.

Legare Coleman
==============================================

hi Ed,

have you checked your parallel port settings in the bios. i remember years ago (must be at least 8 already) that i had issues with an hp printer/windows 98 in combination with port/bios settings. does the bios setting on your computer correspond with /is capable of the same setting as your printer? i faintly remember that the ecp/epp print method was a (buggy) standard jointly developed by ms and hp at the time, and – next to this problem – the printing quality deteriorated markedly when i switched from windows 3.1 to windows 95 and then to 98.