Recent content by treloj

Roku, thank You for help, I did everything You wrote here and now it works under Excell 2007 as charm. I`m sorry for my late answer here, but I have accident and broke my small finger :( so, now I have plaster cast on my finger and hand....and now became very difficult to work with keyboard...

Hi, I create Module as You said, with code You write but when I run manual it show Run-time error 1004, Method 'ThisWorkobook' of object '_Global' failed... I am not sure what to do ? I have now two options, to use enum (to list *.xls file inside d:\test\) to form a list of wb which will be...

Thank You Roku, I will try this weekend Your code. Today I check once again whole logical operations which I have in my problem and now when I look at Your comments inside code, where You explain what and why, it look's very, very similar, but with one exception, I am beginner in VBA and You...

Hi, I need help for resolving this kind of problem, because I just start with VBA. I found and modify solution to export query from MS Access (using VBA) to separate workbooks in Excel so data can be filled in. Structure of table is simple idTest (int) Test1 Test2 In each exported workbook I...

Well, this forum is very interesting. It brings together experienced and less experienced user of MS Access. I'm glad I joined your forum. My specialty is databases and business systems analysis. MS Access I use most often to test the model and prepare for production. Unfortunately, I have not...