Hi Paul, Ops, I’m sorry I posted the file as a different post; I didn’t know how to do it following the original! I definitely agree with you, a .vbs operated centrally after end user signs off on his data entry. Then if I understand, user will sign off by exporting part of the Tracking sheet to a separate file, which will be saved in a shared drive. This can be .cvs or .xls, it is the same for the user and for me. Then .vbs will take all the submissions and update Access. Am I right??
As you say, this is more a MySql thing, and that’s the plan. But it is probably something that’s going to happen in one or two years… for now, I’ll need to survive with Excel and Access!! Ranges to import: Everything is coming from the Tracking sheet. Output 1 and Output 2 are linked to this Tracking sheet. I created this dummy sheets to make it easier the import, but they are not really needed in the master excel file. Output 1 is not large and won’t hurt if I keep it in the master Excel, hidden. But Output 2, would be great if can be created just when the user exports the data, and then removed. So we have: - Output 1: Import all. Will be a hidden sheet. - Output 2: Ideally won’t exist. The macro will create it with Tracking!C45:AB94 plus Tracking!$H$5, Tracking!$D$6, Tracking!$D$4 and Tracking!$D$5 (Region, Country/Industry, Engagement ID, Client/ Engagement) as identifiers by line. Remember that one of the complex things on this is that each user will have 24 rolling months, on the top. For sure they won’t match between files. The first month in one file might be December 2009, in another file July 2009, and in another file February 2010. All the files will have April 2010, but not in the same column number. So when importing we will need to figure out which month are we importing, to place it in the right field table?? Sounds too complex for me... I am GLAD that you are helping me, and I appreciate it. THANK YOU! Cecilia On Apr 9, 2:12 pm, paulwillekens <paul.johan.willek...@gmail.com> wrote: > 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- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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.
