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.

Attached Files

Test.zip (50.1 KB, 7 views)