This group is the home base for the Stock Market Functions add-in developed by Randy Harmelink. This add-in contains a number of user defined functions for EXCEL that can allow data to be extracted and/or retrieved from the web and placed directly into EXCEL cells or ranges.
The files area of this group contains the add-in, documentation on its functions, and a number of templates that have examples of how the various functions can be used. The add-in was developed using EXCEL 2002 under a WinXP operating system, so other platforms and/or versions may have issues.
If you're reporting a problem, remember that I'm not a mind reader -- "It doesn't work right" is not a helpful description of a problem. Please try to include relevant information, such as:
-- The specific function(s) or template(s) you are having problems with.
-- The parameter(s) you are using with the function(s).
-- The version of EXCEL you use.
-- The operating system you're running EXCEL under.
-- The steps you took to try to resolve the problem.
-- The ticker symbols or URLs that are being used.
-- The results you expect to get and what you actually get.
Randy... In response to your questions.. In the VBA environment, the computer is set up to "Break on unhandled errors". Version 2.0j is the version I am using.
I use Excel 2002 on my PC and Win 7 on my laptop. Worksheet? http://sharesend.com/3ie4p I get the same messages as below. And, there is no updating of prices
For info on the macro, see: http://finance.groups.yahoo.com/group/smf_addin/message/7625 However, if exiting and re-entering EXCEL doesn't fix the "Error"