To fix the issue you can do You can simply read the dates from the spreadsheet into variables and format them. Then concatenate those variables with the URL. Assuming your beginning date is in cell "A1" and your end date is in cell "A2".
Dim fromDate As String
Dim toDate As String
fromDate = Format(Range("a1").Value, "dd/mm/yyyy")
toDate = Format(Range("a2").Value, "dd/mm/yyyy")
Workbooks.Open Filename:= _
"http://Serverlink/ReportServer?%2fFinance%2fReportname&rs:Command=Render&FromDate=" & fromDate & "&ToDate=" & toDate & "&rs:Format=Excel"
Use Perl to select multiple query output data from SQL database and place into single Excel sheet
I wish did fix the issue. If that is your code, then it will be throwing errors complaining about $col1 and $col2 needing an "explicit package name". This means that you haven't declared the variables correctly. You declare variables using the keyword my. But my declares the variables within a block of code. So when you write this:
To fix the issue you can do In SQL Assistant Options there is an Flag where you can instruct SQL Assistant to remove all CR/LF from Exports. I think it's easier than RegExp in SQL. ;) (SQL Assistant) -> Tools -> Options -> Export -> "Replace Carriage Returns in column data with blanks"