我在下载数据时 ,每次都是Destination:= Range("A1"),我希望能每次下载时Range("A1")中的A1能改一下,并且是
上一次下载时的列的末尾,也就是我如何获得上一次下载的列数.谢谢指教
Sub Macro1()
' Macro1 Macro
' 宏由 微软用户 录制,时间: 2009-10-22
Dim dat As Date
dat = #10/20/2009#
Do While dat > #4/1/2008#
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.fx678.com/indexs/ecalendar.asp?date=" & dat, Destination:= _
Range("A1"))
.Name = "ecalendar.asp?date=2008-4-3"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = """GridView1"""
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
dat = DateAdd("d", -1, dat)
Loop
End Sub
上一次下载时的列的末尾,也就是我如何获得上一次下载的列数.谢谢指教
Sub Macro1()
' Macro1 Macro
' 宏由 微软用户 录制,时间: 2009-10-22
Dim dat As Date
dat = #10/20/2009#
Do While dat > #4/1/2008#
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.fx678.com/indexs/ecalendar.asp?date=" & dat, Destination:= _
Range("A1"))
.Name = "ecalendar.asp?date=2008-4-3"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = """GridView1"""
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
dat = DateAdd("d", -1, dat)
Loop
End Sub
解决方案 »
- vb 操作 oracle中的CLOB字段。。。
- 送分100分:如何将COPYMEMORY用到VB2005中。
- 两表交叉连接,急急急.
- MSHierarchicalFlexGridLib.MSHFlexGrid 与 AxMSHierarchicalFlexGridLib.AxMSHFlexGrid 有什么主要区别
- vb中输出换行怎么弄
- 高手请进入一下(VB基础)
- 做程序员好些还是公务员好些?
- 基于组件的三层应用程序怎么打包?200分相赠!!!
- 如何让子窗体刚好适合主窗体的大小,并且可以随着主窗体的变化而变化?
- 大家好,请部我在WIN2K SERVER 版中装VS。NET 7可以吗?
- 小弟请教WinAPI
- 第一次带团队应该怎么做?
我这里没VB
你这个"A1"需要换成一个变量
变量的数值前半部分是变化的,后半部分是1,
从1-26是A,B,C,.....Z
从27-52是AA,AB,AC....Az
从53-78是BA,BB,BC....Bz
....
拼凑好用&连接起来
Sub Macro1()
' Macro1 Macro
' 宏由 微软用户 录制,时间: 2009-10-22
Dim dat As Date
Dim lngC As Long
dat = #10/20/2009#
Do While dat > #4/1/2008#
lngC = lngC + 1
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.fx678.com/indexs/ecalendar.asp?date=" & dat, Destination:= _
Range("A" & Str(lngC)))
.Name = "ecalendar.asp?date=2008-4-3"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = """GridView1"""
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
dat = DateAdd("d", -1, dat)
Loop
End Sub
Sub Macro1()
' Macro1 Macro
' 宏由 微软用户 录制,时间: 2009-10-22
Dim dat As Date
Dim lngC As Long
dat = #10/20/2009#
Do While dat > #4/1/2008#
lngC = lngC + 1
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.fx678.com/indexs/ecalendar.asp?date=" & dat, Destination:= _
Range(Cells(1, lngC), Cells(1, lngC)))
.Name = "ecalendar.asp?date=2008-4-3"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = """GridView1"""
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
dat = DateAdd("d", -1, dat)
Loop
End Sub
改为
.Name = "ecalendar.asp?date=" &dat