HELP!! Anyone know VBA?? Have Excel Question!!!
MoveCloseDeleteAdmin

TV ClubHouse: Archives: HELP!! Anyone know VBA?? Have Excel Question!!!
 SubtopicMsgs  Last Updated
Archive through September 19, 2002 25   09/19 06:22pm
Archive through November 07, 2002 25   11/07 07:06am
Archive through November 07, 2002 25   11/07 10:21am

Zachsmom

Thursday, November 07, 2002 - 10:47 am EditMoveDeleteIP
Hillbilly..that's what I love about programmers..always willing to help out and share code. I just bought a second computer and I am going to load my linuix hardrive onto it..I am going to teach myself linuix..I am also registered to take a Perl programming course next semester.. I have been doing programming for about a year..year and a half..and I am still amazed at the application that can be created..espcially after I create one..I look at the first one I ever created and see so many programming errors that I wouldn't even dream of doing now..I love it..it took me 32 years to find out what I wanted to do with my life..and I seem to have found my niche..I am flabbergasted that my company actually pays me to do what I love doing!!!

Draheid..I know VB..see above to Hillbilly..:) it's just the excel projects that I seem to freeze on!!! I do fine with VBA in MS Access..I am taking a course right now for Visual Basic.NET. I really enjoy it because it's more object oriented than just plain VB. I just took my midterm for the class and recieved a 98%..YEA!!!! Too bad my company won't switch to .NET lol..

Thanks again guys for all your help!!!

Sia

Thursday, November 07, 2002 - 12:23 pm EditMoveDeleteIP
I know there have been tons of advancements since then, Zachsmom, but way back when Lotus 1-2-3 was "state of the art" is when my computer knowledge stopped, LOL!

Draheid, I'm so totally impressed that you can decipher this stuff enough to help Zsmom without even understanding the reasons WHY it's used!

And Zsmom, are you saying your boss doesn't know you've been getting "help" from Draheid to figure this stuff out? He must think you're an absolute rocket scientist! Kudos to you, Zachsmom! That is great!!

Zachsmom

Thursday, November 07, 2002 - 12:51 pm EditMoveDeleteIP
Actually Sia..my boss for some unknown reason does think I am brillant! (think I am going to tell him differently?!)

My last project that was assigned did this..

At a specific time every night I put a database into single user mode, if the database wouldn't go into single user mode, I then found out which matchine (user) was stil connected to the database, I found out what type of process it was in, and if it was a safe process to kill I then killed the users process, then set the database into a single user mode.If the user was hung up in an unsafe proccess in which to kill, I emailed myself and quit the program,if there were no errors I continued. After the database is in single user mode I detach the database, I move yesterdays copied database into a temp file, I then make a copy of the detached database (the .mdf & .ldf )files and paste it on a different server2, I then re-attach the database to server1 and set into multi-user mode.If all process were successful I delete the temp file. Any and all processes are documented in an Event Log and timestamped, Any and all Errors are posted to an Error Log and timestamped, if there are any errors it send an email to myself and a co-worker. This was a fun project that I completed with no assistance. I figured everything out by researching my programming books..or just programming that I have learned since I began programming.

But I'll be darned if you give me an Excel Spreadsheet that need to be coded!!! as I said earlier, I turn white and freeze like a deer caught in headlights!!!

I think it has to do with the ranges in Excel, if I can figure those out..I'll be okay..:)

Draheid

Thursday, November 07, 2002 - 01:15 pm EditMoveDeleteIP
Zachsmom: You'd have been lol at me yesterday. I pulled out my old IRC server which runs an old version of FreeBSD and had to muddle through reconfiguring the network information so I could access it via FTP from my other computer. I had forgotten half the commands and kept flubbing all the syntax! LOL But I got it! I now have about 900 wav files on my main computer. Next up, indexing them all! :O

Zachsmom

Thursday, November 07, 2002 - 01:31 pm EditMoveDeleteIP
WOW!!! Drah!! I hate working on the cpu itself, I set up my computer at home with 3 OS's (Windows 2000,Windows 98 & Liniux (RedHat 7.3)) I did just fine until I got to the Linux part..that was a nightmare!!!! I finally bought a cheap box for the Linuix, puchased a switch so I can have my liniux & windows computers running at the same time. I am VERY interested in learning Linux!! and I am sooooo excited about it..as soon as I get back from Vegas (Company is sending me to Comdex this year WOOHOO!!!) I am going to concentrate on setting the box up and make it a priority to learn it..

Where do you find those .wav files? I have so much fun annoying everyone in chat with them..LOL..:)

Twiggyish

Thursday, November 07, 2002 - 01:46 pm EditMoveDeleteIP
Zach, I'm going to try out these codes now that I see them modified. I like Hillbilly's and Dra's versions better.

Zachsmom

Thursday, November 07, 2002 - 01:59 pm EditMoveDeleteIP
They work great Twiggy!!!

Draheid

Thursday, November 07, 2002 - 02:21 pm EditMoveDeleteIP
Zachsmom: raspberry
I have wanted to attend a Comdex for years and have yet to make it to one. You better be prepared to bring back lots of stories and souvenirs! Take a couple of empty suitcases for all of the goodies!! Seriously, congratulations. Be prepared to walk and walk and walk ... or better yet, if you can get one, take an electric 'Scooter' along. I think I heard last year it was spread out across 3 or 4 major hotels? Sheesh, I'd be near dead by the time I got back. Of course *I* won't be going!

Zachsmom

Thursday, November 07, 2002 - 02:38 pm EditMoveDeleteIP
Draheid..any particular exibit you would like for me to visit? I would be glad to pick up any samples for you and ship them to you!!! I am serious! With all the help you have given me and others on this board you deserve it!! I think the convention is being held at the Las Vegas Convention Center..it's HUGE!!! Bill Gates is speaking Sunday night at the MGM.

This is a link to the layouts Let me know what ones you'd like for me to visit. I will then highlight them with the ones that I am planning to visit.

Twiggyish

Thursday, November 07, 2002 - 02:41 pm EditMoveDeleteIP
If Bill Gates is speaking, bring a pillow. He's boring..LOL I saw him when Microsoft first launched Windows 98. I was at a convention in Ft. Lauderdale and they broadcast his speech live on a large screen.

Zachsmom

Thursday, November 07, 2002 - 02:43 pm EditMoveDeleteIP
Thanks for the warning Twiggy..perhaps I'll go gamble that night instead!! LOL..:)

Sia

Thursday, November 07, 2002 - 07:23 pm EditMoveDeleteIP
I'm still amazed at all of you! A smart bunch of cookies you all are!

Jo_5329

Friday, November 08, 2002 - 03:40 am EditMoveDeleteIP
I didn't dig through this whole thread, but when I was crash coursing myself in basic Excel, I got out on the net and started digging around. I found a great site that was very helpful to me.

Mr. Excel.com

Jo

Draheid

Friday, November 08, 2002 - 07:32 am EditMoveDeleteIP
Sia: as long as you consider me the peanut butter cookie of the bunch, then I won't take offense to being considered a snackfood! :O

Zachsmom

Friday, November 08, 2002 - 07:43 am EditMoveDeleteIP
so you won't be offended if I start calling you "Nutter Butter" Draheid? devil

Draheid

Friday, November 08, 2002 - 11:53 am EditMoveDeleteIP
I suppose not, ZM, just be careful when dipping me in the milk! :O

Sia

Saturday, November 09, 2002 - 11:23 pm EditMoveDeleteIP
Draheid, if you'd like to be a peanut butter cookie, I'll make you a peanut butter cookie!