The Mother Board

Motherboards.org forums. Free tech support, motherboard ID, and more.
It is currently Mon Dec 17, 2018 4:15 am

All times are UTC - 8 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Simple Macro
PostPosted: Wed Oct 12, 2005 9:52 am 
Offline
Brown Belt
Brown Belt

Joined: Wed Feb 11, 2004 3:01 pm
Posts: 266
Location: Anyplace with internet
Let me establish some things that will help prevent back and forth posts of this nature:

"did you try xxxxx?"
"yes"
"do you know how to xxxxx?"
"yes, tried that already"
"try this: xxxxx"
"already did. along with xxxxx"
"ok, then this is what you need: xxxxx"
"can't"
etc...


MACRO WRITTEN IN:
VB through Excel (.xls format, not .csv)

OS:
W2k3 Pro (latest service pack)

COMPUTER:
Public comp @ Work. Downloads & links will not work. Please post code.

EXPERIENCE:
I'm extrememly fluent with VB, just not the Excel specific commands



Now that that's out of the way, are my two very simple questions:
1 - Given an alphabetized list of unknown length, how do I compare each cell to the next and delete duplicates? All of the information is in column A, so I just need to compare row X to row X+1 until row X+1 is empty.

2 - If I have strings that look like Company_Software_UniqueID_Version, how do I copy JUST the UniqueID & Version number over to another cell? The UniqueID can be 5-7 numbers long, and the version isn't always a number. Also, if the company or software has more than one word in it, underscores will be used instead of spaces.
Examples:
Interplay_Carmageddon_1234567_00
Running_With_Scissors_Postal_2_v1337_12345_02c

If these are in cells A1 & A2 respectively, how to I make cells B1 & B2 contain 1234567_00 & 12345_02c respectively?



Please answer as quickly as you can. If you're like me and are constantly crunched for time and can't write out a full macro for me, then just post a function - I'm experienced enough with programming that I can probably figure out how to use it.


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Wed Oct 12, 2005 11:59 am 
Offline
Brown Belt
Brown Belt

Joined: Wed Feb 11, 2004 3:01 pm
Posts: 266
Location: Anyplace with internet
...ok - surely SOMEONE knows how to write a loop in Visual Basic!

Why so quiet guys? I really need to know this.


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Wed Oct 12, 2005 12:02 pm 
Offline
Enlightened Master
Enlightened Master

Joined: Wed Dec 11, 2002 2:29 pm
Posts: 14664
Location: Canada
*tap* *tap* *Whisper*

Moved to Programming, S'okay though, been a while since you've been in, and you woudln't know about the normal sections


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group