Hi all,
iīm trying to create automatically, based in a list of client codes, new sheets (and the name of each one of them are the client codes) and then inside of them create a report from sql data base.
for the first part i have the code to create new sheets with the name based in a list of codes.
but the second part i canīt figure out how to create the report.
can anybody help me out?
thnks
RS
Hi, welcome to the forum.
I assume you already have an SQL script that reads and the data from you database?
You could record a macro for at least one client and then use the recorded VBA (you will need to edit it) to allow for different SQL statements.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks