D_Marcel
11-22-2017, 02:30 PM
Hello Gurus, greetings.
I'm writing a code to automatically update a weekly report, applying some formats, some formulae, and opening some source files. One of these files comes from the web in .csv file extension.
When I open the file directly, by double clicking on it, Excel correctly reads the data and displays a table. When I try to open the same file, however, using:
Set SOURCE_WB = Workbooks.Open(LV_SIEVE_FILE, Format:=6, Delimiter:=";")
Excel displays the "raw data", being necessary to apply the text to columns feature.
I've tried some combinations of properties to this method, according to:
https://msdn.microsoft.com/pt-br/vba/excel-vba/articles/workbooks-open-method-excel
I've also tried to use "SaveAs" and then save the file to ".xlsx" format, didn't work.
Can someone please help me?
**Sample .csv file attached**
Thanks a lot, sincerely.
Kind regards,
Douglas Marcel de Moraes
I'm writing a code to automatically update a weekly report, applying some formats, some formulae, and opening some source files. One of these files comes from the web in .csv file extension.
When I open the file directly, by double clicking on it, Excel correctly reads the data and displays a table. When I try to open the same file, however, using:
Set SOURCE_WB = Workbooks.Open(LV_SIEVE_FILE, Format:=6, Delimiter:=";")
Excel displays the "raw data", being necessary to apply the text to columns feature.
I've tried some combinations of properties to this method, according to:
https://msdn.microsoft.com/pt-br/vba/excel-vba/articles/workbooks-open-method-excel
I've also tried to use "SaveAs" and then save the file to ".xlsx" format, didn't work.
Can someone please help me?
**Sample .csv file attached**
Thanks a lot, sincerely.
Kind regards,
Douglas Marcel de Moraes