Export a particular sheet as txt file to the current directory

[Ravana]

Hi all,


Can I export a particular sheet say "LOG" as txt file to the current directory with the same name as sheet i.,e "LOG"

It should overwrite automatically and no prompts.

Can I assign a short-cut key to this?

Thanks

[Ravana]

Bump, anyone

[jolivanes]

Try this.
Note: It will close the workbook also.

Please Login or Register  to view this content.

[Ravana]

@jolivanes

It is asking me to save the workbook again to xls when I tried your code which is not I am looking at.

All I want is to save a sheet named "LOG" in the workbook as txt file in the current directory with same name as LOG.txt

If there is any existing file with name LOG, it should replace it.

[jolivanes]

This Maybe?

Please Login or Register  to view this content.

[Ravana]

@jolivanes

That seems good. Thanks a lot mate.