Open Word Doc And Format?

Jun 5, 2012

I need to open a blank word doc, paste a spreadsheet onto it, format it and filter out some keywords. All from excel of course.

1) Access the internet web page - done
2) Open the excel ss - done
3) Open word - not done
4) Paste the ss onto word - not done
5) Format the doc - not done
6) Filter out rows containing keywords - not done

Just to get started I tried this code to open an existing word doc but it doesn't work

Private Sub CommandButton1_Click()
Set wrdApp = CreateObject("Word.Application")
Set wrdDoc = wrdApp.Documents.Open("C:BShift.doc")
End Sub

It says file cannot be found. There is a file there named BShift in word 2010.

View 5 Replies


Conditional Formatting: If A Cell Value In Column X Contains The Word "open", Format Row Background To Yellow

May 7, 2009

I need to set up some conditional formatting on my spreadsheet, however I am having a little trouble with one of my conditions. The requirement is:

- if a cell value in column X contains the word "open", format row background to yellow.

- if a cell value in column X contains the word "resolved", format row background to green.

- if a cell value in column X contains the word "moved" OR "closed", format row background to blue.

Now I have manged the first two on my own, using the conditional formatting tool and using the formula "=SEARCH("open",INDIRECT("X"&ROW()))".

However I am stuck on the last one. I tried...

=OR(SEARCH("resolved",INDIRECT("X"&ROW())), SEARCH("closed",INDIRECT("X"&ROW())))

However this doesnt work. I tried looking at adding VB script in but to be honest I am not a VB programmer and cant really spend too much time on this. fix the final conditional format so it run if the cell contains either "resolved" or "closed"?

View 5 Replies View Related

Open XL From Word

May 2, 2006

I've took on a task that I stupidly volunteered myself for since no one else will.. including our development or IT team will seem to get completed.

Here's my dilemma:
User has information in Word that needs to go to XL WorkSheet. It has been formatted with tabs so that the information is copy and pasted into individual cells. To avoid human error, I want XL to open with a fresh workbook so that the information can be pasted into it with the Macro being run from Word.

I've searched everywhere to look for code to open XL up from Word and cannot find anything.

Will it be possible to open a new workbook and paste that information all with a macro from Word? Or will I need to trigger a macro in an already saved workbook?

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

Check If Word Is Open?

Apr 12, 2013

know a simple code that I can use in Excel VBA to simply check if Microsoft Word is open or not? I'm not worried about checking for a specific document, but just if the application is running or not.

View 3 Replies View Related

Shell To Open Word

Jun 2, 2009

not sure why this is not working, it is from Access I know this is the wrong forum but figured I haven't got any answers from anywhere else and it seems like a simple fix

this command fails... i am guessing its to do with the file path having spaces but don't know how to get it to work, what to insert so it will work.

Call Shell("V:Program Files (x86)Microsoft OfficeOFFICE11WINWORD.EXE / L:Best Practice ManualFull Labour Hire Best Practice Manual.doc", 1)

View 9 Replies View Related

Open Word File

Jun 7, 2007

I would like to open a word file in my Excel VBA code. The word document has its own VBA code that will run when Excel opens it. I do not need to move any data around I just want Excel to open my word doc.

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

Change In Macro To Open Blank Word Doc

Jul 5, 2009

The following code opens Word correctly, but has too many tool bars open. I only want the tool bars to be opened, just like when you click on the Word Icon at the bottom of the screen. I do not want the following 3 tool bars to open . . . Drawing, Reviewing & Microsoft Office Live Add-In.

View 2 Replies View Related

Create Hyperlink From 2 Cells, Then Open Word

Jun 6, 2006

The purpose of this endeavour is to create a cell that when the user clicks
on it, it will open up a Word file that THAT particular cell represents.

Take the values from Column D (Tract Number), then add a ".doc" extension to
it, then put the UNC filepath (\serverdata
eports) in front of all of that
and put it in Column E. See me example below:

File path plus Tract Number plus Extension

eports 7-5-065-085 .doc

.... to generate something like this:

Use the value (only when the user clicks on the hyperlink) from the cell in
Column E and start up Word.

View 10 Replies View Related

Open Word Doc And Insert Fields From Spreadsheet

Sep 20, 2011

Any way I can open a word doc (template) and insert fields from my spread sheet i can do it with an email.

