I'm writing a MS Access program with a SQL Server database and trying to download a PDF from my SSRS using a VBA script. After checking some forums, I've found the following function: Webclient.DownloadFile(URL,Path).
To test the function for my purposes, I wrote this code:
Dim reportUrl As String
Dim reportPfad As String
ReportUrl = "http://localhost/reportserver?/rechnung&rs:Format=PDF"
reportPfad = "C:\TEMP\"
WebClient.DownloadFile(reportUrl, reportPfad)
If I try to execute the code, I get this message (freely translated to English):
Error while Compiling:
Expected: =
Can you help me out?
