How do I export the contents of autoshapes to a text file?

G

Guest

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.
 
G

Guest

Try this one:

Open "TESTFILE.txt" For Input As #1
ActiveSheet.Shapes("Text Box 1").Select
MyString= Selection.Characters.Text

Input #1, MyString
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove text edit from Autoshapes 4
AutoShape Desire(s) 2
How do I remove an Autoshape? 3
how do i get my text to follow the autoshape? 2
Save formatted AutoShape 3
How do you change the default text alignment for Excel autoshapes 1
Auto Shapes in Excel is greyed out, what do I do? 4
AutoShape Positioning? 2

Top