Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel queries

1. Excel undo stack clears off whenever a macro/function is executed
through the code. Can this stack be preserved? If not then can we write to
the Excel undo stack?

2. Is it possible to hook the Excel function dialog to display
function arguments help or function help description.

3. What is the best way to handle Excel busy exceptions that occurs
whenever a cell is in an Edit mode and at the same time the Excel objects
are accessed.

4. Would like to know whether there are any specific compatibility
issues that need to be considered while running the add-in on a multiple
Office versions

5. Is there any property for storing metadata in worksheet that can
also store objects as the CustomProperties can store strings only.

6. Is there any way to identify the idle time in Excel such that
processing can be done then.

7. Assigning cells formula property to an embedded formula throws
HRESULT exception. For example, if a cells formula property is set to
=SUM(MyUdf(),1) then COM exception is thrown (assume MyUdf() returns 1).

8. Installing the Excel COM add-in with "For everyone" option does not
write the OPEN key to the HKCU hive which is required to load add-in on
Excel startup. Is there any key in Excel 2003 like the "UserSettings" key
present in Excel 2007?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel queries Suresh.D Excel Discussion (Misc queries) 1 October 2nd 09 04:08 PM
Excel queries Ben Excel Programming 3 August 2nd 06 07:42 PM
Excel Queries Anselmo Links and Linking in Excel 4 July 14th 06 11:45 PM
Web queries and Excel SmilingPolitely[_3_] Excel Programming 0 April 14th 05 08:53 AM
Excel Web Queries Joe Preloznik Excel Programming 1 February 20th 04 06:36 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"