K
Kurt
I'm using Word 2003.
I have a macro that copies a string of text from a cell in a Word
table:
Selection.Tables(1).Cell(1, 2).Select
Selection.Copy
I use it later to paste the contents into a cell in another table (...
Selection.Paste)
But, I'd also like to use what's copied as part of the document's new
file name. So, I think I need to save it to a temporary variable
(e.g., strCopied) so I can use it in a SaveAs command like so:
Sub SaveAs()
ActiveDocument.SaveAs FileName:="File ABC - " & " strCopied" & ".doc"
End Sub
Any suggestions about how to do this? Thanks.
I have a macro that copies a string of text from a cell in a Word
table:
Selection.Tables(1).Cell(1, 2).Select
Selection.Copy
I use it later to paste the contents into a cell in another table (...
Selection.Paste)
But, I'd also like to use what's copied as part of the document's new
file name. So, I think I need to save it to a temporary variable
(e.g., strCopied) so I can use it in a SaveAs command like so:
Sub SaveAs()
ActiveDocument.SaveAs FileName:="File ABC - " & " strCopied" & ".doc"
End Sub
Any suggestions about how to do this? Thanks.