HELP!! Anyone know VBA?? Have Excel Question!!!
TV ClubHouse: Archives: HELP!! Anyone know VBA?? Have Excel Question!!!
Zachsmom | Thursday, November 07, 2002 - 10:47 am     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     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     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     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!  |
Zachsmom | Thursday, November 07, 2002 - 01:31 pm     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     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     They work great Twiggy!!! |
Draheid | Thursday, November 07, 2002 - 02:21 pm     Zachsmom: 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     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     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     Thanks for the warning Twiggy..perhaps I'll go gamble that night instead!! LOL.. |
Sia | Thursday, November 07, 2002 - 07:23 pm     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     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     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!  |
Zachsmom | Friday, November 08, 2002 - 07:43 am     so you won't be offended if I start calling you "Nutter Butter" Draheid?  |
Draheid | Friday, November 08, 2002 - 11:53 am     I suppose not, ZM, just be careful when dipping me in the milk! |
Sia | Saturday, November 09, 2002 - 11:23 pm     Draheid, if you'd like to be a peanut butter cookie, I'll make you a peanut butter cookie!  |
|