PDA

View Full Version : Email, CSV, VBA



White_Nova
02-11-2008, 04:46 AM
Hi All

I have a proccess where bank account details are emailed on a daily bases to my email address using a specific subject.
They are CSV files that are zipped in a folder.

I would like to know if there is a code a can use to
import these CSV file from my email to an already created Excel workbook (Call it Data.xlsm)

Thanks

White_Nova
02-11-2008, 04:53 AM
My thinking is as follows:

The subject line of the email is constant.
The folder the emails are in is constant.
The Data.xlsm is constant.
The CSV files are already sorted out (you can open them and they look fine).

The problems are that the zip file has a unique name every time.
(Would be nice to use the subject line of the email.

White_Nova
02-12-2008, 02:16 AM
does nobody have an idea?
Ive tried browsing around but have found no solution as yet...
Please help where you can...