Hi
I had a document and need to convert to UTF-8 .csv
In a document am having some unnecessay columns & rows that to be deleted first, then create a csv.
First 3 rows & First column need to be deleted from a file. [(opened docuemnt type ".docx",".rtf" ,".doc")]
First 3 rows are XXXXX name, XXXX number & version ID
First column is sequence number.
Above rows & column are need to be deleted and then create a csv UTF 8 version with the below format type.
SourcePath = InputBox("PLEASE ENTER PATH", "SOURCE PATH") & ""
Then delete the unnecessary first 3 rows and first colum.
Then create a csv with remaining data as in below format.
File Name: Same as the opened document with the extention .csv
Save as type: All files "(*.*)"
Encoding UTF-8
Saved in the same path (from where we select a file)
Can we automate this task by macro...
Please help me in this regards & your help is highly appreciated and means a lot to me....
Thanks in advance...
For reference PFA.
