mdaneri
09-26-2017, 11:56 PM
Hello all,
1st, let me thank you for the great job you are doing with this forum: I use it a lot to grab examples as I am quite newbie in VBA programming.
I'd have a request for a sample code to be implemented in a wider spreadsheet.
I copy and paste a set of data from a webpage to an Excel file.
The data imported as numbers have some decimal separator which from time to time is not the same of the system where I import the data.
I would like to create a macro which:
1 - Detects the decimal separator (comma or full stop) actually used by Excel: the system must work in different versions which can have different separators
2 - Replaces the commas in the whole spreadsheet with the correct decimal separator
3 - Replaces the full stops in the whole spreadsheet with the correct decimal separator
(I don't mind if the action is redundant or not efficient, as I do not operate on a too wide set of data)
4 - Formats all the columns from D to G, from the second row to the end of the spreadsheet, as numbers
So that I can later on process the data as numbers.
I can easily do it manually, but just because I know which is the right decimal separator for my Excel; I need this operation to be automated in order to work on an Excel file of any other person.
Thank you all again,
Marco
1st, let me thank you for the great job you are doing with this forum: I use it a lot to grab examples as I am quite newbie in VBA programming.
I'd have a request for a sample code to be implemented in a wider spreadsheet.
I copy and paste a set of data from a webpage to an Excel file.
The data imported as numbers have some decimal separator which from time to time is not the same of the system where I import the data.
I would like to create a macro which:
1 - Detects the decimal separator (comma or full stop) actually used by Excel: the system must work in different versions which can have different separators
2 - Replaces the commas in the whole spreadsheet with the correct decimal separator
3 - Replaces the full stops in the whole spreadsheet with the correct decimal separator
(I don't mind if the action is redundant or not efficient, as I do not operate on a too wide set of data)
4 - Formats all the columns from D to G, from the second row to the end of the spreadsheet, as numbers
So that I can later on process the data as numbers.
I can easily do it manually, but just because I know which is the right decimal separator for my Excel; I need this operation to be automated in order to work on an Excel file of any other person.
Thank you all again,
Marco