Search results for query: *

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

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...

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...

...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 windows of the VBA editor, but not in the Code window. Not that much of a hassle, but perturbing at times...

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...

Thanks for try, Justin, but Refresh not an available option for labels in VBA. Kaulana (aka New Daddy Bob) http://www.bobfarley.com

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 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...

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...

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...

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

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...

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...

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

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...

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

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...