Thank you for looking at my question,
Currently I am working for an organisation (global!!!) that will not allow anybody access to the SQL data tables that are the basis of their ERP system - but I am supposed to be extracting data from the ERP system for custom reports, won't even consider something like Crystal Reports.
So I have to export a range of standard reports from the ERP system to .csv files - these are, in essence, a reproduction of what would be the printed document with each single line of the printed report written into a csv file and a comma being placed at the end, ending up with all data in column A of the .csv - see attached example
Data extraction is then a case of string manipulations.
I am currently working on something that responds to user-defined ranges (monthly output by year and month - Start Year and Month to end Year and Month)
Is it possible to define a range of string variables in response to the range set by the user - if the user specifies a range of 6 months then 6 string variables are defined eg strMonth01 to strMonth06?