Code That Allows Me To Print A Word Document On One Of My Drives With The Click Of A Button

Nov 9, 2009

I currently have this code that allows me to print a word document on one of my drives with the click of a button in excel. I need to modify it because one of the files I want to print as well is a pdf file. how to modify it so I can do that?

Set appWrd = CreateObject("Word.Application")
Set docOpen = appWrd.Documents.Open("F:groupsdeptservCDTISA.doc")
docOpen.PrintOut
docOpen.Close
appWrd.Quit

View 9 Replies


ADVERTISEMENT

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

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

Create New Document On Button Click Containing Worksheets?

Aug 7, 2013

I have five worksheets among eight total in my workbook that I use as a report. I would like to have a button that copies those five particular worksheets into a new workbook and pastes all numbers as un-linked values. This would save me a TREMENDOUS amount of time generating my reports every month.

View 3 Replies View Related

Print A PDF Document From Userform Command Button

Oct 9, 2009

I have a userform from which I need to be able to print a PDF document when the command button is pressed.

User enters the document number in docnum textbox (eg. 123)

On pressing the commandbutton printdoc, I need to be able to print document 123.PDF to default printer

All PDF Documents reside in a network folder mapped to the S:PDFdrive.

If the document is not found I need to display an error message stating this and return focus back to the textbox.

If the document is found I need to display a message stating document sent to printer.

View 6 Replies View Related

Vba Code To Delete The Empty Bookmarks In Word Document?

Mar 17, 2014

I have been automating reports that will be generated in word documents for every company. The baseline is that I have a excel sheet which contain the data inputs and a word template document (template with bookmarks). I have written a macro that generate the reports when the user clicks the button but found that there some reports that generates empty bookmarks since there is no data for the corresponding bookmark. I have uploaded the excel sheets that has the full data and the setup sheets. The setup sheet has the Column Number, Bookmark Name, Description. The data sheet has the data values and the code info sheet has the name of the template doc and the name of the destination folder where the reports will be generated and stored. My requirement is to delete the empty bookmark from the report named "Blackberry". where to write the macro for deleting the empty bookmarks and its sentences (whether its in excel book or word template doc)?

View 3 Replies View Related

Code To Copy Excel Data To A Word Document

Apr 8, 2009

If possible could someone please tell me why the below code is not calling the normal.doc macro "testy" and any solutions.

The code opens a new document, pastes the text from the clipboard and then fails to run the wanted macro.

View 6 Replies View Related

How To Enter Information In Excel And Use VBA Code To Transfer To Word Document

Jul 17, 2014

I'm trying to get certain Excel cells (varies by column and row) to populate different areas in a Word document. I've tried using both Word bookmarks and form fields and have defined the Excel names with the Word bookmark names as well as using Word's generic terms (Field1, Field2, etc.) with no luck. The VBA code I'm using now is for word forms and will open the Word document but seems to delete the form fields. I don't know if I'm not coding the cells correctly or what.

Sub CreateProposal()
Dim wdApp As Word.Application
Dim wdDoc As Word.Document

Set wdApp = CreateObject("Word.Application")
' Open word document

[Code] ........

View 3 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

Print Button/Msg Box Code

Jun 11, 2009

I have a print button on several sheets in a workbook. I have a code set for it so that when it is clicked, it will bring up a print dialog box. It looks like this...

Sub Button14_Click()
Application.Dialogs(xlDialogPrint).Show
End Sub

However, on one or two of the sheets, I would like a message box to also display when this button is clicked. The button is called Button14_Click()

Private Sub Button14_Click()
MsgBox "Please print new signature cards for customer(s) to sign"
End Sub

View 9 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

Click The Master Button, That Would Click Another Button On A Different Worksheet

Oct 22, 2008

Running into this issue of "transworksheet macros"

I have a master "update" commandbutton on sheet 1. I have two sub "update" buttons on sheet 2 and 3 respectively.

What I would like to do is have the user click the master button, that would "click" the two sub buttons so they run their respective macros on their respective worksheets (within the same worksheet.

I have tried pasting the macro code in the master button, telling it to select the sub worksheet and then run the macro, but the marco runs itself on the master worksheet instead.

View 6 Replies View Related

Click On Color Button And After Button Click It Will Color Entire Row Of Cell?

Jan 23, 2014

what code I can put behind a button so that once I click on that button,

What ever cell i click on, the whole row of that cell will be colored a certain color.

Is this where i would used a target approach?

View 6 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

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

Covert A Word Document

Jan 25, 2009

I need to covert a word document to excel.

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

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

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

Command Button Click Creates New Rows Above Button?

Nov 8, 2012

I currently am using a form button to create new rows.

I need two different kind of buttons. I have a button that does this-

VB:
Sub InsertRow()
'this inserts a row where the button is clicked.
Dim r As Range

[Code]....

However, when I try and create these codes using a Command button (I need it for the color), I get the error

"unable to get the buttons property of the Worksheet class"

P.S one other thing, say the button is in row 3, and Cells A1 and A2 are merged, when you click the button in row 3, it should extend the merge to A3.

View 4 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

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

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 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







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