Problem with recorded macro to assign file names

V

Villager Al

I tired to record a macro to take save the contents of a Word document table
cell and past it into the Save As dialog box as the document name for a
series of documents, incrementing the name of each by "1". Works fine except
that it keeps the name of the file used to create the macro in memory and
pastes this same name in all future document series. In other words, future
Copy instructions don't work. If you look at the macro in VB, you can see
where it has hard-saved the first file name.
 
G

Graham Mayor

The macro recorder is useful but has limitations. As you have not posted
your code, nor explained exactly what it is supposed to do, it is impossible
to advise how to put it right.

What Word version is this? What are the files that are named from the table
i.e. how does the macro know which files to name with which entry from the
table?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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

Top