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
programmatically call SQL*XL menu options (Read 2460 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
programmatically call SQL*XL menu options
11.06.07 at 07:52:42
 
Programmatically call SQL*XL menu options
 
Question:
May I programmatically (through VBA) invoke the SQL*XL menu options?  If so,  
would you have any code examples that do this?
 
Answer:
Yes you can. Use the following syntax to invoke the SQL*XL menus.
 
  SQLXL.mnuAboutOracle_Click
  SQLXL.mnuAboutSQLXL_Click
  SQLXL.mnuBack_Click
  SQLXL.mnuBackAll_Click
  SQLXL.mnuCalculateAllFunctions_Click
  SQLXL.mnuCommitTrans_Click
  SQLXL.mnuConnect_Click
  SQLXL.mnuFavoritesAdd_Click
  SQLXL.mnuFavoritesOrganise_Click
  SQLXL.mnuForward_Click
  SQLXL.mnuForwardAll_Click
  SQLXL.mnuInsertAllMergeFields_Click
  SQLXL.mnuInsertMulti_Click
  SQLXL.mnuInsertSingle_Click
  SQLXL.mnuMerge_Click
  SQLXL.mnuOracle_Click
  SQLXL.mnuParameters_Click
  SQLXL.mnuRefreshQueries_Click
  SQLXL.mnuRollback_Click
  SQLXL.mnuShowFormattingPreferences_Click
  SQLXL.mnuShowOraCodes_Click
  SQLXL.mnuShowOraSQL_Click
  SQLXL.mnuShowSQLXLSite_Click
  SQLXL.mnuSQLDialog_Show
  SQLXL.mnuUpdateMulti_Click
  SQLXL.mnuUpdateSingle_Click
Back to top
 
 

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