5 Messages
Digest #4184
Messages
Fri Oct 27, 2017 7:32 pm (PDT) . Posted by:
john_hoel
Thank you Randy. You are an endless source of knowledge. I did not know you can enter the name of any sub in the Alt-F8 dialog.
I continued my research and found that Auto_Open calls smfAddToCellMenu, and Auto_Load is also a sub so I should be able to run it with Alt-F8 as well.
I work with 2 workbooks. Workbook2 references many cells in Workbook1. Workbook1 fetches yesterdays closing quotes for many securities from MarketWatch, and fetches today's current quote from Yahoo Finance. I recalculate Workbook1 multiple times each day. Yesterday's quotes are fetched once only. Today's quotes from Yahoo are refetched by using NOW() as a function argument. For reasons not related to this discussion, I typically do the following:
1. Open only workbook1 and recalculate.
2. Close workbook1 but NOT Excel.
3. Open workbook2 and recalculate.
Ordinarily this process does not disable the smf context menu items. But occasionally it does. It appears that Auto_Close gets called as part of step2 and Auto_Open is not called as part of step 3.
Strange.
One other data point. I use version 2.1.2016.09.02. Perhaps I need a newer version?
But now I know how to fix the problem without closing Excel. Thank you Randy.
I continued my research and found that Auto_Open calls smfAddToCellMenu, and Auto_Load is also a sub so I should be able to run it with Alt-F8 as well.
I work with 2 workbooks. Workbook2 references many cells in Workbook1. Workbook1 fetches yesterdays closing quotes for many securities from MarketWatch, and fetches today's current quote from Yahoo Finance. I recalculate Workbook1 multiple times each day. Yesterday'
1. Open only workbook1 and recalculate.
2. Close workbook1 but NOT Excel.
3. Open workbook2 and recalculate.
Ordinarily this process does not disable the smf context menu items. But occasionally it does. It appears that Auto_Close gets called as part of step2 and Auto_Open is not called as part of step 3.
Strange.
One other data point. I use version 2.1.2016.09.
But now I know how to fix the problem without closing Excel. Thank you Randy.
Sat Oct 28, 2017 7:44 am (PDT) . Posted by:
john_hoel
Now that I know what to look for, it was easy to reproduce.
1. Initial state: Excel not open.
2. Open any workbook. SMF is in the context menu.
3. Close the workbook but not Excel.
4. Open any workbook. SMF is *NOT* in the context menu.
5. Run Auto_Open. SMF *is* in the context menu.
1. Initial state: Excel not open.
2. Open any workbook. SMF is in the context menu.
3. Close the workbook but not Excel.
4. Open any workbook. SMF is *NOT* in the context menu.
5. Run Auto_Open. SMF *is* in the context menu.
Sat Oct 28, 2017 12:48 pm (PDT) . Posted by:
"Joe Mo" joe_mo37
I don't use links to open Excel. Generally, I either start Excel using a Logitech keyboard function which opens a new workbook or I open an existing workbook directly from it's file folder. In either case, the context menu is absent. I have a half-dozen or so other addins that load when Excel is first opened, none of which has a subroutine called "Auto_Open". Several months ago I encountered problems with the SMF addin loading so I added a workbook_open event macro (see below) to my Personal.xlsb workbook to ensure the SMF addin loads whenever I start Excel. I don't see why that would cause Auto_Open to be bypassed.
In Thisworkbook for Personal.xlsb workbook:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
Call DeleteFromShortcut 'This deletes my own context menu, unrelated to SMF context menu
End Sub
Private Sub Workbook_Open()
Call AddToShortCut 'This adds my own context menu, unrelated to SMF context menu
Call LoadSMFaddIn
End Sub
This is in a standard module for Personal.xlsb workbook.
Sub LoadSMFaddIn()
Dim myAddIn As AddIn
MsgBox "loading RCH_Stock_Market_Functions.xla at startup"
For Each myAddIn In AddIns
If myAddIn.Name = "RCH_Stock_Market_Functions.xla" Then
myAddIn.Installed = False
myAddIn.Installed = True
Exit Sub
End If
Next
End Sub
In Thisworkbook for Personal.xlsb workbook:
Private Sub Workbook_BeforeClos
ThisWorkbook.
Call DeleteFromShortcut 'This deletes my own context menu, unrelated to SMF context menu
End Sub
Private Sub Workbook_Open(
Call AddToShortCut 'This adds my own context menu, unrelated to SMF context menu
Call LoadSMFaddIn
End Sub
This is in a standard module for Personal.xlsb workbook.
Sub LoadSMFaddIn(
Dim myAddIn As AddIn
MsgBox "loading RCH_Stock_Market_
For Each myAddIn In AddIns
If myAddIn.Name = "RCH_Stock_
myAddIn.Installed = False
myAddIn.Installed = True
Exit Sub
End If
Next
End Sub
Sat Oct 28, 2017 2:38 pm (PDT) . Posted by:
"Jose Jacob" pepecan47
Do you know how can I extract the 10 Year Treasury history from this source? In a table, so I can do a vlookup?
10 Year Treasury Rate by Month
|
|
|
| | |
|
|
|
| |
10 Year Treasury Rate by Month
By multpl Check out this fantastic 10 Year Treasury Rate table. | |
|
|
Regards, Jose L. Jacob
10 Year Treasury Rate by Month
|
|
|
| | |
|
|
|
| |
10 Year Treasury Rate by Month
By multpl Check out this fantastic 10 Year Treasury Rate table. | |
|
|
Regards, Jose L. Jacob
Sat Oct 28, 2017 3:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetHTMLTable("http://www.multpl.com/10-year-treasury-rate/table/by-month
","id=""datatable""")
On Sat, Oct 28, 2017 at 2:38 PM, Jose Jacob pepecan47@
...
wrote:
>
> Do you know how can I extract the 10 Year Treasury history from this
> source? In a table, so I can do a vlookup?
>
> 10 Year Treasury Rate by Month
> <http://www.multpl.com/10-year-treasury-rate/table/by-month>
>
=RCHGetHTMLTable("http://www.multpl.com/10-year-treasury-rate/table/by-month
","id=""datatable""")
On Sat, Oct 28, 2017 at 2:38 PM, Jose Jacob pepecan47@
...
wrote:
>
> Do you know how can I extract the 10 Year Treasury history from this
> source? In a table, so I can do a vlookup?
>
> 10 Year Treasury Rate by Month
> <http://www.multpl.com/10-year-treasury-rate/table/by-month>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar