Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 04-18-2018, 09:54 AM
RMerckling RMerckling is offline Copy & Paste Word Doc from Excel VBA Windows 7 64bit Copy & Paste Word Doc from Excel VBA Office 2010 32bit
Novice
Copy & Paste Word Doc from Excel VBA
 
Join Date: Jan 2018
Posts: 29
RMerckling is on a distinguished road
Default

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

Closed Thread

Tags
excel 2010, excel vba, word 2010



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy & Paste Word Doc from Excel VBA 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 Word Doc from Excel VBA Copy/Paste EXCEL cells as pic in WORD A_Lau Drawing and Graphics 3 12-19-2014 06:57 AM
Copy & Paste Word Doc from Excel VBA 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft