Skip to content
Home » Lập trình VBA Liên kết dữ liệu từ website vào Excel với QueryTable | dbd xbrl in excel v.2.0

Lập trình VBA Liên kết dữ liệu từ website vào Excel với QueryTable | dbd xbrl in excel v.2.0

Lập trình VBA Liên kết dữ liệu từ website vào Excel với QueryTable


นอกจากการดูบทความนี้แล้ว คุณยังสามารถดูข้อมูลที่เป็นประโยชน์อื่นๆ อีกมากมายที่เราให้ไว้ที่นี่: ดูเพิ่มเติม

Hướng dẫn lập trình VBA để lấy dữ liệu từ website vào Excel với đối tượng QueryTable. Dữ liệu lấy dạng table có ID.
() Bài giảng lập trình VBA cơ bản: http://bluesofts.net/daotaothuchanh/laptrinhvbacobantaomacro.html
() Mã nguồn:
‘CODE
‘Author: Nguyen Duy Tuan http://bluesofts.net
Sub LayTableTuWeb()
Dim qry As QueryTable
Dim sh As Worksheet
Dim CnnStr As String

Set sh = ThisWorkbook.Sheets(\”Webtable\”)
‘Xoa querytable truoc do
XoaQT sh

CnnStr = \”URL;https://s.cafef.vn/LichsugiaodichVCB6.chn\”
Set qry = sh.QueryTables.Add(CnnStr, sh.Range(\”A5\”))
‘Query
qry.WebSelectionType = xlSpecifiedTables
qry.WebFormatting = xlWebFormattingNone
qry.WebTables = \”\”\”tblStats\”\”,\”\”tblData\”\”\” ‘Tat ca cac table
qry.Refresh ‘Load du lieu
End Sub
Sub XoaQT(sh As Worksheet)
Dim qry As QueryTable
On Error Resume Next ‘Bo qua loi
For Each qry In sh.QueryTables
qry.ResultRange.ClearContents ‘Xoa data trong vung table
qry.Delete ‘Xoa QueryTable
Next
End Sub
‘END COPY

Lập trình VBA Liên kết dữ liệu từ website vào Excel với QueryTable

วิธีการนำส่งงบการเงินDBD e-filing in excell


วิธีการนำส่งงบการเงินDBD e-filing  in excell

Hooking Up XBRL in Excel – Latest Version


How to connect XBRL data to your Excel models using XBRL to XL

Hooking Up XBRL in Excel  - Latest Version

การเตรียมข้อมูลงบการเงินในรูปแบบ DBD XBRL in Excel v 2


การเตรียมข้อมูลงบการเงินในรูปแบบ DBD XBRL in Excel v 2

Getting started with the XBRL Filed Data Add-in for Excel


A brief demonstration of how to find, install and get started with this Addin, which can be used to get near realtime data from public company financial reports filed with the US SEC.

Getting started with the XBRL Filed Data Add-in for Excel

นอกจากการดูหัวข้อนี้แล้ว คุณยังสามารถเข้าถึงบทวิจารณ์ดีๆ อื่นๆ อีกมากมายได้ที่นี่: ดูบทความเพิ่มเติมในหมวดหมู่MAKE A WEBSITE

Leave a Reply

Your email address will not be published. Required fields are marked *