for instance![]()
Sub writeToFile() Dim n As Long Dim lFile As Long Dim sPath As String ' change path sPath = "C:\some file.txt" lFile = FreeFile Open sPath For Output As lFile For n = 1 To 30 Print #lFile, ActiveSheet.OLEObjects("Textbox" & n).Object.Text Next n Close lFile End Sub
Bookmarks