Publish Excel List In Word?

Aug 17, 2013

I have a list of club members in Excel.

Is there some method in Word that allows a directory in Word to update from the Excel List?

E.g. If new members are added to Excel, When I open Word, the new members are shown automatically?

View 1 Replies


Publish Excel To Internet Web Page

Feb 3, 2010

I have this spreadsheet that I use regularly and that others also view (not edit) and to facilitate viewing, I would like it to go on the net.

Ideally, simple editing would be done from within the browser.

View 5 Replies View Related

Excel To HTML - Auto Publish With File Update

Feb 18, 2011

Im trying to use excel as part of an real time display system, what im looking to do is after xx time period import some data (which is fine, I have that bit sorted), then save to as html- (hopefully using excel 07 abilty to repubish data to update the same file with more info).

I have added some Javascript to the html file to auto scroll, and then will be adding a refresh script which should hopefully update the display with any new info genrated from excel...

so far I have found the following code, but could do with a hand to tie it all up!

Public Sub Watchon()
State = "Mointoring Folder..."
Timerun = Now() + TimeValue("00:10:00")
Application.OnTime Timerun, "DetectNewFiles"
Userform1.Nextupdate.Caption = ">Next Update will be @: (" & Timerun & ")"
With ActiveWorkbook.PublishObjects.Add(xlSourceSheet, _


Then within DetectNewFiles Sub, I need to update the html data, I guess I can't reuse the above bit, as it would just overwirte the whole file (and so remove javascripts too).

Sub DetectNewFiles
'Some code to import text files to excel
With ActiveWorkbook.PublishObjects("Book1_24990")
.Publish (False)
.AutoRepublish = True
End With

Some code to reset next time update of DetectNewFiles

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

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

Publish File On The Web

Aug 13, 2008

I developed a small program using Microsoft Office Excel 2007 and VBA. The program contains some user interface items such as command buttons and userforms for user input.

During the distribution of the program I realised that most users do not have Excel 2007 yet. When I try to convert the file into Excel 97/2003 it is not possible because I used features not available in this version.

I was wondering if there is any way of publishing the Excel file in the web. In this way Excel 2007 would exist in the server and the users could use the file directly from the server without needing Excel 2007 installed in their computers.
I tried to save the file as "Web page" or "Single File Web Page" but the "buttons" stopped working, I guess the VBA code is not saved..

View 4 Replies View Related

Replace Word In MS Word With Varable From MS Excel

May 1, 2009

I am in the middle of automating a process here at work, the program takes a word, "pencil" for example, from excel. It will then open up a word document with content already in it (premade template). The program will then find all instances of a string, "placepencilhere" for example, and will replace that instance with the string from excel.

Basically I want to be able to take a variable that has a stored string value from excel and use it to replace another variable in a word document.

I tried recording a replace (ctrl+f, replace tab) macro, copying the code, and inserting it into the excel vba code.. but I get a error message. Here is what I have:


View 11 Replies View Related

VBA To Publish A Worksheet To Our Website

Nov 7, 2007

We are a construction company.
We travel and do work local.
Some employees that have access to the internet at home.
Some have access when they stay at hotels.

What I would like to do is give them a work schedule on our website.
I would really like to do this using VBA.
Is it possible to save the worksheet and send it to our website?
I would love to attach a Macro to a button so the person, after updating the schedule, just punches that button and the updated sheet goes on our website.

View 9 Replies View Related

Publish Data To Sharepoint Calendar

Nov 16, 2007

I use an excel report that connects to an external sql datasource and using macros imports and arranges the data showing dates, job number, description and author of various jobs coming up at work.

I want to publish this spreadsheet's contents onto a calendar in excel or (preferably) onto a sharepoint calendar.

Does anyone know how to:

1) Publish the spreadsheets contents into a calendar in excel?

2) Publish the spreadsheets contents onto a calendar in sharepoint?

View 3 Replies View Related

Excel 2010 :: How To Populate Sheet2 From Sheet1 After Finding Matching Word On Sheet2 From List In Sheet1

Oct 4, 2013

I have 2 Worksheets in an Excel 2010 Workbook -

Column1: contains the word "dog"
Column2: contains the word "bark"

Column1: contains the sentence "I like dogs a lot."
Column2: is blank

What I need to do is search Sheet2/Column1 for the presence of "dog" and if it's present, populate the word "bark" in Sheet2/Column2 from Sheet1/Column2.

How can I do this?

