Recent content by Jody72

Thanks Skip, didn't consider that.

The 16-bit on the soundcard refers to its sound processing capabilites, not what type of PCI slot it uses. Unless I'm wrong, all current PCI slots are all the same.

PH, Thanks for the SUBTOTAL suggestion, I wasn't aware of it. Only problem is that there is no COUNTIF function.

Skip, Yeah, Ive got that much, that's how I get the results I'm getting now. But it also counts the hidden rows after I filter. I need a count post-filter.

I've got an Excel file that lists programs by numerical file name, what machine they are for and wheter they are proven or unproven. At the bottom I have it set to count the # proven, # unproven, and then the total. I know how to filter out duplicates, but it just hides those rows and does not...

Thanks Dreamboat, I'll give that a shot.

I've got an Excel spreadsheet that I have linked in a Powerpoint show. In order to get the show to update the changes I have to open it up in Powerpoint, let it update itself, then resave. Is there a way to get the show to update itself when someone views it? Jody

Thank you to both of you. That helped me alot.

First off, thanks to everyone that has helped this newbie programmer get this far. I can't seem to figure out to get my program to do a "Save As." The program runs fine, even pops up the ShowSave dialog box, but the file never actually saves. Bascially, the user opens a file, it...

I'd like to add a command before everything where the user can browse for a file to be edited. Also it needs to be able to resave the edited file with the same name, but different extension. As it stands now, the file has to be named tom.acl and I need to have the ability to run it on all acl...

How would I adjust that to where it would run on any file with an extension of .acl and resave that file with the same name, but with the .cl extension?

Thanks for you help thus far. I have access to Visual Basic. It's just at work my boss is wanting me to broaden my horizons so to speak. I want to learn, guess I just need some guidance.

Basically it should look like this: PARTNO 2628A2101-101 OP 300 MAZAK 11/18/03 REV N/C PPWORD/FOFF , 317 PPWORD/OIL , 318 PPWORD/EAIR , 319 PPWORD/HTL , 320 PPWORD/RETRTZ,1310 SEQNO/1,INCR,3 DISPLY/ON

I've got a file, let's call it test.acl and it contains text such as this: 1 PARTNO 2628A2101-101 OP 300 MAZAK 11/18/03 REV N/C 1 PPWORD/FOFF , 317 1 PPWORD/OIL , 318 1 PPWORD/EAIR , 319 1 PPWORD/HTL , 320 1 PPWORD/RETRTZ,1310 16 SEQNO/1,INCR,3...

Forgot to mention, the beginning file will always have the extension of .acl and should always be saved with .cl. So test.acl would become test.cl, test1.acl would become test1.cl, and so on.