How can I use the content of a table cell as the file name when saving?
Hello,
VBA is really new to me. I'm using the macro posted on this website to split a merged document with multiple records into single-paged documents (sorry I'm not allowed to post links yet - the post is called "Split document into multiple single-paged documents"). This macro creates sequentially-numbered files based upon the original file name but I actually need the file names to use the content of a table cell in my file (basically a company name).
I assume I only need to modify a few lines on the macro but I am not advanced enough to do this. I'm using Office 2007 but need to generate files in Office 2003 format.
Thanks in advance for your help.