![]() |
|
#4
|
|||
|
|||
|
Code:
Sub CopyandRename()
Dim str1 As String
Dim str2 As String
str1 = "Q:\IC\New Structure\IC Toolkit\Templates\01 Plan Doc Template\16 Source\IC Plan Doc Template v1.0.docx"
str2 = Application.ActiveWorkbook.Path & "\" & Range("A1").Value & ".docx"
Call FileCopy(str1, str2)
'Opens New Plan Doc Template
Set appWd = CreateObject("Word.Application")
appWd.Visible = True
appWd.Documents.Open Filename:=Application.ActiveWorkbook.Path & "\" & Worksheets("Form").Range("A1").Value & ".docx"
End Sub
|
| Tags |
| excel 2010, excel vba, word 2010 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Copy/paste from Excel to Word problems!
|
mross127 | Word | 10 | 08-16-2017 04:41 PM |
| Copy Underline text from Word and Paste into excel | rfaris | Excel Programming | 7 | 10-05-2015 05:56 AM |
Copy/Paste EXCEL cells as pic in WORD
|
A_Lau | Drawing and Graphics | 3 | 12-19-2014 06:57 AM |
Word 2007 Copy/Paste Excel issue
|
raven26c | Word | 1 | 11-18-2011 02:49 AM |
| copy/paste charts from excel to word | bielak01 | Excel | 0 | 04-16-2009 02:27 AM |