The Leading Edge
Budget: $30 – $250 USD
Hi.
This is a one off query.
I use Excel with Office 2000, the attached file is a copy of a daily download from ESignal, the daily data file layout is constant.
Up until May 1st the data was presented in a comma separated format, every spreadsheet I use looking at this raw data is comma separated.
What I did:- I wrote and saved a simple macro DOTStoCOMMAS converting all dots to commas in the raw data file, it only worked 100% once, running the macro on the next days raw data file gave results which do not relate to the original file.
I installed Office 365 thinking it would resolve the issue to no avail.
I would prefer to keep everything in Excel 2000 if possible.
Editing a macro is beyond my level at the present.
I would ask what causes the macro to produce unrelated data and is it viable to produce a reliable macro using old software.
I am an individual person not affiliated to any company or commercial enterprise.
What would be the cost of a conversion file.
Best regards
Peter Dodd
This is a one off query.
I use Excel with Office 2000, the attached file is a copy of a daily download from ESignal, the daily data file layout is constant.
Up until May 1st the data was presented in a comma separated format, every spreadsheet I use looking at this raw data is comma separated.
What I did:- I wrote and saved a simple macro DOTStoCOMMAS converting all dots to commas in the raw data file, it only worked 100% once, running the macro on the next days raw data file gave results which do not relate to the original file.
I installed Office 365 thinking it would resolve the issue to no avail.
I would prefer to keep everything in Excel 2000 if possible.
Editing a macro is beyond my level at the present.
I would ask what causes the macro to produce unrelated data and is it viable to produce a reliable macro using old software.
I am an individual person not affiliated to any company or commercial enterprise.
What would be the cost of a conversion file.
Best regards
Peter Dodd