View 4 Replies View Related

Macro To Publish Print Area From Active Sheet To Web Page

Feb 26, 2009

I am trying to write a macro that publishes the print area as a non-interactive web-page to a file that sits in the same location as the spreadsheet from which the macro is being run.

I am using the the following macro:

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

Getting Mailing List Into Word

May 1, 2013

I created a new mailing list in excel, but when i try to open in word mail merge nothing happens. I have MS word 2008.

View 4 Replies View Related

Look Up One Word From Cell In Another List?

Jul 2, 2012

I have a list of print titles and a list of eBook titles. I need to do a lookup ot bring across the ISBN of the print book over to the eBook list so I can compare them. I have already done the standard Trim and vlookup, and the "*"&A2&"*" lookup but there are still about 70 titles I need to find. For instance:

Table 1
B1 = 9780199134979

Table 2
B2 = 9780199135589

Is there a way I can just look up BATMAN from A1 Table 2 so that it returns B1 from Table 1 (the ISBN) in a new cell?

View 5 Replies View Related

Finding Anagrams In A Word List

Jul 28, 2009

In column A we have words, like this:


In column B we have another list of words:


I need a formula in C1 which will check all the words from column B and find the ones which are anagrams of some of the words from column A, and then return those words next to them.

(Anagram is the word made up of another word's letters, without repeating or omitting any, for example anagram of SPARK is PARKS).

In the example above, we would have the words: EXCEPT next to EXPECT (in C3), OUTSIDE next to TEDIOUS (C5), and STREET next to SETTER (C7).

View 10 Replies View Related

MS Word Large Numbered List

Sep 1, 2009

I have a very large numbered list in MS Word, in the following style:

1. Animals
1.1 Mammals
1.1.1 Dogs Beagles Pugs
1.1.2 Cats
1.1.3 Elephants
1.2 Fish
1.2.1 Cod

...and so on.

I am trying to bring this data into Excel (2007) but in a way so that:

"Animals" goes into column A.

"Mammals" and "Fish" go into column B (in their own cells, in different rows).

"Dogs" and "Cats" go into column C.

"Beagles" and "Pugs" go into column D...

and so on.

The idea is to have each line in a different row, but have the columns serve more or less the same function that the tab indents do when looking at it in Word. (I'm trying to create a "breadcrumbs" style list for each line item). I've tried using tabs as a delimiter for importing text into word, but it doesn't seem to recognize Word's tabs when applied through a numbered list.

View 4 Replies View Related

Word List And Count From A String

Oct 30, 2008

I want to take a string which is a list of words and compile a list of the words listed and how many times each one is listed. For Example, for the string "word1, word2 word1, word3 word2"

I want to get the following calculations:

word1 = 2
word2 = 2
word3 = 1

View 5 Replies View Related

Display All Results From Word List That Appear In Cell

Dec 21, 2013

How to do this query but show all results found rather than just one result.

I want the result to be able to show multiple terms from the search terms and index.

for example

Bob's BMW and Ford

Result would be


Rather than just Ford

Is this possible?

View 8 Replies View Related

Pasting List Of Text And Numbers From MS Word

Jan 17, 2010

I have a very large list of top scorers for a sports team MS Word. The name and number of goals are both on the same line. Is there any possible way I can past them into Excel, so as they are pasted into 2 separate columns?

View 2 Replies View Related

Most Occurances In One Column Of The Same Word (List Of Suppliers)

Apr 28, 2009

I am trying to find the most occurances in one column of the same word (List of Suppliers) and return how many times that name cropped up, would like to use a single formula to do so and not have another column with numbers in it if possible.

View 9 Replies View Related

Create List Based On Word Chosen

Feb 6, 2008

If a specific word is entered in a cell I want a list to show in another cell. This is better explained in an example. In cell A2 I have a validation list of names, eg. Mary, Mary Birth, John, John Birth,. . .) In cell N2 I have another validation list of places , eg. Ireland, England, Wales, USA, Scotland, . . )
In A2 if a name with Birth is chosen then I only want them to be able to choose from Ireland or England.

View 2 Replies View Related

Find All Instances Of Word And List Adjacent Cells

Apr 1, 2008

I have a sheet where in one column, the word "high" will be repeated. I need to find these multiples and then list down in a seperate column the text relevant to each of those multiples (contained in an adjacent cell). I.e if A1 & A3 hold the text "high", take the corresponding values in b1 & B3 and list them in new column C (C1 & C2 continuing in sequential order). I have searched the forums but i can' t seem to find anything.