I have a spreadsheet where I keep customers information on and would like to print a receipts.

View 9 Replies View Related

Macro To Open Word Table Doc And Paste

Aug 26, 2009

I am trying to have Excel 2007 open a Word Table, Select All, then Copy and paste to the open workbook. Here is what I have so far:

Sub Comments()

Dim objWord As Object
Set objWord = CreateObject("Word.Application")
objWord.Visible = True

objWord.Documents.Open "R:JohnstonOfficeProductionSO COMMENTS.doc"

Right now I and getting an "Type not defined" error and the Dim oData As New DataObject step. Also if delete the code to clear the clipboard, I get an error at the WholeStory step.

View 9 Replies View Related

Return To Open Spreadsheet After Pasting Into Word

Mar 22, 2007

I have a code which selects a range within my spreadsheet, copies it and then pastes it into word. The only thing I can't work out is how to get it to then return to the Excel Spreadsheet that I have open.

Sub SetPrintcopy()
Dim appWord As Word.Application
Set appWord = New Word.Application
appWord.Visible = True
ActiveSheet.PageSetup.PrintArea = "$A$1:$F$398"
End Sub

View 5 Replies View Related

Macro To Open Up Word, Grab A Label Template

Aug 16, 2003

Included in the macro, I would like for the macro to open up Word, grab a label template, that I have stored (have to navigate there), and then merge the data from the excel file into the Word template.

View 4 Replies View Related

Macro To Open Word Mail Merge Document

Mar 5, 2007

I want to set up a one step button in an Excel workbook to open up a Word Mailmerge Document that I have already set up complete with Excel data source. I have used this code so far but it's not working. What else do I have to do?

Sub OpenWordMailmergeMasterB()
Set appWD = CreateObject("Word.Application")
appWD.Visible = True
appWD.Documents.Open Filename:="X:Detention filesMail MergeLesley's MailmergeMASTER Interim Report.doc"

'To Run the Mail Merge
'Data source is a range name in Excel workbook called "MailmergeReport":.....................

View 4 Replies View Related

Number Format By Searching Word For Row?

Jul 22, 2014

write a macro that search first Row and if its finds the word "Date" then the whole column should select and change the Number formatting to Date, and if it finds the word "Time" it should change the formatting for the whole column to Time.

Below is the format of Table where it should change the formatting of Date, Start Time and End Time.

Start Time


View 2 Replies View Related

Open No Fixed Name (*.xls*) Format In VBA

Jan 5, 2010

I have open a workbook and copy the data from that workbook to another workbook.

Here the problem is workbook name is not fixed. How to oepn that workbook.
I used the belwo statement but giving error "no file name"

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

Excel 2010 :: Changing Default Chart / Graph Format Copied When Pasted Into Word?

Aug 28, 2012

I work with a team of users that are continually publishing reports in Word that contain charts and graphs copy and pasted from Excel into Word 2010.

We have a custom script that leverages a PDF engine to automatically convert .doc files to .PDF files that we distribute electronically to our clients. This all works great, but only if all my users select 'paste special' and Enhanced Metafile Format when adding their excel charts into our reports. Most of these people aren't tech savvy, and I'm havin ga hell of a time getting them to follow this workflow and am hoping there's a way in Office 2010 to select the default paste from excel into word when the content is a chart.

It seems like the default paste from excel is an embedded chart/graph that you can then further manipulate each component of the chart in Word; the default doesnt' paste an actual image. I am assuming the pdf renderer is using a lower resolution .PNG version of the image and when these are scaled for print and or pdf, they look like crap.

Is htere anyway I can automatically change the default paste format for the chart from excel into word to be an EMF/EMV (enhanced metafile?) Either thorugh the registry or some other saveable setting?

View 1 Replies View Related

Custom Format Code Injected On Document Open

Nov 19, 2012

I am experiencing odd behavior with Excel (v. 14). When a spreadsheet is opened, format setting of almost all cells in the workbook have changed to a custom code that reads "[$-409]0%". AFAIK the first part is not even a valid tag.

Because the underlying data is not changed, I can just select cells and reset formatting to "Number" or "General" and everything's fine. However, I'd like to get to to the root of the problem.

The problem occurs with only some workbooks. I should mention that the workbooks are circulated in different language versions of Excel, which may contribute to the problem.

