Hi all,
I have read data from a web page by using Get Table, the data is stored in a collection. I noticed that the columns contain a "enter"keystroke, which I want to remove from the columns
I tried writing VBA code, similar to Remove dots from headers in the object: Collection Manipulation. As I am not familiar with VBA, I do not find this an easy task. And I have not succeeded yet, see images for code snippets.
Another strategy I tried: using an expresssion: Replace([Werktabel.(Kolom)]; Chr(13); ""). The error I am getting here is that the object is not correctly pointed to, in dutch: "De objectverwijzing is niet op een exemplaar van een object ingesteld". Werktabel is a collection with a dynamic number of columns, so I need to loop through all columns.
Any tips/tricks?
I have read data from a web page by using Get Table, the data is stored in a collection. I noticed that the columns contain a "enter"keystroke, which I want to remove from the columns
I tried writing VBA code, similar to Remove dots from headers in the object: Collection Manipulation. As I am not familiar with VBA, I do not find this an easy task. And I have not succeeded yet, see images for code snippets.
Another strategy I tried: using an expresssion: Replace([Werktabel.(Kolom)]; Chr(13); ""). The error I am getting here is that the object is not correctly pointed to, in dutch: "De objectverwijzing is niet op een exemplaar van een object ingesteld". Werktabel is a collection with a dynamic number of columns, so I need to loop through all columns.
Any tips/tricks?