Free Microsoft Excel 2013 Quick Reference

Put form fields in Word forms into an Excel spreadsheet?

I have multiple Microsoft Word 2002 forms with the data in form fields. I
would like to convert the data into Excel 2002 so that the data from text1,
text3, etc., are placed in an Excel table with each document's form fields in
a line of Excel. I hope to be able to import the Excel Spreadsheet into
Quickbooks 2005 as invoice data.


i would like to convert a word document into an excel spreadsheet.

First question: I'm trying to insert an object (MS Word document)
into an Excel spreadsheet of a shared workbook. The Word document is
2 pages, but the inserted object only displays the first page. How
can I get it to show both pages?

2nd question: I'm trying to have this shared workbook open.
automatically update links, and not display the startup prompt. After
checking the Help file, I learned that I needed to:

1. On Edit menu, click Links.
2. Click Startup Prompt.
3. Select the option you want.

I've done this, and I selected the option: "Don't display the alert
and update the links". However, every time I open the file, the alert
still displays. How do I get it to stick?

Also, I know I can go to Tools>Options>Edit and uncheck the box "Ask
to update automatic links", but the help file says this is only for
the current user, and I want this link to be updated for all users and
no alert to show. Thanks for any help.

Frank

The database that I am working from sends me a report as a word document. I
would prefer that this information be presented in excel, that way it is
easier to manipulate the report. There is no option for me to choose between
word or excel. I would just like to know how I can transfer data on a word
document to an excel spreadsheet?

This may be more of a Word related query but I haven't been having much luck on other forums and thought it was worth trying on here.

Basically I need to compile a large number of reports in word format, with an Excel spreadsheet pasted in as part of the report.

Is there any way (third party software, macros etc) I can automatically copy information from particular cells of the excel spreadsheet to other set areas of the word document?

i.e. I want the address line from the excel spreadsheet automatically added to a table on the front page (of the word doc) as well as to the footer of the whole document.

Thanks for your help

Is it possible to link a WORD file into an Excel worksheet?
I have an excel workbook and need to include some WORD docs
I’d rather have a live link than cut & paste & it never gets updated once I’m out of the picture.

I would like to link different paragraphs from an Word document into an Excel
workbook. Any sugestion is welcome.

I would like to copy word doc into an excel doc, rather than going into the
word doc each time and doing a copy/paste.... is I have done this with other
exel docs but not going through word.... any help would be much appreciated!

How can I post a thumbnail from an External Webserver to an Excel
spreadsheet..

For instance:
url: 192.168.192.16/image/chair.gif

this is my url and I want it export it into an excel spreadsheet, is it
possible for excel to be smart enough to read the url and just bring in the
thumbnail image?

I have no clue how to do this anybody have any ideas?

Thank you!

I need to attach a word doc into a excel spreadsheet. I thought that I have
seen this done in the past, maybe not? Does anyone know who to do it?

Thanks

how do i put a pic in the background of a excel spread sheet i saw it done
before but can not figure it out?

Hi Brian,

would like to know about any workaround for .pdf & .zip files. For all other
office formats we are using,

Excel.Shape shp = (Excel.Shape)oSheet.Shapes.AddOLEObject(Type.Missi ng
" ,true,true,"packager.exe",0,"test.xls",Type.Missin g
,Type.Missing ,Type.Missing ,Type.Missing );

What can be parameters for .pdf & .zip files?

"Brian-in-CA" wrote:

> I am trying to fully embed a *.pdf file into an Excel spreadsheet so that a
> simple Adobe icon appears in a cell. I want to be able to email the
> Spreadsheeet to co-workers and they should have the ability to double-click
> on the icon and open the Adobe file. I have done this in the past but it seem
> like sometimes the file can be opened and sometime it cannot.

Adobe PDF files can be marked up with highlights and comments. Is there a way
to take those comments and import them into an Excel spreadsheet so that they
can be organized and sorted through?

I'm suddenly unable to embed an Outlook msg into an Excel spreadsheet, which
I last did on October 21. The only MS update that's been added to my PC is
the latest critical security patch.

My spreadsheet is set up as 2003-compatible and I've saved the Outlook
message to my desktop as type "msg." Within Excel, I try to Insert -->
Object --> Create from File. I browse to find the file, click insert, then
OK, and Excel hangs.

Any suggestions?

Thank you.
--
Mary Ellen Whyte

