Need some work done? Post a Project Today
Attention Scriptlance users, Scriptlance has been acquired by Freelancer.com! Find out more
I need to extract data from a series of Excel sheets.
You must open each book (all the book stored in the folder), and read a data grid (example clumna A, B, C).
Read starting A1 B1 C1, then A2, B2, C2 and so on. Until the column A value is null.
Must look in a folder and all sub folders (multiple levels).
You should file these records in an Access table (table1).
At another table add you must write(from each Excel file) id (from table1), book name, path, date of process, last modification, and if possible, who last modified it.
Every day review the file folder and add new records only if the excel file has been modified.
I´ll give you another access table with column names and path to read.
This should be developed as a module in VBA (Access), and must be open for me to read/modify it.
I use Spanish version of Access, this can create a difference in the handling of dates and things like that .... The code must be in English.
Freelancer.com (formerly GetAFreelancer, Scriptlance and vWorker/Rentacoder) is the world's largest freelancing, outsourcing and crowdsourcing marketplace for small business. Hire freelancers to work in software, writing, data entry and design right through to engineering and the sciences, sales and marketing, and accounting & legal services.
Find freelance jobs and make money online! We have freelance coders, writers, programmers, designers, marketers and more. Getting the best web design, custom programming, professional writing or affordable marketing has never been easier!
© Copyright 2013 Freelancer Technology Pty Limited (ACN 142 189 759)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)