Create New Word Document From Template And Save As

Jan 21, 2014

I have been working on the following VBA code, which should copy specific charts from excel into specific places in a word-template.

I Am quite new with VBA, so I googled the code, changed a few things, and it works exactly as it should - except from one thing. When the Word-document is loaded from the template, I would like the document to be "saved as..."
Instead of just opening the template. I have tried

Code:
.ActiveDocument.SaveAs Filename:=fname & ".doc"

The code is as follows:

Option Explicit
Sub EksporterTilWord()

Dim appWrd As Object
Dim objDoc As Object
Dim FilePath As String
Dim FileName As String

[Code] ...........

View 1 Replies


ADVERTISEMENT

Create New Document From Word Template

Apr 28, 2014

I have a template document, created in MS Word. I want to generate, from Excel, a new document as would happen when you open the template from windows explorer or whatever ie. Template1.doc as opposed to Template.xlt.

The best I've managed to achieve is the opening of the template.

View 6 Replies View Related

Userform To Fill In Blanks On Template Document And Save To PDF?

Apr 4, 2014

I have a word document that is a rental agreement. Im trying to make an easy to use user form where a person can input the information and it populates in the correct areas and saves as a pdf. How I could put the word document into excel and have a userform populate designated areas.

View 1 Replies View Related

Macro To Generate Word Document From Excel With Built In Header And Footer Template

Jan 23, 2014