How do I insert a checkmark into an excel spreadsheet? The shortcut does not
work using the ALT+0252.

Can you import data from a scanner into an excel spreadsheet?

Hey guy's im new here and my second question here starts off quite difficult.

First off:
My programs : Office 2010
My skills: limited ( i've been searching the web for quite some time now and leand a view things from what i've read)

My question:

For my work i want to create ( i was asked to do ) an database of machine testing specs.
They have 200/300 word documents with an table in it with the specs.
I want so import this info from the word document into an excel spreadsheet. ( easy data comparison and so on )

I've already asked the question how to automate the proces of exporting the data from word to an excel file ( in the word and excel help forum )
I think those guys can help me, but you guy's to ( its more excel then word vba ) so i'm asking the same here.

I've got an working macro for data extraction form the word talbe in to excel via VBA.

	VB:
	
 ImportWordTables() 
     'Imports cells (3,2) and (4,2) from Word document Tables 1-10
    Dim wdDoc         As Word.Document 
    Dim wdFileName    As Variant 
    Dim TableNo       As Integer 'number of tables in Word doc
    Dim iTable        As Integer 'table number index
    Dim iRow          As Long 'row index in Excel
    Dim iCol          As Integer 'column index in Excel
     
    wdFileName = Application.GetOpenFilename("Word files (*.doc*),*.doc*", , _ 
    "Browse for file containing table to be imported") 
     
    If wdFileName = False Then Exit Sub '(user cancelled import file browser)
     
    Set wdDoc = GetObject(wdFileName) 'open Word file
     
    With wdDoc 
        TableNo = wdDoc.tables.Count 
        If TableNo = 0 Then 
            MsgBox "This document contains no tables", _ 
            vbExclamation, "Import Word Table" 
        ElseIf TableNo > 10 Then 
            TableNo = 10 
             'Else TableNo is actual number of tables between 1 and 9
        End If 
         
        Range("A1") = "Table #" 
        Range("B1") = "Cell (3,2)" 
        Range("C1") = "Cell (4,2)" 
         
        For iTable = 1 To TableNo 
            With .tables(iTable) 
                 'copy cell contents from Word table cells to Excel cells in column B and C
                Cells(iTable + 1, "A") = iTable 
                Cells(iTable + 1, "B") = WorksheetFunction.Clean(.cell(3, 2).Range.Text) 
                Cells(iTable + 1, "C") = WorksheetFunction.Clean(.cell(4, 2).Range.Text) 
            End With 
        Next iTable 
    End With 
     
    Set wdDoc = Nothing 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
This macro works for me, but it will only get the data from 1 file ( via selection ) ,
I want it to do so automaticly ( and for later document to ) and i thought that i've it save the data to an single excel file is the best thing.

So: The extracted data from 1 word file is saved in 1 excel file.

And then later on i import the data from all of my excel files in to 1 master (database) excel file.
Preferbly via VBA Macro

Since i've not used macros or vba before it thought that was the best for me. And easyer to understand.
And dont get it all in one file with a huge macro wich is difficult for me to understand multiple steps.

I've already made an seperate excel file with the cell names that contains the data i need.
And made an range (with titles i want to have)
So i can copy it into the macro ( easy )

The code above works, and when i copy my ranges and cell info it works. But give's me an error on empty ( there i dont have the basic knowlegde to overwrite that )
I know it has something to do with the cleaning cell option. But dont have the knowlege ( also didnt have the time to find out ) how to overcome that.
For you it sure will be an easy task.

I hope i've been clear enough of what i want, i've not then please ask.

Thanks in advance!!!

Edit: The macro contains a fault,, i've changed the first line :Dim wdDoc As Word.Document
and changed Word.Document to Object to make it working

