Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Automate macro for 18 spreadsheets (Read 2356 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Automate macro for 18 spreadsheets
18.05.08 at 10:42:24
 
Automate macro for 18 spreadsheets
 
Quote:
I was able to use a macro to connect to an oracle database and pull data. Now I just
have to figure out how to automate that for 18 spreadsheets!

 
You can copy the code to each workbook, use a common workbook or compile your code into addin itself and make that available to your users.
 
If you need help with this please let me know.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1