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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. Kaulana

    Mouse Wheel Scrolling in VBA Code Window Problem

    Indeed, Wayne, the first time I tried the link it didn't work, but after reading Ben's post, I tried it again, it worked, I downloaded the stuff, now I can scroll in the code window. Thanks. Bob aka kaulana Kaulana (aka New Daddy Bob) http://www.bobfarley.com
  2. Kaulana

    Word Registration Information

    Did a search and came up with just about all the office documents and files I've ever made, along with these in the WINDOWS folder: SYSTEM.DAT USER.DAT SYSTEM.NAV USER.NAV system.rsc user.rsc prebak.reg I would guess the reg file is a good one to change. I opened the others in WordPad, which...
  3. 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...
  4. 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...
  5. 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...
  6. Kaulana

    Label caption runtime changes

    Thanks for try, Justin, but Refresh not an available option for labels in VBA. Kaulana (aka New Daddy Bob) http://www.bobfarley.com
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. Kaulana

    Fatal Exception Problems With VBA332.dll

    I used to have this problem, too, probably caused by a variety of issues as I was learning to code. But one thing I was doing was leaving object variables in place without making them Nothing. So when I'd be debugging and rechecking, I'd have the same object variable being called again. Don't...
  12. 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...
  13. Kaulana

    Disallowing "x" to terminate form

    Never mind. I found the answer, or at least one answer. It's the UserForm_QueryClose procedure. It has a Cancel As Integer bit that, if you set Cancel = True or -1(?) then it causes the x button not to work. I put a msgbox in it, too, to let the user know to use the Close button. Kaulana (aka...
  14. 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
  15. Kaulana

    VBA code to save current Excel Worksheet by another name

    Piece of cake. VBA for Excel will let you build a name for your workbook and save it as such. Here's code I use in an application. (This is basically the same thing as ratman wrote above, just different.) I'm not sure how you get your Access name into the mix, but if you're writing Access, I'm...
  16. Kaulana

    VBA code to save current Excel Worksheet by another name

    I'm seeing a "template" file opened as a default but then "saved as" for one reason or another. The "save as" would have to be something slightly different each time if it were to be a unique file and not simply overwrite one that was previously opened, edited, and...
  17. Kaulana

    How to Delete a Saved Workbook

    Thanks, ratman, you were right on. I remember the Kill command now. I wonder why requests of the VBA help files on how to delete a workbook wouldn't have brought that right up? Thanks for the quick reply. Kaulana (aka Bob) http://www.bobfarley.com
  18. Kaulana

    VBA code to save current Excel Worksheet by another name

    Sounds like at different times this empty worksheet is going to be opened, so it will need a different name each time it's saved. For that you'll need to devise a control variable somewhere, or maybe you can simply add the day and minute to the filename so it will most likely be different (1...
  19. 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
  20. Kaulana

    error in VBA332.DLL. Excel will now close.

    Apparently that was the problem(s). Mostly a corrupt spreadsheet, I think, because when I coped it, the problem went with it. But when I copied the modules and forms (after triple-checking the code) onto a new spreadsheet, the errors and closings disappeared. Thanks for the direction. Bob...

Part and Inventory Search

Back
Top