![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
vba
wentise
这个作者很懒,什么都没留下…
展开
-
vba
[code="java"]Global Const summitpar_cpty_mapping As String = "summitpar_cpty_mapping"Global Const trade_mapping_str As String = "trade_mapping"Global Const cpty_prefix As String = "APO_"Glob...原创 2012-08-27 05:26:57 · 132 阅读 · 0 评论 -
vba自动公式
[code="java"]Private Sub CommandButton1_Click()Dim Str, formular, sheetName As StringDim splitArrayDim to_cell_with_formula, curValStr = Sheets("setting").Cells(1, 1).Value splitArray =...原创 2012-09-21 01:53:40 · 232 阅读 · 0 评论 -
Excel vba 读取上证指数
[code="java"]Public Sub 抓上海指数全部()'删除上次结果sheetdelectsh Dim ie, dmt, an, selectONE Set ie = CreateObject("InternetExplorer.Application") '创建一个IE对象 With ie ...原创 2013-02-07 03:26:27 · 1189 阅读 · 0 评论