Hi Cecilia, After checking out your excell workbook, IMHO the best is to develop a .vbs that does both things: grab the specified data in the different excel files and insert them in the database. Still this problem: if the end user starts this .vbs, he must have access to the database; else i the .vbs is operated centrally then, the initiative is no longer in end user hands...
My proposal: a .vbs operated centrally after end user signs off on his data entry... Let me know and I'll make you a working sample of such .vbs Better solution would be an internet application, storing data directly in a MySql file... I can develop that in ASP on hired space (one.com e.g.), but that would demand more development and higher cost (need of password protection i.e. management etc.) Shall I proceed with the .vbs solution ? Tell me exactly which ranges from which sheets to import... Greetings Paul Willekens PS: it took me time to find your posting, as you did not post it as follow up of the original one ! On 9 apr, 03:26, Cecilia Chiderski <cecic...@hotmail.com> wrote: > Paul, the sample file. THANK YOU! > _________________________________________________________________ > Recibe un SMS de tu Hotmail vayas donde vayas. ¡Date de > alta!http://home.mobile.live.com/MobileAttach.mvc/?mkt=es-es > > Tracking.xls > 208KWeergevenDownloaden -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
