From: ipi-paul on 30 Apr 2010 11:07 You can use the Input Textstream functions in Exel VBA to read the data in JPG files and pick out the Picture Taken Date. I have created an excel workbook with this <a href="http://www.ipi-international.co.uk/IPI%20Backup.zip">function</a>. You can copy the code from there if you wish. It seems that there are some differences in the time when looking at the Picture Taken Date using Explorer on a Vista system. E X C E L $ B ! ! ( B N E W S ; 5 7 8 2 0 4 W r o t e : > hi, > > i am using a lot of photos taken at a construction cite,and i have to write > the date of JPG file which is taken > > to excel sheet. > > how can i get the date VBA property of which is taken at cite. > > I mean the date of taking photo > > thanks -- ipi-paul ------------------------------------------------------------------------ ipi-paul's Profile: http://www.thecodecage.com/forumz/member.php?u=1819 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=159835 http://www.thecodecage.com/forumz
|
Pages: 1 Prev: DO Until Loop Next: Shape.OnAction stops working after workbook closed and re-opened |