View 2 Replies View Related

Save / Convert XML Files In Excel Format Without Open Them Into XLS?

Oct 11, 2011

Is there a way to convert all files in folder, in this case, xml in excel format to xls without open them?

I recorded the macro below, but this needs to "Open" and "SaveAs" the current file in folder and there are a few thousands of xml files in folder.

I was wondering if through some ADO or VBA code this can be done without open the files in order to save resources and get the work done faster?

Sub Convert_XML_to_XLS()

Workbooks.Open Filename:="C:MyPathInputFile.xml"
ActiveWorkbook.SaveAs Filename:="C:MyPathInputFile.xlsx" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False '
End Sub

View 3 Replies View Related

If Fill In A Number Open Word And PDF Doc That Is Attached To That Number

Jun 3, 2014

I have on the first tab a screen where you can fill in the name of the .doc or .pdf file.

That works fine, but now I would like that when I fill in a number and click on test, it opens te .doc and .pdf file that is attached for that number.

If you take a look at the pdf file you will see a second and a third tab.

First column is the number they need to fill in and the second column is the name of the .doc or .pdf that needs to be opened with that specific number.

How to link it and open both files for that specific number.

But not every number has a .doc as well as a .pdf.

View 5 Replies View Related

Range: Format The Entire Row For Any Row That Contains The Word "total"

Mar 24, 2009

I would like to format the entire row for any row that contains the word "total". When I run the following, it fails on the line with ActiveSheet.Used Range. Here is the code (pulled off of another post):

View 3 Replies View Related

Excel 2010 :: Can't Save Custom Table Style Format So That It Is Available Next Time When Open Workbook

Jun 10, 2013

I'm a fan of the Excel 2010 table styles, but can't figure one thing out. When I create a table in excel (Ctrl+T), I like to reformat it with a new defined style. When I save the style, I can use it while I'm in that instance of excel, but when I close and reopen excel, the style is gone. How to save the custom formats to they are always available?

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


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

Excel 2003 :: Count How Many Times A Word Is In A Range / Word Can Be In Cell More Than Once

Feb 16, 2012

I need to count how many times the word Test is in the range B4:H9 with

Range N2 = Test the formula below works if Test is only in the cell once.

=COUNTIF($B$4:$H$9,"*" & N2 & "*")

But I have data in cells like below, this is all in one cell, so how would I have it count all the times test is in the range when some cells have test 2 or more times in a single cell?


View 5 Replies View Related

Using The IF Function, To Make Entering A Word, Space Then Word Correct

May 6, 2009

How can I use the IF function, to make entering a word, space then word display correct and incorrect if not.

View 13 Replies View Related

How To Search For A Word In A Column And Have Entire Row Opaque Once Word Is Found

Sep 3, 2009

I need my macros to search for the word "Cancel" or "Cancelled" in columns "T" and "U". Once found, I need the macros to make that entire row an opaque shading.

There will be other wording in these cells that contain "Cancel" or "Cancelled". Is it possible for the macros to search in the sentence and find the words "Cancel" or "Cancelled"

I started on the code below but am stuck.

View 14 Replies View Related

Find A Certain Word In A String Then Return The Number Associated With That Word

Jun 9, 2009

Have problems using find and the Dictionary
What Im trying to do is find a certain word in a string then return the number associated with that word

View 7 Replies View Related

Pick Word From Excel Search In MS Word And Replace All

Jan 4, 2012

I am trying to automate the below process:

1. I have a excel file with Japanese words in column A and their English equivalents in column B.

2. I am trying to create a Macro and assign it to a button. On pressing the button Macro should be able to:

3. open a form where I can enter location of a word file.

4. Macro should open the word file specified in (3).

5. Macro will pick up first Japanese word from excel file (Sheet 1 - A1)

6. Search for that word in Word file

7. Replace the Japanese words in Word file with their English equivalent from excel (B1)

8. Then it should search for second word (A2) and replace with its equivalent (B2) and so on till it reaches last filled cell in excel file column A.

After a lot of search I could find a code from net (Below), made a few changes, but it is not working.

Private Sub OK_Click()
' Requires a reference to Microsoft Word xx.x Object Library
Dim sFile As String


View 1 Replies View Related

Copyrights 2005-15, All rights reserved