![]() vbs file in the same C:\SSRS_Exports folder as the Excel file.īUT, when I try executing the. Set objRange = objworkbook.worksheets(1).columns(1) Set objWorkbook = ("C:\SSRS_Exports\Myfile.xlsx") Set objExcel = CreateObject("Excel.Application") I found a little tiny vb script to open the file and save it. However, if I simply open the exported Excel file manually and save it back, the file will open up perfectly in Google Sheets. It's just complex and won't export to Excel in a manner that Google Sheets can upload or convert. Yes, I've rewritten the SSRS Report three times to try to get it to export properly. There's a problem with the exported file, though, in that it cannot be opened as a Google Sheet. I have an SSRS report that exports to a specific folder on a scheduled basis.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |