Replies

hi Roberta,

my suggestion is to work directly from excel, and use some DAO (yes, DAO, the predecessor of ADO) to import/append data immediately from within the workbook the users will be working with.

greetings,

hi Helen,

you won’t need the office repair. this error is most certainly coming from one of the add-ins you have installed, which is probably trying to set its saved property to true before closing, or one of the add-ins is not properly using the customizationcontext property.
unfortunately this is a difficult error to debug. the add-in causing it may just run fine, when it is the only loaded add-in or loaded with several others, while it may be causing errors with other combinations of loaded add-ins.

in the end, the only way might be to move them out of the startup folder and control their loading behavior and order with an add-in of your own.

greetings,

there’s an interesting article here:
http://www.mssmartsolutions.com/features/2…a200302dk_f.asp%5B/url%5D

greetings,

thanks Lee,

i just switched from the vba forum when i answered this question … still in vba mode.
even then it could be written better:
sub stpp()
selection.range.select
end sub

there are cases when left/right up/down movements are not symmetrical in word (i.e. don’t bring you back to the same place)

greetings, pieter.

hi Satiria,

i don’t know if this will work, but it should bring your cursor back into view automatically
run this macro (create a shortcut for it)

sub MoveScreentoCursorPosition
selection.moveleft:selection.moveright
end sub

greetings,

hi,

if i understand correctly, you are enabling a macro that calls your personal.xls. but for this to work you need to copy that personal.xls file from your old to your new pc also!

greetings,

hi John,

only a minor modification needed:

Private Sub CommandButton1_Click()
For i = 1 To 3
TextBox18 = Val(TextBox18) + Val(controls(“TextBox” & cstr(i)))
Next
End Sub

greetings,

hi Doug,

word 2002 creates a normal.dot if there doens’t exist one yet each time it is opened. if you save normal.dot the first time you exit word, it probably won’t happen again.
or set its saved property to true.
if you have other templates or addins that modify the interface programmatically , you should use the customizationcontext property to force word to save changes to that template and then set the save property of that template to true.

greetings,

hi,

a quick test shows me document_close is also triggered when you close a document from the menu (if it has been saved or not doesn’t affect this behavior). this would mean document_close is triggered in all cases. couldn’t you just put your code under this event only then, and leave the fileclose for what it is?

greetings, pieter.

hi Linda,

in the organization chart toolbar that appears, uncheck autolayout in the drop down menu layout.

greetings,

if you mean word 97 with windows 2000:

WD97: Spelling, Grammar Not Available in Word Running on Window 2000 or Windows XP

greetings,

hi Craig,

set the linkedcell property to for example to Sheet1!$A$1 and then use that cell in your vlookup function:

=vlookup(Sheet1!$A$1,salesno,2,false)

greetings,

here’s the knowledge base article that answers your question:
http://support.microsoft.com/default.aspx?…B;en-us;q187985%5B/url%5D

greetings,

hi Richard,

here’s an example from the word mvp site:
http://www.mvps.org/word/FAQs/InterDev/ControlXLFromWord.htm%5B/url%5D
if you have more question don’t hesitate to post back.

greetings, pieter.

hi Dan, Bryan,

in excel there are two types of inputboxes:
the inputbox function from the vba class (“vba.inputbox” or plainly “inputbox” as the vba library will allways take precedence over excel’s library)
the inputbox method from the application class. (application.inputbox)

the function behaves as Bryan describes, but the method returns false when cancel is clicked and not an empty string. to make sure you have the function, you could use vba.inputbox(…
unfortunately, if you look up online help (at least in excel 97) you get help for the inputbox function which doesn’t refer to the method (which does refer to the function in its see also link in the helpscreen.)
to read the help of both the function (which is actually also a method in oo-speak) & the method, bring up the object explorer with F2 in the VBE, search for inputbox and click on it in the resulting list. the press F1, repeat this procedure for the second result (first one is the vba class, the other is application)

greetings, pieter.