Hi Kevin,

The file extension needn't affect your macro's ability to read the *.txt and *.log files' contents. In any event, changing the
extension doesn't turn the files into Excel files and could cause other problems. Plus, you'll still need to understand those files'
structure and code accordingly.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

wrote in message ...
Hello group,

I have a macro to pull the values in row A and B of a workbook, to
another workbook. I have some values in the files that have *.txt and
*.log extension.

Is there any macro to change the extension of the file (*.txt and
*.log) to *.xls? Please let know.

Thanks,
Kevin