Hans,
I hope this is the right place for 'attaboys'.
I had a project today using Excel automated via Access. I needed 4 pivot tables on the same tab in an Excel spreadsheet using data from Access. I knocked the project out in an hour. Two years ago it took a couple of days to code, test, ask for help, fix, retest and deploy.
When i finished the project today, I realized how much more productive I have become, and your influence. Based on many of the things you have shared with me (and others) I have learned a great deal. Select Case (instead of If/Then), for/next loops and especially Code to create pivot tables via VBA are only a few of the things in my arsenal thanks to you. No more recording and converting macros. What previously took me 100's of lines of VB code I accomplished in less than 80 lines today.
I don't mean to disregard what I have picked up from others here, but you have been there so many times when it really counted. THANK YOU HANS ! ! !
Respectfully,
Ken
Productive day with VBA . . .
-
- Administrator
- Posts: 79370
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Productive day with VBA . . .
Thank you for your kind words!
I have learned a lot from others, many of whom were/are active in Woody's Lounge and Eileen's Lounge. Without them I wouldn't have been able to post as many replies. And I myself have also benefited from the research for those replies. So I thank you and the other Loungers too for posting interesting questions!
I have learned a lot from others, many of whom were/are active in Woody's Lounge and Eileen's Lounge. Without them I wouldn't have been able to post as many replies. And I myself have also benefited from the research for those replies. So I thank you and the other Loungers too for posting interesting questions!
Best wishes,
Hans
Hans