Advertisement

brettdj Login Name
Qualified Expert Account Type
3,115,906 Expert Points
09/09/02 Registration Date
24,060 Points this month
Member Profile:
Melbourne based again as at the start of March 2009.

Linkedin Profile @ http://www.linkedin.com/profile?viewProfile=&key=2996376.
My free "The Duplicate Master" addin for Excel (2000 or higher) has found a new home at Bob Phillip's site, http://xldynamic.com/source/xld.DupMaster.html
My Excel KB articles at VBAeXpress can be found at http://vbaexpress.com/kb/default.php

My favourite questions typically involve automating Outlook, Word or Internet Explorer from Excel, plus of course the occasional regular expression

Excel VBA: http://www.experts-exchange.com/Q_24159183.html
1.      searches the Outlook inbox for the latest message from a specific user,
2.      using a Regexp to parse the first internet hyperlink in the email,
3.      opens this hyperlink vie Internet Explorer,
4.      and then creating Excel hyperlinks to all the downloadable excel files at the link.

Outlook VBA: http://www.experts-exchange.com/Q_24162610.html
1.      prompts the user to select a folder,
2.      loop through each mailtem,
3.      use a Regexp to remove all the blank lines,
4.      write each edited mail item to a text file,
5.      modify the final text file with Word and then print out all the emails in a concise file.

Excel VBA: http://www.experts-exchange.com/Q_23787032.html
1.      Setup a master list of number codes in the first sheet,
2.      Loop through each of these numbers and identify with a Regexp if these numbers are used in any other sheet formulas,
3.      If these numbers are found, navigate recursively through all cell dependents,
4.      Check if any of these dependents end up being used on a specific sheet,
5.      Finally identify any numbers from sheet1 that are not eventually references on that specific sheet.
Expertise:
Personal Website:
http://xldynamic.com/source/xld.DupMaster.html
Computer Expertise:
Advanced
Experience:
20-29 years
Skills / Accomplishments:
Freaky thumb claw impression that is a big hit with the kids
No other skills to speak of
Employment Background:
Company:
BHP Billiton
Division:
Corporate
Experience:
15-19 years
Company Size:
500+
Hobbies / Interests
Does anyone have spare time these days?
brettdj is following 1 Member:
  • 1
 
 
1,777 Questions Participated In
10,669 Comments Posted
 
 
1 Article Written
1 Article Comment