Search results for query: *

I have the following info on a sheet. “Program” is in cell A1. Program Number Name Date Job Hours 1 1100 steve 1/1/04 158654 6 1 1471 frank 1/1/04 189 6 1 1596 tom 1/4/04 186 6 4 1400 elroy 1/4/04 181 4 4 1500 wilma 1/5/04 181 6 I want to move the individuals in program #4 (Elroy and Wilma)...

Check out eBay before you run down to Borders. I picked up a brand new, CD sealed, copy of Excel 2000 Power Programming with VBA by John Walkenback for $18. That includes shipping. Borders is $50.

Here we go again. In my last post I stated that I had reinstalled and had it going. I have the SP6 exe file on floppy. I need to connect to the internet to get it finished, but SP 5 is in. Anyway, it worked for a while. I shut it down for a couple of hours to watch some TV and get something to...

Matt, Thanks for the help. I did everything you suggested and at this moment (knock on wood) it's working. I updated to SP5 from a CD that I had and have d/l SP6. So far, so good. We'll see about tomorrow. Once again, thanks. Bill

I have installed NT 4 (twice now) on a reformatted hard drive. I tested the drive during the reformatting with the “Scandisk/All/Surface” command. It came up clean with no problems. I have installed service pack 5. I tested the system to make sure that everything was working (especially the...

I am having trouble getting a mouse to work on a Gateway, 75 MHZ PC with Win98. There is no USB. I have tried two different mice and have even switched the plugs b/w the keyboard and the mice. When the PC is booting and in the DOS like screen (black and white) I see the message telling me that...

The CD that I have says: Open Linux 2.3; Linux Kernel and Installation; Caldera Systems; 1999.

Hello, I have a copy of Linux 2.3 on CD. I have never used or even seen Linux in use so I have a few questions: Will the MS office suite work with this? Will the Opera or Mozilla browsers work? Should I obtain a newer version of Linux or can I install the 2.3 and then download an upgrade...

Loomah, Thanks for the line: ChDir "C:\My Documents\Census"

BuGlen, Same result with the File Not Found box. Still have "propxfer" the first time and "propxfer.xls" the second. After Canceling both, the code runs as expected. I had to adjust your code just a bit: Sub OpenAndCopyInvoices2() Dim wkbImport As Workbook Set...

'In the Prop1Invoice folder I have the Prop1Invoice workbook that has three invoice sheets that are copied to the Propxfer workbook. But right before they are copied, a "File Not Found" dialog box appears with the Prop1Invoice folder and the "propxfer" filename. When I select...

Rob, On the MS site, I found the following code. I'm trying to adapt to my needs. Thanks for all your help. ListBox with File search Knowledge # 155837 In Microsoft Excel 97 for Windows, you can use the FileSearch object to locate files on a local or network drive. This article provides an...

Rob, If I understand: 1)Create a user form 2)Put all my command buttons (process, print, preview) and the HIDDEN list box on the form 3)Code my process button to run my processing code 4)Code my print and preview code to make the list box visible 5)Code the list box with a click event to run...

Rob, Each month is its own file. All in one folder. Folder name: "Prop1Months". File names: Prop1January2003, Prop1February2003, etc. "You'll need to program the listbox1_change event to fire your preview code, and probably some workbook_open event to initially populate the...

Rob and Vladk, Some info from a previous post of mine: “I am wanting to add some code to each button to open a List Box and display the files in a directory in which to print or preview. Example: I have FileA, FileB and FileC and the user selects the Preview Invoices button. The List Box...

Rob, You hit the nail on the head. The buttons and list box that I had put on the worksheet were from the Forms toolbar. I was using the Forms toolbar so I could easily assign a macro to each button. After reading your post and running the code "?activesheet.oleobjects.count" The...

Rob, I typed your line of code: for each ob in activesheet.oleobjects:?ob.name:next ob into the Immediate window and pressed Enter as Help says to do. Nothing happened except the cursor advanced as it should down the page. The sheet “Menu” was active. I then tried the following from Help...

Hey guys, I added the worksheet name (new code below) with no change in the situation. When the Propxfer workbook closes, the Prop1Compute workbook is active and contains the sheet "Menu" that displays the buttons and the list box. There is definitely a list box on the...

I have six command buttons on a worksheet. Three to print and three to preview. Right now they all work as desired in printing and/or previewing their respective worksheets. I am wanting to add some code to each button to open a List Box and display the files in a directory in which to print or...

How can I ignore the case of the worksheet name in the code below? If the worksheet name was entered as "clntRATE" or "ClNtRaTe" (or any other variation of upper and/or lower case), the code below doesn't recognize the variations. It only recognizes "CLNTrate" For...