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...
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...
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...
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...
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...
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...
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...
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...
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
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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.