Hello,
I am trying to loop through a series of fields on a pdf form and read the values into an Excel spreadsheet. I found some code on another site (www.khk.net) which looks like it should do the trick, but I get an error - Object Required - on the line that is trying to assign the field value to a variable (it appears the author did not DIM the variable correctly, but it fails on either one). I have Acrobat and I have checked the reference to Adobe Acrobat 10.0 Type Library in the VB Editor. When I open the form in Adobe LiveCycle Designer, the Field Name matches. Can anyone point me to the problem? Thanks in advance.


	VB:
	
 CommandButton1_Click() 
    Dim AcroApp As Acrobat.CAcroApp 
    Dim theForm As Acrobat.CAcroPDDoc 
    Dim jso As Object 
    Dim text1, text2 As String 
     
    Set AcroApp = CreateObject("AcroExch.App") 
    Set theForm = CreateObject("AcroExch.PDDoc") 
    theForm.Open ("C:tempsampleForm.pdf") 
    Set jso = theForm.GetJSObject 
     
     ' get the information from the form fields Text1 and Text2
    text1 = jso.getField("ESName").Value 
    text2 = jso.getField("ESID").Value 
     
    MsgBox "Values read from PDF: " & text1 & " " & text2 
     
     ' set a text field
    Dim field2 As Object 
    Set field2 = jso.getField("Text2") 
     
    field2.Value = 13 ' assign the number 13 to the fields value
     
     ' get the information from the form fields Text1 and Text2
    text1 = jso.getField("Text1").Value 
    text2 = jso.getField("Text2").Value 
     
    MsgBox "Values read from PDF: " & text1 & " " & text2 
     
    theForm.Close 
     
    AcroApp.Exit 
    Set AcroApp = Nothing 
    Set theForm = Nothing 
     
    MsgBox "Done" 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Hi -
I have a number of word documents that are labels, not originating from a data merge from excel, that I need to get into an excel document.

They are set up in tables in word for labels, but I need each label to be its' own row in Excel, and separate each field.

An example:

First Name Last Name
Company
Address
City St Zip

I need the excel document to be in rows, with each field it's own cell:
First Name | Last Name | Company| Address| City | St | Zip

Is there any way to get this word information into an excel spreadsheet without having to retype all of it?

Any help would be greatly appreciated!

I have a Word document with the following repeating layout.

HEADING 1
124
HEADING 2
Monster, but in reality, occular, but, twenty four horses in kindness
of love of the saint of buddha. Men in green trousers up the valley
discovered the mouse of cordless. Wireless. 1245 Hi.
HEADING 3
$123,425-$1,566,109
HEADING 4
123 Fake St. Middle of Nowhere, Empty Country

Then a new entry starts, and so on. Not all entries have all the
headings. E.g., a few might be missing heading 2 or 4. There are also
more than 4 headings, but that is irrelevant.

How could I convert this mishmash of types of cells (number, address,
text) into an Excel chart? The same headings can be conserved.

Thanks a lot.

--
Rageaholic
------------------------------------------------------------------------
Rageaholic's Profile: http://www.excelforum.com/member.php...o&userid=24423
View this thread: http://www.excelforum.com/showthread...hreadid=380256

I have a Word document with the following repeating layout.

Heading 1
124
Heading 2
Monster, but in reality, occular, but, twenty four horses in kindness of love of the saint of buddha. Men in green trousers up the valley discovered the mouse of cordless. Wireless. 1245 Hi.
Heading 3
$123,425-$1,566,109
Heading 4
123 Fake St. Middle of Nowhere, Empty Country

Then a new entry starts, and so on. Not all entries have all the headings. E.g., a few might be missing heading 2 or 4. There are also more than 4 headings, but that is irrelevant.

How could I convert this mishmash of types of cells (number, address, text) into an Excel chart? The same headings can be conserved.

Thanks a lot.

I have MS Project data in a pdf (Adobe Acrobat Pro v7). As there is 6 pages
of data, is it possible to quickly extract the data (by copy/paste or
converting the file type) from the pdf form into an Excel spreadsheet?

Ok, it wont let me ask what i really need in the title so here goes -

I need to know how do I add a Word document into an Excel Spreadsheet? I know you can - it shows up as a little .doc in the cell - I just have no idea how! I did a search on here and it doesnt look like anything has come up about this before. Any assistance would be greatly apreciated!

PS - Nice Forum - great idea!

Hi there,

I'm having some issues formatting a mail merge field in Word 2003.

Using an Excel spreadsheet as datasource. The data in the field in question looks like this:

	VB:
	
633597032004B7 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I want just the last 8 characters.
Now i tried using

	VB:
	
{ MERGEFIELD ISAM_ID_633597 # "x#######" } 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
However the field then comes out as "97032004" - dropping the B7...

Is there just a universal character option? I've tried replacing with *, @, % and cant get any to work...

Any ideas?

Cheers
Gavin

I want to copy a word file (76 pages with underlines, tables, pictures, etc)
into an excel without turning into something very messed up like it does.