Save Selection with VBA?

S

Summer

Hi, can someone tell me if there is a Save Selection VBA (whatever is highlighted) and Save As give doc name way to do this? One can print selection but can one save selection with VBA? Many thanks...
 
T

Tony Jollans

Something like this perhaps (untried) ..

Selectin.copy
with documents.add
.Range.Paste
.Save
.Close false
End With
 

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

Difficulty with compatibility mode and Track Changes 2
Document won't print 0
Macro to save word pages separately as PDF and name them according to text in third line 0
Need Help with a VBA subroutine 0
Select Text to End of Footnote 9
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Word VBA - Want to test if Full Name is NOT Present in document 0
M.S. Word 365 1

Top