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
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
[VBA]Originally Posted by ilyaskazi
Open ActiveWorkbook.Path & "\MYFILE.txt" For Append As #1
Print #1, ActiveSheet.Name & vbTab & ActiveCell.Address(False, False)
Close #1
[/VBA]
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.Originally Posted by ilyaskazi
yaa... thanku,
it is working.