ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Editing Text File Without Opening (https://www.excelbanter.com/excel-programming/426064-editing-text-file-without-opening.html)

Michael Arch

Editing Text File Without Opening
 
I have a subdirectory where I have files with a .dat extension, I need to be
able to change the first 3 lines of each file using a lookup table I have in
Excel. How can I do this without having to open each file.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.



ryguy7272

Editing Text File Without Opening
 
Humm, .dat hunh. This may work:
http://www.rondebruin.nl/ado.htm

Or:
http://www.rondebruin.nl/copy7.htm


Good luck,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Michael Arch" wrote:

I have a subdirectory where I have files with a .dat extension, I need to be
able to change the first 3 lines of each file using a lookup table I have in
Excel. How can I do this without having to open each file.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com