andrewsw's Profile User Rating: *****

Reputation: 4267 Guru
Group:
Mentors
Active Posts:
15,830 (17.72 per day)
Joined:
12-December 12
Profile Views:
122,504
Last Active:
User is online 30 minutes ago
Currently:
Viewing Board Index

Previous Fields

Country:
GB
OS Preference:
Windows
Favorite Browser:
Who Cares
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
3325
Expert In:
VB.Net/VB6
Icon   andrewsw Giggity, Giggity, Goo!

Blog entries

andrewsw's Blog > Multi-line replace in Sublime Text

Posted 18 May 2015

I recently needed to find and replace blocks of code across multiple files. For example, to replace the footer of every HTML page. (Normally I would use PHP includes so that there is only a single footer, in a single file, but I wasn't allowed to do this for this site.)

It took a bit of digging to achieve this in Sublime Text. (Maybe it is...

Read Full Entry →

andrewsw's Blog > Excel with Andy: Dynamic Drop-Down

Posted 04 April 2015

Using Defined Names (formerly called Range Names) and Data Validation we can create a drop-down list where the list of choices changes according to the value chosen in an adjacent cell. In the screenshot the list of items in the drop-down changes according to whether Fruit or Veg is chosen in the adjacent cell in column A.

Image reduced in size...

Read Full Entry →

andrewsw's Blog > Excel with Andy: More Functions

Posted 26 March 2015

Most people are familar with Excel's basic statistical functions: SUM, AVERAGE, MAX, MIN, COUNT and possibly COUNTA. I will demonstrate the use of some more functions:

INDIRECT, ADDRESS, ROW, MATCH, OFFSET, COUNTA

Image reduced in size...

Read Full Entry →

andrewsw's Blog > RSS Feed in WPF

Posted 18 February 2015

I found this cool page to display RSS feed items in WPF:

Build an RSS reader in 5 minutes

It works great. I thought I would see how it behaves with dream.in.code's feed:

http://feeds.feedbur...ured?format=xml

Image reduced in size

Unfortunately it, for me, produces a Script Error dialog several times. My settings in IE are already set to not...

Read Full Entry →

andrewsw's Blog > Dipping Into F#

Posted 04 February 2015

If you don't have access to a full version of Visual Studio it is now easier to dip your toe into the F# waters, and functional programming, by downloading the free Visual Studio Community 2013 edition...

Read Full Entry →

My Information

Member Title:
I'm not here to twist your niblets
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:
Interests:
Fixing you
Programming Languages:
VB.NET, C#, Java, SQL, PHP, JavaScript, jQuery, HTML, CSS, Python, VBA, VB6, Regex

Contact Information

E-mail:
Private

Comments

  • (2 Pages)
  • +
  • 1
  • 2
  1. Photo

    mireille4U Icon

    30 Apr 2015 - 05:28
    Greeting from mireille i saw your profile today and i became interested in you and i will like to know more about you and if you can mail an email to my mail address (mireille4u@live.com) i will give you my picture.here is my mail address i hope we can move from here.above. Mireille
  2. Photo

    mbole87 Icon

    01 Apr 2015 - 00:58
    Andrewsw helps me second time, awesome.
  3. Photo

    farad Icon

    15 Nov 2014 - 16:34
    One of the best...
  4. Photo

    abdalraheem Icon

    31 Dec 2013 - 04:59
    Thanks
  5. Photo

    Michael26 Icon

    14 Nov 2013 - 04:21
    Boom, 2000 rep points :)
  6. Photo

    laytonsdad Icon

    21 Aug 2013 - 14:03
    Getting close to 1500 rep, you are a robot.
  7. Photo

    Flukeshot Icon

    14 Jul 2013 - 16:09
    1337 reputation points, truely elite!
  8. Photo

    Michael26 Icon

    09 Jun 2013 - 14:11
    Wow andrew, you're on fire this month
    82 reputation points, nice :)
  9. Photo

    Michael26 Icon

    27 May 2013 - 16:14
    Great for you andrew, keep up the good work :)
  10. Photo

    jon.kiparsky Icon

    15 May 2013 - 13:13
    Jinx, buy me a coke!
  11. Photo

    laytonsdad Icon

    29 Mar 2013 - 14:15
    You are awesome.
  12. Photo

    kai_itz me Icon

    19 Mar 2013 - 23:10
    superb keep going....
  13. Photo

    _HAWK_ Icon

    04 Mar 2013 - 23:18
    Diggin on your Avatar man!
  14. Photo

    raghav.naganathan Icon

    26 Feb 2013 - 03:05
    Congrats on the 500 Mr.Enlightened :)
  15. Photo

    lar3ry Icon

    11 Feb 2013 - 05:50
    Very helpful answer on converting a string to an HtmlDocument! That one gets immediate use for me.
  • (2 Pages)
  • +
  • 1
  • 2