Work Project

[s22jcd]

I have got a project that I need to do for work but don’t have a clue were to start. I have detailed what I have got to do below, if anyone could tell me what programming language I would need to do this in it would be great.

I have an html email that comes into my inbox every day, I need to take 12 numbers from this email and insert these numbers into an excel sheet. This not a difficult task at the moment but over the next few weeks we will be monitoring more and more live feeds and this task will start to take longer and longer. So this task really needs automating.

Any help would be much appreciated.

 

[NateO]

Hello, and welcome to the board.

This is an Excel question.

You basically want to scan your inbox, hopefully you're using Outlook and can use something like this:

http://www.dicks-clicks.com/excel/olRetrieving.htm

And you can parse the Body with Instr(), Right(), Left() and Mid().

I hope you have some VB[A] experience because this is not where I would start, experience-wise.

I moved this thread out of the Lounge, which isn't really intended to house serious programming threads.