| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I export the contents of autoshapes to a text file?
I have one or more autoshapes contained in an excel file and would like to
export the contents (text contained therein) into a text file or some other file format that would allow me to organize the content in a list or table. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I export the contents of autoshapes to a text file?
Try this one:
Open "TESTFILE.txt" For Input As #1 ActiveSheet.Shapes("Text Box 1").Select MyString= Selection.Characters.Text Input #1, MyString "Donncha" wrote: I have one or more autoshapes contained in an excel file and would like to export the contents (text contained therein) into a text file or some other file format that would allow me to organize the content in a list or table. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text File | Excel Discussion (Misc queries) | |||
| Changing a comma separated text file and save it. | Excel Discussion (Misc queries) | |||
| how can i convert text file to excel file ? | New Users to Excel | |||
| Search/Extract Data w/in Text File | Excel Discussion (Misc queries) | |||
| Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
Linear Mode
