帮忙写一个vba脚本可以批量导出链接中的pdf文档

可以的，您需要先打开链接，然后通过 VBA 脚本模拟点击下载按钮，最后保存下载的 PDF 文档。以下是一个简单的示例代码：

Sub DownloadPDF()
Dim IE As Object
Dim DownloadLink As Object
Dim DownloadURL As String
Dim SavePath As String

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

'打开链接
IE.Navigate "https://example.com"

'等待页面加载完成
Do While IE.Busy Or IE.ReadyState <> 4
DoEvents
Loop

'获取下载链接
Set DownloadLink = IE.Document.getElementById("download-link")
DownloadURL = DownloadLink.href

'设置保存路径
SavePath = "C:\Downloads\example.pdf"

'模拟点击下载按钮并保存文件
With CreateObject("MSXML2.XMLHTTP")
.Open "GET", DownloadURL, False
.send
With CreateObject("ADODB.Stream")
.Type = 1
.Open
.Write .responseBody
.SaveToFile SavePath, 2
.Close
End With
End With

'关闭浏览器
IE.Quit
End Sub