All I want is to generate a word document with built in word header and footer (header and footer style name is "alphabet") based on the values which i mention in excel(path,word file name and header content.

View 1 Replies View Related

Save Word Document As PDF?

Sep 28, 2013

Amend this code? I want to save the word document, then save it as a pdf file, then delete the word document;

Code:
Sub E_W()
Dim strDate As String
Dim DirName As String

[Code]....

View 3 Replies View Related

Excel 2010 :: VBA Save AS (word Document) Not Working

Nov 8, 2012

I have a long bit of code that at one point saves a Word document and then saves it again with a new name and the old (legacy) .doc extension.

This all works find when the user is running Office 2007. However, it errors out for using Office 2010. The reference libraries are all correct (as far as I know).

Code:

Dim myDoc As Word.Document
Dim saveAsName as String

saveAsName = "some text here" + ".doc"

myDoc.Save

myDoc.SaveAs fileName:=(saveAsName), FileFormat:=wdFormatDocument

View 9 Replies View Related

Save Word Document With Current Date From Within Module

May 5, 2006

I am using a module to create and save a Word document from an Excel module. I'm using the following line to save the document which works fine but (and this is a big BUT)(to quote a TV programme from long ago) obviously everytime I save the document it will overwrite itself. Is there a way of adding the date it is saved on to the file name so it creates a new document each time.

objWordDoc.SaveAs Filename: = "WAGReport"

I have tried changing it like this but get an error message

Dim dtMyDate As Date
dtMyDate = Format(Date, "DDMMYY")
dtMyDate = Sheets("Client Master").Range("d2")
objWordDoc.SaveAs Filename: = "WAGReport" & dtMyDate

View 3 Replies View Related

Create Word Document With Bookmarks In Excel?

Aug 27, 2010

I'm trying to create Word documents (letters.doc) from Excel fields.

I already created bookmarks in Word and have the same Titles in A Row in Excel 2003 and I have tried the following threads:

Add bookmarks to Word from Excel Inserting data values from Excel into a Word doc using bookmarks

But I cannot manage it properly. I know that I need the code that goes on the lines of

Set WdApp = CreateObject("Word.Application")

rather than Set WdApp = New.Object

I cannot get Word to open a document! =(

It's basic letter creation, First_Name, 2_Name, Address_1, Address_2.. These have been bookmarked in Word and have exact same Titles in Columns A-D

View 9 Replies View Related

Opening Word & Count Word Instances In A Word Document

May 26, 2006

I have an excel program that is supposed to count word instances in a word document. I can't seem to find the right declaration for a word document.
For example to declare a workbook in excel its

Dim wb As Work Book

I've tried

Dim doc As Word.Document
'or
Dim doc As Word.Application

as shown in some of the forum posts, but an error user-type not defined keeps displaying.

View 2 Replies View Related

Export Cell Contents To Word Fields In A Protected Word Document

Jul 6, 2009

Is it possible to export Excel cell contents to Word fields in a protected Word document? For example...

What code would be needed to tell Excel to open up, copy and export the contents of A2 in the active sheet of a workbook to "Field 2" in a Word document named "Report 01" and then put the contents of B2 to "Field 2" etc?

Do both applications have to be opened up at the same time or is Excel able to open up Word on its own? Will the macro be able to....

1. Automatically open up the correct Word document?

2. Look ONLY in a certain folder for the "Report 01" Word document?

or

Bring up a "selection" box that allows you to select the document you wish Excel to export it's data to?

3. Close and save the Word Document without any user intervention?

View 2 Replies View Related

Documentation -Template (document The Complete Project)

Oct 29, 2008

Hello everyone,

I am at the end of finishing my first project in Excel/VBA. My manager wants me to document the complete project. I really don't know how to do that.

So Just wanted to know if there is any predefined Template.

View 9 Replies View Related

Word Document Of Comments

Feb 22, 2008

I have an excel worksheet which has a lot of comments attached to individual cells. Is there a way to convert these comments into a microsft word document along with the contents of the cells to identify where they originated? Also Is it possible to convert just a selection of cells into word document rather than the whole worksheet.

View 9 Replies View Related

Open Word Document From VBA

Jan 19, 2009

I'm trying to open a word document from excel using VBA. Here is my code.

View 5 Replies View Related

Opening Word Document From VBA

Aug 25, 2009

I am trying to open a word document from within excel using

View 2 Replies View Related

Covert A Word Document

Jan 25, 2009

I need to covert a word document to excel.

View 9 Replies View Related

Print The Word Document

Nov 2, 2009

I have a worksheet that is pretty handy right now. I have a print button that automatically sends the doc to print with the specs I want, etc, etc. It has drop down lists, data validations, etc. What I want, and this may be impossible, is when the print button is clicked excel looks at a certain cell and based on the data in that cell, it pulls over a word document and prints that along with it.

In short, the items in the drop down list in the cell I have chosen have a different disclosure that goes with each, and I would like if possbile those to be printed from word...based on which item is picked....along with the spreadsheet when the print button is clicked.

View 9 Replies View Related

Creating A Word Document With VBA

May 18, 2006

I am working on a project where I am creating analysis using a subroutine in excel/vba and I would like to have the subroutine generate a report that is a word document. I have never used excel/vba to create and modify a word document and don't know how to approach it. I imagine that I will have a template.doc that I can access and save as another file. Does anyone have an example of creating and modify a word document in this manner.

View 2 Replies View Related

Embed Add-in In A Word Document

Jun 1, 2007

I've just written up an SOP for a reconciliation process. Part of it requires the reader to use some Excel UDFs that I've created. Rather than having someone look for the UDF file on the network, I tried to embed it as an Excel Worksheet Icon within my procedure document. However, when I double-click the icon to launch the add-in, I get the following error message:

"Microsoft Word can't start the application required to open this object. An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now?" This does not happen when I embed a regular Excel workbook, or even a template.

View 5 Replies View Related

Copied The Graphs To A Word Document

Jan 23, 2010

I made some graphs in Excel and then copied them to a Word document. Everything seemed fine, but when I printed the document some graphs had a white square under the numbers and some hadn't. I can't find out where I can change this so that all of them would be without that white background under the numbers:

http://www.shrani.si/f/B/8T/22dMjbNF/img0944.jpg

http://www.shrani.si/f/2Y/bv/1sSyqpAw/img0945.jpg

how can I change that so that all graphs will look the same (without that little squares behind the values).

View 4 Replies View Related

Print An Embedded Word Document

Feb 13, 2007

how to print an embedded Word document using VBA? I have tried using the macro recorder but only the cryptic code below is returned:

Sub Macro2()
ActiveSheet.Shapes("Object 3").Select
Selection.Verb Verb:=xlOpen
End Sub

View 5 Replies View Related

Activating An Open MS Word Document **

Oct 1, 2007

I'm trying to write an Excel VBA macro that opens a .csv file, selects a range of cells, opens a new, blank Word document, and then pastes the cells into the Word document.

I can open .csv file.

I can open MS Word.

I can select and copy the cells in the .csv file.

I cannot figure out how to paste those cells into Word.

View 3 Replies View Related

VBA To Add Multiple Tables To End Of Word Document

Jul 11, 2008

I have an Excel spreadsheet of data that I would like to export into tables in a new word document.

The code below (without the marked section) does this, but I can’t figure out how to create a second table after the first one.

Eventually I will use a For…Next loop to do this many times, but I’m trying to make the problem smaller by just making a second table.

Sub CreateNewWordDoc()
' add a reference to the Word-library
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim wrdTable As Word.Table
Dim xText
Set wrdApp = CreateObject("Word.Application")
Set wrdDoc = wrdApp.Documents.Add ' create a new document
Set wrdRange = wrdDoc.Range
wrdApp.Visible = True.........

View 9 Replies View Related

How To Get Individual Cells To Work Like Word Document

May 7, 2014

I have a column for "Comments". Is there a way to make each cell work more like a word document? ie. paragraph formation, tabs, etc.

View 2 Replies View Related

Pull Data From 1 Row And Use It To Populate Word Document

Jun 30, 2014

I would like to automate a word document that I have to fill out manually based on the info in a spreadsheet. I would like to be able to select a row that the data comes from as well. I have attached the spreadsheet and word document to this thread.

Attached Files:
localLappy.xlsx‎
Repair Summary.docx‎

View 2 Replies View Related

Cleanup Word Document Which Is Created Via Excel?

Feb 20, 2014

I have an Excel spreadsheet that contains information for a Word document. It uses an elaborate macro to "substitute" unique codes in a starter document. At completion of the process, it goes through and delete all unused codes

The problem is that the codes are preceded by a "bullet" symbol.

How can I remove that orphaned bullet symbol. If the code is ". CtlCode10" (where the . is a bullet), then ALL need to be removed

View 2 Replies View Related

Copy Data From Worksheet Into Word Document

Aug 4, 2007

I have been looking for a while for a code to copy cells A1:D23 on a sheet and open a Word Document and paste these onto a document and Save this as the name shown in Cell C1. Everything I see to find is over complicating what I need.

View 6 Replies View Related

Inserting Excel Values Into Word Template

Feb 24, 2014

Month Pay Tax Socia sec.tax
Jan 10000 2000 2999
Feb 15000 3499 3333
March 3455 222 333

I have an excel document with sheets representing employees and within the sheets it shows wages taxes nd social security tax for each month.

I want to create word documents for each month which inserts all the values for that particular month, aswell as the name of the employee into th word document. How to do this?

View 1 Replies View Related

Filling Word Template With Data From Excel?

Mar 31, 2014

I've set myself a project to try and automate some repetitive filling in of word documents and would like a point in the right direction. I've done some research on the MSDN and some sites on the web. The way I was thinking of doing it would be,

make a template with either Fields or Bookmarks (which would be best?) for each piece of data on the paper work.Put the repeated data into an excel sheet (with a button for the macro to be assigned to).

write some VB script that will, define and "label" the data in the XL sheetopen the word templateenter the data into each Field/BookmarkSave as a new file in a "New" folder (name of file and folder taken from the Data)open the next template and repeat.

would this be the best way of approaching this problem?Whats the best way of defining points in a word template, Fields, Bookmarks?what objects would I need to use to rename the folder?

View 5 Replies View Related

Word Template Populated By Excel Data?

Jul 7, 2014

I have a .dot word template that has the little 'grey' boxes that is awaiting information to be filled in, this information is already stored on a master excel sheet and the doc is simply for 'archiving' and users benefit, from my point of view its pointless.

So what I want to know is...

If I always have a .dot file which has :

Username : DATAHERE
Password: DATAHERE
Email: DATAHERE

and I have an excel file which is A1 : Username B1 : Password C1 : Email how easy / hard is it to create a button macro to automatically go to the .dot file location, open it and then put the create data in.

View 1 Replies View Related

Excel 2003 :: Copy Worksheet To Word Document

Mar 30, 2014

I'm trying to copy parts of a worksheet from excel 2003 to word 2003. I've found code that does this alright but I need to be able to re-size the the pasted data to fit the word document. Is there a way to set the properties of the word document like change it to landscape and move the margins etc? Even a simple "reduce the table size to fit the word document". I've included the code i've got already. This code will open up a word document and copy your cells into it but without any useful options. So its ok for a small group of cells.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved