Solved: write cell address in text file through vba

[ilyaskazi]

a3 of the activeSheet is my cell address.

open notepad file = "Locate.txt"

after the last line of text in above said file, write...

activesheet.name (SHEET1), then 1 TAB required and then cell address (a3).

For eg:

SHEET1 A3

[Bob Phillips]

a3 of the activeSheet is my cell address.

open notepad file = "Locate.txt"

after the last line of text in above said file, write...

activesheet.name (SHEET1), then 1 TAB required and then cell address (a3).

For eg:

SHEET1 A3


Open ActiveWorkbook.Path & "\MYFILE.txt" For Append As #1
Print #1, ActiveSheet.Name & vbTab & ActiveCell.Address(False, False)
Close #1

[ilyaskazi]

is it possible if "MYFILE.txt" is not found in activework.path, then create new and write
else if found, then open and write.

[Bob Phillips]

is it possible if "MYFILE.txt" is not found in activework.path, then create new and write
else if found, then open and write.
That is the default action, i.e. it already works that way.

[ilyaskazi]

yaa... thanku,

it is working.