ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   save in new destination (https://www.excelbanter.com/excel-discussion-misc-queries/452401-save-new-destination.html)

[email protected]

save in new destination
 
Hello, hope you can help. I have this macro which works for me, all I need is for the file to end up in this folder here with date & timestamp
C:\Copy Records

how do I add this to this macro?

Sub CopyToWord()
Dim objWord, objDoc As Object
ActiveWindow.View = xlNormalView
Range("A1:u24").Select
Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture
Set objWord = CreateObject("Word.Application")
Set objDoc = objWord.Documents.Add
objWord.Visible = True
objWord.Selection.Paste
objWord.Selection.TypeParagraph
End Sub

any help is much appreciated
regards
Ditchy


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com