Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Kaulana
  • Content: Threads
  • Order by date
  1. Kaulana

    Word Registration Information

    The document properties (Word 97) summary section always lists an old company name. I've changed the normal.dot, renamed it, deleted the old one, and renamed the new one normal.dot, but every time a blank document opens, the old name is still there. My MS Office has that old company name listed...
  2. Kaulana

    Mouse Wheel Scrolling in VBA Code Window Problem

    I've read the post on this not uncommon problem, but cannot find a driver for my Logitech Compaq mouse. The Control Panel control for the mouse doesn't even list a wheel to control or change settings for. The strange thing is that the scroll wheel *does* work in the Project and Properties...
  3. Kaulana

    Prudence of installing Office 97 patches

    I use Office 97, mostly Excel, programming Visual Basic for Applications. I've never updated the suite with the patches available. Was wondering what the success rate for that would be approximately, how many horror stories there are, or if it is as easy and simple as updating IE's browser. I am...
  4. Kaulana

    Label caption runtime changes

    Want to change a label when command button clicked to say "Processing" while it processes. Caption doesn't change till the processing is over and a message box stops the run. However, the caption does change as soon as the button is pressed when I step through it. Has to be something...
  5. Kaulana

    pagesetup.zoom, display grid lines

    Thanks to windows xp, I am having to redo some printpreview code that now causes errors, apparently by closing the page it previews. I don't know because I'm 4500 miles away from the problem and I don't have xp. My workaround was going to be to simply have the page acquire the zoom value and...
  6. Kaulana

    VBA and XP: thoughts or comments sought

    I program VBA in Excel for a company 5,000 miles away. They previously used Win98 and Excel 97, which I still have. However, the company recently bought a new computer with Windows XP. I didn't. They're experiencing some problems with the VBA6.0 code. Me.Show seems to fire UserForm_Activate now...
  7. Kaulana

    .Hide, .Show aspects of Windows XP

    In Windows 98 and using Excel 97, I had a bit of code to preview a sheet that the program had built. I found that if I hid the form first, using Me.Hide, then the preview acted as if it had been called from the File menu. If I left the form up, then the user had to key the Esc key to come back...
  8. Kaulana

    xlDialogPrintPreview and XP

    I work remotely with Windows ME and Office 97. The people I work for upgraded to Windows XP, keeping Office 97. The problem is the print preview code I wrote for pre-xp fails to return to the same place it was. Here's the code: Me.Hide Application.Dialogs(xlDialogPrintPreview).Show...
  9. Kaulana

    Disallowing "x" to terminate form

    Using VBA in Excel, would like to deactivate the "x" in the upper right of forms so that user "must" use the "Close" button to close the form. Any way to do that? Kaulana (aka Bob) http://www.bobfarley.com
  10. Kaulana

    How to Delete a Saved Workbook

    There should be a way to delete workbooks from folders using VBA, but darned if I can find it. Am I blind, or is there no way to do it in VBA in Excel? Is there a way to do it within MS Office? Kaulana (aka Bob) http://www.bobfarley.com
  11. Kaulana

    error in VBA332.DLL. Excel will now close.

    At odd intervals I will get an error in my Excel VBA that tells me: "Excel has caused an error in VBA332.DLL. Excel will now close. If you continue to experience problems, try restarting your computer." Sometimes restarting will help. Other times not. Sometimes, I go through all the...
  12. Kaulana

    How to access different printers through form

    I need to give users choice of printers to print from, but don't know how to get the information. Can get the active printer easy enough with thisprinter = application.activeprinter, but need to know how to access all the printers available to the computer without first knowing what they are...
  13. Kaulana

    Getting a List of Printers

    I would like to be able to let the user choose which printer to print to, but need to know how to get the list of printer defaults into the program. I know that Application.ActivePrinter will give me the active printer name, but how to get the other printers to put into a dropdown list? This is...

Part and Inventory Search

Back
Top