View 9 Replies View Related

Input Text From Group List If Lookup Found Certain Word In Sentence

Jan 27, 2012

i have list in A2:A4 (description) and B2:B4 is the Group of.

now i want B2:B4 fill using E2:G2 (group list which is Animal, transportation and fruit) if one of the key word in E3:G5 found in A2:A4

A2: people like to eat apple
A3: car is very expensive
A4 : dog is human best friend

E2: Animal, F2 : transportation, G2: Fruit

E3:E5 = dog, cat, horse
F3:F5 = train, ship, car
G3:G5 = apple, banana, watermelon

result i want is :

B2 :Fruit,
B3 : transportation
and B4 is animal

View 3 Replies View Related

Excel To Word

Dec 1, 2009

i have a set of data in excel.. i want that, when i click a command button on an active worksheet, it will be transferred in ms word all the data found in excel.

View 14 Replies View Related

Remove The Word Total From Each Cell Without Deleting The Numbers After You Copy From A Subtotal List

Jul 29, 2009

if you can remove the word total from each cell without deleting the numbers after you copy from a subtotal list?

View 9 Replies View Related

Exporting Excel To Word?

May 21, 2014

I have this excel sheet which I want to export to a word document. The following code has been used:


It creates a word document but it only copies and pastes a picture of the excel sheet. I want for the user to edit the word document values that are pasted from the Excel sheet. I know I need to change somewhere in the:

[Code] .....

How can I paste values from excel to word that can be modified inside of word?


How can I change the layout of the word document, for example if I want to add a header and a footer?

View 2 Replies View Related

Macro For Word In Excel

Dec 10, 2008

I am trying to do the following:

I am creating an order checklist in Excel. I want it that if the sales rep clicks on a certain field that a macro will populate the form that is needed. If the rep does not click on that box then the certain form will not be populated. Is this possible?

View 14 Replies View Related

Opening Word Doc From Within Excel Using VBA

Aug 22, 2013

I have a database list, and run a bunch of formatting, inserting, formulas etc., to be able to have a Word Mail Merge be able to run against the data when finished. I'm automating the process and want to be able to open the Word document when the Excel piece is done, so the user doesn't have to navigate to the file manually.

Since Excel doesn't seem to automatically 'see' Word docs in the Open File dialog list, my Open File code below is getting an error of "File Format is Not Valid":

ChDir "O:UAIBDCustomer RelationsIDHome Office Indexing"
Workbooks.Open Filename:= _
"O:UAIBDCustomer RelationsIDHome Office IndexingID Home Office Indexing Mail Merge Template TESTING.docx"

View 6 Replies View Related

Using Excel VBA To Control Word

Sep 21, 2009

I'm writing a spreadsheet which performs automatic reporting in Word at the moment and, having done this once before I thought it would be simple... Unfortunately however I seem to have run into the following problem:

I'm trying to have Excel paste in a table, then move down one line, enter a page break and then repeat for all of the tables it needs to paste.

Among a rather large sub which I re-used from another project is this bit of code which is relevant to this part:

Dim AppExcel As Window
Set AppExcel = ActiveWindow
Set appwd = CreateObject("Word.Application")
appwd.Visible = True

Set appwd = CreateObject("Word.Application")
appwd.Visible = True
appwd.Documents.Open Filename:=FileToOpen

'select test bookmark
The key bit is this segment, which is the part repeated for each table (it all works up to here)

For K = ActionFrom To ActionTo
Cells(3, 2) = K
Call SelectNode
LR = Sheets("Data_Entry").Cells(Rows.Count, "B").End(xlUp).Row

Worksheets("Data_Entry").Range("B7:I" & LR).Select

With appwd
.Selection.MoveDown Unit:=wdLine, Count:=1
.Selection.InsertBreak Type:=wdPageBreak
End With

Next K

The two bits in red are what I am trying to now do, but Word keeps returning the error 'bad parameter'. I've tried doing it both in and out of the 'with' function and I can't seem to make it work...

View 9 Replies View Related

Sum Based On Word Type In Excel?

Dec 28, 2012

I need to read A1 Rows and if it's values is bold letters then i have to add from top of it's above un bold members like that the should work for 2000 rows Like below Ites income - (A) vlues need to be added from row 3 to row 9

ITES Income
B P O - Domestic


View 1 Replies View Related

Copyrights 2005-15, All rights reserved