Linker IT Software
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 Multiple Rows Update (Read 3640 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Automate Multiple Rows Update
27.06.06 at 16:53:37
Automate Multiple Rows Update
Albert from The Netherlands asked the following question.
I would like to run the multiple rows update process but I would not like to show SQL*XL's multiple rows update dialog. Can that be done?
Hitherto you could not. The macro recorder would record a call to mnuUpdateMulti_Click, see:
I have build a new function into SQL*XL to accomplish this. You can call this Sub to run the multiple rows update process.
Public Sub MultipleRowsUpdate(Review As Boolean, Update As Boolean, CommitEachRow As Boolean)
This sub executes the same code as the OK button in the Multiple Rows Update dialog. In other words, you can set the parameters in VBA that you would set in the dialog.
This function will be made available in SQL*XL 4.0.48
Back to top
« Last Edit: 27.06.06 at 16:55:11 by Gerrit-Jan Linker »  

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