Tech Problem Aggregator

Solved: Exporting Repeated Forms In One Word doc To Excel

Q: Solved: Exporting Repeated Forms In One Word doc To Excel

Hello,

Relating to a previous post:
"Exporting Word Form Data to Excel"
http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html
regarding the same form in many word docs esported into an excel sheet

My question is whether its possible to export repeated forms in ONE word doc so they collate into 5 columns.
(Would like the first 2 columns and 2 rows left empty )

My form look in word is thus:

Story:
Image: 01
Display-image:
Courtesy:
Caption:

Story:
Image: 02
Display-image:
Courtesy:
Caption:

Story:
Image: 03
Display-image:
Courtesy:
Caption:

etc

Sample.doc is below

This macro obtained from:
"Solved: Export Word Form to Excel"
http://forums.techguy.org/business-applications/1062655-solved-export-word-form-excel.html
works well for the same form in many word docs exported to excel:
Code:

Dim vField As FormField
Dim fso As Scripting.FileSystemObject
Dim fsDir As Scripting.Folder
Dim fsFile As Scripting.File
Dim wdApp As Word.Application
Dim myDoc As Word.Document
Dim vColumn As Integer
Dim vLastRow As Integer
Dim x As Integer

Sub AddFormFields()

If ActiveSheet.UsedRange.Count = 1 Then
vLastRow = 1
Else
vLastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row + 1
End If
vColumn = 1

Set fso = New Scripting.FileSystemObject

Set fsDir = fso.GetFolder _
("C:\Documents and Settings\User\Desktop\CIKA 2004\Members\UnProcessed")

Set wdApp = New Word.Application
wdApp.Visible = True

For Each fsFile In fsDir.Files

wdApp.Documents.Open (fsFile)

Set myDoc = wdApp.ActiveDocument

For Each vField In wdApp.Documents(myDoc).FormFields

vField.Select

vValue = vField.Result

Workbooks("Members.xls").Activate
Cells(vLastRow, vColumn).Select

If vField.Type = 71 Then

Select Case vField.Name

Case "Check1"
vColumn = vColumn - 1
If vField.Result = "1" Then
ActiveCell.Value = "YES"
End If

Case "Check2"
If vField.Result = "1" Then
ActiveCell.Value = "NO"
End If

End Select

Else

ActiveCell.Value = vValue
End If

vColumn = vColumn + 1

Next

vColumn = 1
vLastRow = vLastRow + 1

vFileName = wdApp.ActiveDocument.Name

wdApp.ActiveDocument.Close

Name fsFile As _
"C:\Documents and Settings\User\Desktop\CIKA 2004\Members\Processed\" & vFileName

Next

wdApp.Quit
End Sub

Is it possible? .
.

A: Solved: Exporting Repeated Forms In One Word doc To Excel

12 more replies
Answer Match 85.26%

Running WinXP and Office 2003

Hello. This is similar to http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html

I tried using and tweaking that example but am having a hard time because there are several different things.

I will be having hundreds of word documents. The first page on each doc is just a form that a user fills out on the computer. I would like some help with the macro that would run and process a folder of these docs.

I would also like to have 3 sheets in the one excel file. The doc file will be filled out generally by 3 departments. Is there a way to have a drop menu in the doc to indicate which dept and also have this transfer to their respective sheets in the excel file? The rest of the doc fields should be the same. Also I need the hyperlink to the file in their respective cell.

Sorry I am new to code in excel and am starting to learn its power. Thanks for your help!
 

A:Solved: Exporting Word Form Data to Excel Spreadsheet

16 more replies
Answer Match 77.28%

I have a form that is in Microsoft Word format and I am trying to pull information from Excel for highlighting. I am looking for Word to check the contents on the Excel spreadsheet and highlight the area on Word if necessary. Does anyone know how to do this? I have already incorporated the mail merger feature on this form and an envelope, however I would like to highlight the necessary areas of the form depending on the contents of the spreadsheet.
 

A:Exporting Information from Excel to Word

8 more replies
Answer Match 76.44%

So this seems like a very basic thing to do but I'm relatively new to VBA. Working in Office 2010.

I have a database that has customers names, years doing business with us, an other catagories to do with their credit/debit amounts. I also have a word document that I set some bookmarks up in the reference to them.

It would be nice to select a customers name, hit a command button and export the row of data associated with that customer to word. It would probably be best if the word document is already opened because the file location might change, or the document might change.

If anyone can guide me through this, that would be greatly appreciated.

Thanks
 

More replies
Answer Match 76.44%

I am trying to make an database of members for a racing organazation.

Each member has a word document which contains the membership form filled out with Word's Form feature. I know you can do Options > Save > Save Form data only, then save for each file, but i'd like to automate the process and save only form data for all of the documents at once.

Secondly, I'd like to import them into an excel spreadsheet. I've used the data import feature, but once again, the process has to be repeated for every single file. I cannot select more than one. Again, I'd like to autmate it. How?

Better yet would be a method to take all the .doc file's form data straight into excel without going to the middle .txt file.

Thanks for your help,
Doug
 

A:Exporting Word Form Data to Excel

14 more replies
Answer Match 75.6%

Hi,

I have created a protected Word form, which comprises of text fields, drop down fields and tick boxes. I have an Excel spreadsheet with columns corresponding to most of the labels in my Word document.

Is there any way in which I can selectively export data from the Word form to the spreadsheet such that selected form fields data is exported to selected columns as row entries?

Hope my request makes sense.

Leegirl
 

More replies
Answer Match 75.6%

Hi there,
I'm trying to export data from Word 2007 form fields into an Excel spreadsheet. I was hoping to have the spreadsheet contain data on a cumulative basis for the year or quarter at a minimum. Not sure how the code runs and if this is even possible. Does it scan a folder for all pertinent info to populate the spreadsheet?

Currently we are writing about ten of these docs a day and the data entry is becoming burdensome.
I have attached an example of the spreadsheet for reference.

I can provide specific examples of file paths or folder names if that becomes necessary.

Any assistance is greatly appreciated!

Thanks!
Cameron
 

A:Exporting Word form field data to Excel

Here's the word doc with form fields associated with the spreadsheet.

thanks!
Cameron
 

2 more replies
Answer Match 75.6%

I am trying to make a database based on survey data collected in Microsoft Office Forms.

Each subject has submitted a word document which contains responses to survey questions filled out with Word's Form feature. I would like to automatically populate an Excel spreadsheet with the form fields from a large group (25-50 documents per batch).

I have seen questions similar to this raised in other forum posts, but I seem to be running into problems with the suggested macros. This might be because I am working on a Mac (the only computer at our company) in Microsoft Office 2011. Any suggestions?

Thanks for your help,
Sasha
 

A:Exporting Microsoft Word Form Data to Excel

Hi Sasha
If you are wanting to use VBA to copy / move between Word and Excel you will almost certainly need appropriate boxes ticked under references in the VBA editor for Microsoft Excel XX Object Library.
I've no idea whether the Mac version is set up the same and would imagine you would have a bit of work to do to translate VBA written for windows into a mac variant.
What you might do is consider providing some dummy data and files and seeing what we can do to help.
 

1 more replies
Answer Match 75.6%

Hi Everyone!

I have a form that I created in Word 2003 (see attached). There are a few things that I’d like to accomplish with this form.

1) once the form is completed by the user, I want to be able to export the entered data into an excel spreadsheet (via macro button – submit/export - and VBA for the actual transfer of data?)
2) for 3 of the sections with radio boxes (employment type, rate your experience, and the 1st line of availability (1 shift/wk, 2shift/wk…)) I would like only one selection to be made. So the user can only select one of the options, and not multiple. Actually the Teaching Experience one…I need it so they can select whichever grades they teach, but only one selection of ‘years taught’. They can select any/all the MPMxx but it’s the ‘years’ that is important…

I have a very basic understanding of VBA but I work with excel all the time so I’m relatively comfortable with some things and willing to learn/try new things…

Can someone please point me in the right direction as to how I can accomplish this?

What I envision is the form being completed then sent back to me. I then hit a button embedded in the form that will then export the data to my excel spreadsheet where I can sort, etc…

Any help would be much, much appreciated as I’ve tasked myself with completing this…when maybe perhaps I should have tried to figure out how complicated this might be first…

Thanks for reading!!!
 

A:[VBA] Exporting Word 2003 Form Data to Excel

Files
http://www.mediafire.com/?xxexol8mexwi1ma

Okie, my objective here is to transfer the data from a word .doc into an excel spreadsheet. The form is all bookmarked with proper tags. I have started the VBA code, but I’m at a loss as to why some things aren’t working…


Sub Report1()
Dim path As String
Dim wdApp As Word.Application
Dim wdDoc As String
Dim curDoc As Word.Document
Set wdApp = CreateObject("Word.application")
wdApp.Visible = True
path = "C:\Users\xxxxxx\Documents\APPLICATION FORM\FINAL COPIES"
'Get first document in directory
wdDoc = Dir(path & "\*.doc")
'Loop until we don't have anymore documents in the directory
Do While wdDoc <> ""
'Open the document
Set curDoc = wdApp.Documents.Open(path & "\" & wdDoc)
Range("A1").Select
Selection.End(xlDown).Select

ActiveCell.Offset(0, 1).Value = curDoc.FormFields("DATE").Result
ActiveCell.Offset(0, 2).Value = curDoc.FormFields("FNAME").Result
ActiveCell.Offset(0, 3).Value = curDoc.FormFields("LNAME").Result
ActiveCell.Offset(0, 4).Value = curDoc.FormFields("EMAIL").Result
ActiveCell.Offset(0, 5).Value = curDoc.FormFields("OCT").Result
With ActiveCell.Offset(0, 6).Value
If FieldName = True Then
ActiveCell.Value = "PERMFT"
ElseIf FieldName1 = True Then
ActiveCell.Value = "LTOS"
ElseIf FieldName2 = True Then
ActiveCell.Value = "RET"
ElseIf Fie... Read more

2 more replies
Answer Match 75.18%

Hi, this is my first post on here.

I am looking to create a simple and easy to use quote form so our sales guys can rapidly generate a quote for our customers. Ideally I would like to be able to have the user select a product name/number from a drop down menu and have information from that product filled into the appropriate categories of the form. (For example the price section would be linked to our price book, and would dynamically update if a different product was selected). If possible I would also like to be able to edit those entries as well in case of custom orders etc.

I'm not sure if this would require linking to Excel or what the best way to accomplish this is.

Also because we haveso many products, I was wondering if it was possible to create some kind of a "drill-down" menu system; so that instead of seeing a list of 1000 products there's something like Category 1 -> Subsection 5 -> Poducts (1-54) (I stole the term from NewEgg)

I've looked at office online help and haven't come up with much. Not even sure if this is the right forum, but if anyone has any information, or could point me to a locale where people would, I would GREATLY appreciate it!

Thanks!

Jalex
 

A:Using Advanced Forms in Word (and Excel ?)

Access.
 

3 more replies
Answer Match 75.18%

Hi guys i am a real novice when it comes to excel and i have taken on a task at work that maybe over my head (Job Cuts Looming so have said YES i can do that easily). can anyone help???

I am trying to get an excel and a word form to self generate a URN for a First Aid Report Form and also a Purchase Order Request form i have created both forms but carnt figure out how to get them to assign a new URN after the old form has been submitted, Any help will be greatfully appriciated
 

More replies
Answer Match 74.76%

I have a Microsoft word mail merge with around 11 fields, I wish to export 2 specific fields into an excel spreadsheet, is this possible and how would I go about doing this?
I use Windows 7, Microsoft Word 2007 and Microsoft Excel 2007
Please assume I have very basic skills in relation to these programes, so may need to be spoon fed a lot of the information

Thanks in advance,
Thomas
 

A:Exporting specific field from word mail merge to excel

9 more replies
Answer Match 74.34%

Hi,
I've been searching all kinds of fora for this problem and although I find information on how to do this with (legacy) Form Fields, my problem involves Content Control fields and I can't seem to fix this.
Basically I have Sales Reports that are being filled out on a weekly basis by all Sales Reps. These contains all kinds of different Content Control fields (Drop down, rich text, dates etc...), and the data in there should be copied to an excel sheet. Meaning: copying the contents of the fields from all the different reports into 1 excel report.
Below is a Macro I found which works for legacy forms (FieldForm) (pre-2007) but I cannot seem to make it work for 2010. I pinned down the problem to being just a wording problem in MS, but then again, it might be a little more complicated

Many thanks for your help,
Code:

Dim vField As FormFields
Dim fso As Scripting.FileSystemObject
Dim fsDir As Scripting.Folder
Dim fsFile As Scripting.File
Dim wdApp As Word.Application
Dim myDoc As Word.Document
Dim vColumn As Integer
Dim vLastRow As Integer
Dim x As Integer
Sub AddFormFields()
vLastRow = ActiveSheet.UsedRange.Rows.Count + 1
vColumn = 1
Set fso = New Scripting.FileSystemObject
Set fsDir = fso.GetFolder _
("Q:\Sales Reports\Unprocessed")
Set wdApp = New Word.Application
wdApp.Visible = True
For Each fsFile In fsDir.Files
wdApp.Documents.Open (fsFile)
Set myDoc = wdApp.ActiveDocument
For Each vField In wdApp.Documents(myDoc).FormFields
vField.Select
vV... Read more

A:Exporting data from Content Control Fields in Word to Excel 2010

6 more replies
Answer Match 72.66%

Hi
I'm trying to figure out how to make it so that a very long checklist, which includes checkboxes and text boxes, can be transferred to excel. (I'm working with the Microsoft Office 2007 suite.) I've been reading about how you're supposed to enable the "Save Data as Delimited Text File" in the advanced part section of the 'Tools' Options tab, and then save it as a text file to import into excel, but when I do that it doesn't save any information, just two zeros. I've been looking at other forum questions and messing around with how the forms are protected or not, but I can't get it to actually save any of what's entered in to the forms when I save it as a text file. Any help on this would be very much appreciated.
I've attached a zip folder (I hope) with a section of the checklist in case that might help. Thanks so much!
 

More replies
Answer Match 67.2%

Hi All,

Having some trouble exporting modules from code. Not sure why. Any help would be appreciated. I am getting Run-time error '50012' Method 'Export' of object '_VBComponent' failed. I am using an .xls workbook in Excel 2007.

My code is below, but the export breaks even when I do this:
Code:
strPath = "C:\ReplaceTaxCode"
ActiveWorkbook.VBProject.VBComponents("ToolsA").Export "\" & strPath
Full Code Here:

Code:
Public Sub ReplaceCode()

Dim wkbCode, wkbReplace As Workbook
Dim strPath
Dim VBAEditor As VBIDE.VBE
Dim objProject As VBIDE.VBProject
Dim objComponent As VBIDE.VBComponent

Set wkbCode = ThisWorkbook
Set VBAEditor = Application.VBE
Set objProject = VBAEditor.ActiveVBProject

strPath = "C:\ReplaceTaxCode"

For Each objComponent In objProject.VBComponents
objProject.VBComponents(objComponent.Name).Export "\" & strPath
Next

End Sub

 

A:Solved: Excel VBA Exporting Modules

7 more replies
Answer Match 67.2%

Hi guys

I am using Office 2007 and am unable to find this information else where on the form.

Heres the scenario:

I have 3000 different excel files that I wish to extract data from, possibly using VB. This data will be used to put into a table in Access (however, it may be imported into an excel sheet and copied accross if easier.)

Each Excel file consists of exactly the same template, with different information enclosed in this template. I need a script that will extract the values of certain cells (the same cells everytime) in the sheet and input into the table (or final Excel sheet). This script needs to be able to run on every Excel file within a certain folder.

In addition to this, it needs to grab the last date in a date column and copy this into a single date field at the top of the sheet.

I know this a small request , but in theory if this is possible I would really appreciate someone to help me a little.

Please note, I have no previous experience with VB, only amateur excel formulas.

If there is anything else that would help people understand the issue I will be happy to forward any information.

I dont expect to be spoon fed but I am on a really tight schedule, I hope that the answer can be beneficial to other users.

Rowan
 

A:Solved: Exporting Excel Data

16 more replies
Answer Match 67.2%

I have 2 colums that I need to export from excel into word as comma seperated values. Anyone have any clue how to do it?
 

A:Solved: Exporting data from Excel

You can save the data as a comma seperated file and then open with word and copy and paste into the word document where you want it.
 

2 more replies
Answer Match 66.36%

Can anyone please tell me where I can get a simple set of instructions on how to export several colums of contacts in Excel 2007 into outlook 2007. Thanks Tim
 

A:Solved: Exporting from Excel 2007 to Outlook

16 more replies
Answer Match 65.94%

Hi,

I have created a form in MS Word and have encountered a problem. The form does not hold its structure. I have fields within the form which potentially could expand to multiple pages. At the moment though the field will only expand to a maximum of 1 page and one order to do this it seperates from the original structure of the form. Does anyone know a way around this? I used tables to create the structure of the form.

Regards
Tim
 

A:Solved: MS Word Forms

6 more replies
Answer Match 65.52%

Hi all,

I am creating a form in excel to record two variables, the type and size of a bin, at a range of properties.For each property i visit I will need to record data on multiple bins on a separate row in excel. I am doing this using option buttons and visual basic as I feel this is the easiest way to collect the data while in the field.

My question is this. The form records the data perfectly for a single row, but i cannot work out how to make it start recording data on a different row, for a different property. Ideally I would like the form to start recording data on whatever row I click on, but if it just moves down a single row each time, that is fine as well.

This is the code I have so far come up with:

Private Sub CancelButton1_Click()
Unload Me
End Sub

Private Sub OKButton1_Click()
Sheets("Sheet5").Activate
nextcol = Application.WorksheetFunction.CountA(Range("1:1")) + 1
nextcol = nextcol + 1
'Application.WorksheetFunction.CountA (Range("1:1")) + 1
If OptionRefuse Then Cells(1, nextcol) = "Refuse"
If OptionRecycling1 Then Cells(1, nextcol) = "Mixed Recycling"
If OptionRecycling2 Then Cells(1, nextcol) = "Paper Recycling"
If OptionRecycling3 Then Cells(1, nextcol) = "Glass Recycling"
If OptionRecycling4 Then Cells(1, nextcol) = "Cans Recycling"

If Option80 Then Cells(2, nextcol) = "80L"
If Option160 Then Cells(2, nextcol) = "160L"
If Option280 Then Cells(2... Read more

A:Solved: Forms in Excel

6 more replies
Answer Match 65.1%

Hi there,

I'm creating a document containing form fields in Word 2007.

I want to have drop-downs and so I've added the drop down list control. Viewing the properties, I created options for user's to select from.

There's also two further options in the Properties:

Content control cannot be deleted
Contents cannot be edited

Now, here's the thing...when I Restrict Editing on teh form to Form filling only with the first option selected for the drop-down, users cannot delete the control, they can make a selection from the available options but they can edit the option they have selected (including deleting all the text).

Enabling the second option displays the currently selected item for the drop-down only, i.e. the user cannot select any other option.

Entirely useless. I want to have a list of options that the user can select from but not edit in any way, shape or form.

The only way I've found to get round this is to use the legacy drop down control. I shouldn't have to do this.

FYI, I'm NOT using compatibility mode so it's not that.

Anyone else had this issue?
 

A:Solved: Word 2007 forms

No idea what happened. Restarting Word seemed to help. Thought it was because I had accidentally used a combo box instead of drop down box but I hadn't.

Bizarre.
 

1 more replies
Answer Match 65.1%

Hi, i am noob in excel, i made an excel which fetch data from a stock market site which auto refresh at specific time interval, i want to auto export some specific data of excel in text format to my hard disk, i want to import new refreshed data in same file,document without deleting previous data.In my excel, time and date auto updates.
attached the excel, i want to export the data in range of c33,c34 to i 33,34
 

A:Solved: auto exporting excel data in plain txt format

13 more replies
Answer Match 64.26%

I wish to create an online business application form using Word 2007, whereby I can e-mail an applicant who can then fill in the required boxes, eg. their name, address etc, and return to e-mail back to me.

Can anyone help me please?
 

A:Solved: Creating forms using Word 2007

14 more replies
Answer Match 64.26%

I have a Word 2003 form in which there are currency fields and date fields for the user to fill in. That's all fine, I can format the fields and calculate with the currency field to create properly formated currency fields that I generate.

On the last page I want to copy some of these fields. Currency ones are fine. What I can't do is copy a date field. I set the text field type to "calculation", and the expression to "=arrival" (the field I am trying to copy from is called "arrival"). Now I can't get the format right. If leave the number format field blank, I get a number that isn't anything sensible, and if I copy the date format from the original field into the new one I get nothing at all (it's offering me a number format, not a date format, so I suppose that's not surprising.)

This surely should be easy. What am I missing?
 

A:Solved: Copying dates in Word forms

7 more replies
Answer Match 64.26%

Hi,
My cryptic title means the following.
I have the following pop-up calendar code to fill a particular field in a userform:
Option Explicit
' ===================================================
' Code by Martin Green eMail [email protected]
' Visit my Office Tips web site at www.fontstuff.com
' ===================================================
Private Sub cmdClose_Click()
' Close the UserForm
Unload Me
End Sub
Private Sub UserForm_Initialize()
' Check if active cell contains a date. If 'yes' show
' same date on calendar. If 'no' show today's date.
If IsDate(MedewForm.ActiveControl ) Then
Calendar1.Value = DateValue(MedewForm.ActiveControl )
Else
Calendar1.Value = Date
End If
End Sub
Private Sub Calendar1_Click()
' Transfer date selected on calendar to active cell
' and close UserForm.
MedewForm.ActiveControl = Calendar1.Value
Unload Me
End Sub

I would like to use this form for more than one form.
I imagine I could store the active userform name in a variable and replace MedewForm with this variable and then use it for any number of userforms but:
HOW DO YOU DO IT?

I have tried declaring a public constant but that did not work.
Any suggestions will be appreciated.

 

A:Solved: VBA (Excel) code one userform for more forms

I found the solution.
Remove the userformname, in my case MedewForm, and it works with any form.
Tested it and it works.
 

1 more replies
Answer Match 63.84%

Hi

I am trying to create a form for colleagues to fill in. i am trying to protect the document to restrict people editing the text. but i want them to be able to type in the strengths and weakness text boxes but once i protect the document it wont let me fill in the text for these two boxes. i have a drop down list also but that seems to be working fine. any ideas how i can get this done? i have attached the document its only 1 page

thanks
 

A:Solved: Word - Forms, protect document issue

Hi there,

If you use a table instead of text boxes for the Strengths and Weaknesses section, you will be able to insert a Text Form Field in each box which enables text to be entered when the document is protected (make sure the option to allow 'filling in forms' is selected in the Restrict Formatting and Editing options.)

That's what I do anyway

Hope this helps!

S
 

2 more replies
Answer Match 63.84%

I am having an issue with a document created in Word XP. The doc has a table of contents, with links that jump you to different sections of the document when you click them. The doc also has a number of forms and drop-downs that I'd like to protect. However, my problem is that when I select "Protect...Forms", the links in my table of contents becomes deactivated and can not be used. With the forms unprotected, the links in the table of contents work fine, but I lose all the functionality in the drop-downs (they stop being drop downs!).

Can anyone tell me if there is a way to have the best of both worlds here, and keep the links in my table of contents active while still protecting the forms?
 

A:Solved: Word XP - Protecting forms & keeping links

hi nerdlyman,

caveat: I've never got to the bottom of this and sometimes it seems to work and othertimes not, need to spend time experimenting.

however, you should try these:

1. protect forms via the padlock icon on the FORMS TOOLBAR rather than the TOOLS menu.
2. if 1 doesn't work, then try putting your document into sections (Insert \ Break \ Section Break) and from the menu TOOLS / PROTECT DOCUMENT click FORMS and then also click SECTIONS then untick the section that contains your TOC.

HTH

Hew
 

3 more replies
Answer Match 63.42%

I'm trying to get excel 2003 enter a row of data into a website form so i can submit it and repeat the the process with the next row...

I'm submitting inventory to a website but have the data in an excel spreadsheet, so I'm hoping to avoid manually entering each and every item onto each and every website. Some sites have a bulk upload feature using XML, but this is for the sites that don't...

Is this possible? By using excel's web query feature i can pull data from a site, i guess I'm trying to post it to the form...

Any takers?

Thank you in advance for your time and consideration...
 

A:Solved: Excel 2003 to autofill website forms?

16 more replies
Answer Match 62.16%

The problem that I have is that within a large word doc, I have several repeated phrases, mainly names, so it will say Chris Merchant Chris Merchant ........ I would like to remove one of the repeated phrases if possible without having to just use cut as there are several hundred examples in the same document and they are all different phrases or names. It would be also be good if it was possible to change the font colour of the phrase or name that was left, just for ease of use in the future.

If anyone has any ideas I really appreciate your help in advance

Regards,

Chris
 

A:Solved: Is it possible to delete several different repeated phrases in Word 2007?

16 more replies
Answer Match 60.06%

I just started using Word 2007 and am having some difficulty adjusting to the changes. Unfortunately this is the software I am stuck with and no upgrade to 2010 is possible.

Specifically, I have created a lot of forms in Word 2003 by using text boxes to be filled by the user. I've also used links and references so that the user doesn't have to re-type some of the duplicated information throughout the form.

After creating these forms, I protected the documents and other people within my organization use them as templates. These forms need to be uniform throughout the department.

Several problems. I'm having a hard time familiarizing myself with Forms in Word 2007. Another issue, is that I can't get the Forms Spell Check to work like it did in Word 2003. I want my users to be able to check the protected portion of the document. They also need to be able to unprotect the document if they have to make some changes in the form.

It would be very helpful if there was a Word 2007 guide that explains the differences from word 2003 and offers an interactive training.

I'm desperate. Can you help me?
 

A:Word 2003 Forms being used in Word 2007; And Creating New

http://it.lsue.edu/office2007/word.pdf
 

2 more replies
Answer Match 60.06%

I have several Word 2007 documents containing forms controls that I need to make compatible with Word 2003. When I save the 2007 doc as 2003, the controls become static content. I tried replacing them with legacy controls but can't get them to work. When I insert a drop-down list box, only the first entry in the list displays and there is no drop-down arrow allowing selection of other items in the list. Can you help?
 

More replies
Answer Match 59.22%

I need to export data from an excel spreadsheet to be used by another program. This other program needs to the see the data in a .txt file that is comma delimited ascii. The values (or data in each cell) must have quotes around them to work in this other program, but I cannot figure out how to get quotes around the values when saving into .csv or other comma delimited formats. I only get data separated by commas.

Any help?
 

A:Solved: exporting excel data into comma delimited ascii with "quotes"

6 more replies
Answer Match 59.22%

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10
etc

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you
____________________________
 

A:Solved: Excel macro to extract Word form data into Excel

7 more replies
Answer Match 57.12%

I am trying to export a table from access 2000 to excel 2000 and keep getting an error message
"external table is not in the expected format"
What should I do
 

A:error exporting to excel

How are you trying to export the table? Are you using a macro or are you clicking FILE --> EXPORT?
Rollin
 

2 more replies
Answer Match 57.12%

Hi, a friend of mine has written an Excel worksheet with a Macro using bit of VBscript added in which is used to read in a student's grades and output a final overall grade. We were wondering, that there must be a way to be able to incorporate the script to basically make a web-based version of this....

Can anyone help?
 

More replies
Answer Match 57.12%

I am exporting a report from the web into an excel database. The web report numbers are being pulled in the excel database with Look Up Formulas. The web report data will not pull over using this formula in the excel database. Is this because the web report is being pulled from the Web? If so, is there anyway I could pull the web report data over into my excel database.

Thanks so much,

Tammy
 

A:Excel Question, Exporting from the Web.

A question Tammy - is the web report in Excel format?
 

1 more replies
Answer Match 56.7%

Try as I may, I cannot place a page of text into my scanner and have it transferred to the 'Word 2000' programme for editing.
The copy shows up OK on the word screen, but is not accessible for me to go in and alter the text.
Some of the pages I have tried to import are originally typed up in ''word' and some in 'Publisher'. Neither will allow me to edit and change the text at all. Any help would be more than appreciated.
I have an unknown brand computer so cant give you that info.

Any help our there please? Kind regards, Aileen H.
 

A:'Importing' and 'Exporting .....in 'Word 2000'

Does your scanner have an option for scanning OCR?

Also what file format is the scanner leaving the file in after scanning?
 

3 more replies
Answer Match 56.7%

Hi,

I have to take details from a word document; name address, Date of birth etc, and place it into several letters and forms in other word documents.
It there a way to record a macro or use VBA code to automate this process?

I am using Word 2007.

Thanks
 

A:exporting data to various Word douments??

6 more replies
Answer Match 56.28%

Hi there

I know that it is very easy to copy and paste an Excel worksheet into a notepad. However, my boss wants me to write a macro in Excel that can do that automatically, since we have staff that is not comfortable in using Excel. I tried to record a macro to get me started but that did not work. Any ideas??

Mario
 

A:Exporting an Excel worksheet into Notepad

16 more replies
Answer Match 56.28%

Each time I try and do this it comes up with the error message

An error has occurred in the Microsoft Excel translator while getting the contents of a file system.

The Microsoft Excel file..........has no named ranges. Use Microsoft Excel to name the range of data you want to import.

I do not know how to do this, can someone help?

Thanks.
Miadelcara
 

A:exporting excel to outlook contacts

6 more replies
Answer Match 56.28%

Hi i have worked up a quote for a potential client in microsoft excel. I want to make it to where he can open it in word or a similar program without any problems. When i tried to open it in word it said i needed to install something. Is there anyway to bypass this so it can be opened with ease? Also i want to make it to where he cannot modify it at all. any ideas????
thanks
 

A:locking and exporting excel files

Without the converter, no you can not easily open up an excel document in word. The formatting is different - unless you want to write up some code to create a word document from excel...I think your client may have to use Excel. You can protect your workbook from being modified - go to Tools -> Protection. You can set up the workbook to have a password to save changes. If you look up the term 'protection' in Excel's Help you'll be able to find details on how to do what you want to do.
 

3 more replies
Answer Match 56.28%

Hey OBP if you're around, I have a situation. I have a company that it would be easier to manipulate their data via spreadsheet than creating a report. Is there an easy and fast way to send their assets to a spreadsheet?
 

A:Exporting part of database to excel

8 more replies
Answer Match 56.28%

I have two alerts for Sensitive Account Credentials Exposed, "Credentials were exposed in cleartext using LDAP simple bind.  He of these alerts are showing as being from several source machines using several different user accounts.  When
the alerts first started the console would should the first date detected 1/10 and the last date detected 1/23.  If I would export the data to Excel I would see all of the detected events 1/10 - 1/23.  I fixed all the problems and marked the events
as Resolved.  
Several days later the events showed back in the ATA console as detected and the date range was up to the current date 2/3.  However if I export this data to Excel the last date displayed is 1/23.  I see a new user on the Exposed tab, but on the
Network Activities tab I do not the new date, only up to 1/23.  I have 10001 rows on the Network Activities tab.

More replies
Answer Match 56.28%

Hi, as you can see from the title i want to export all the data in my access table to an excel spreadsheet. How do i go about this?

Any help will be appreciated.

Thank you.
 

A:Exporting an Access table to Excel

16 more replies
Answer Match 56.28%

How do i export a public contact list into excel. I can export the private contacts with no problem but there is no choice for the public folder nor does it give you a browse option. If there is a way to fix this or get around it please let me know
 

A:exporting contacts outlook xp to excel xp

As I recall...

You must first download the global address list to your PC. Do this (somehow) through Tools-Services and choose something like "make available offline" or something like that.
 

3 more replies
Answer Match 56.28%

Hi,

Recently, I'm having slow file loading while opening ms word files and excel files directly from windows explorer. It takes a minute to load, however it opens immediately if I open .doc files or .xls files directly from their application software. It also take a minute for MS Word and Excel software to shut down.

I have run my antivirus (Symantec) and MBAM but they all show no virus was found. I'm not sure what should I do next, please advice.

A:Microsoft Word & Excel - problem with opening files in Word and Excel

What version of Word & Excel?

6 more replies
Answer Match 55.86%

I have a word doc full of forms. I export only the form values to a .txt and it puts it all on one long line. In the actual word doc, I have a page break at the bottom of every page. It comes out to 1 page break every 20 form values (20 form values per page).

Is there a way to preserve these page breaks in a .txt so it would display just 20 values per line instead of all values on one line?

Thanks
 

A:Exporting word doc to .txt while preserving page breaks?

How exactly are you exporting the values?

Rollin
 

3 more replies
Answer Match 55.86%

Hi all,
I am wondering how to overcome the problem of Excel chopping off data.Is there a way to set a large limit or possibly keep the record length unlimited.This data is the results retreived from Access queries. The data after querying is exported to the Excel sheet via the following do command:

DoCmd.OutputTo acQuery, "queryName", "MicrosoftExcel(*.xls)", "Report" & ".xls", False, ""
Thanx
 

A:Exporting from Access to Excel-length limits?

If you are trying to put the entire string as one line it will never work. I believe the charachter length is 255. You can however create a new cell in Excel for each record like a line break.
 

3 more replies
Answer Match 55.86%

Hello!

I'm in a bit of a pickle. There is a form at my work that our clients fill out to request access to a meeting room. There is another form that I myself have to fill out after the client has used the space as a "report" of what happend in case there are any problems. The information from the first form needs to be exported and populated onto the second form. The second form has some extra fields on it for myself to fill in as the report side of it.

I have Excel and Access.

They are basically both the same form, just the field locations have changed and there are some extra fields at the bottom for myself to fill in.

What would be the best way of doing this?

Thanks in advance for any help receieved!
 

A:Exporting certain feilds from 1 Excel Workbook and importing into Another

I think that the easiest way to do this would be to import the other worksheet into excel. And then either link the worksheets together and bring the information that you need or if you need it to find things based on some other criteria then you use a vlookup to pull in the information that you need.
 

2 more replies
Answer Match 55.86%

When I Export from Access to Excel..to a External file then when I chose the "Save as file type"..Excel is no longer an option..and there's a Message "Not all file types are installed..& to re-install office 97..click Add/Remove Data Access, Change Option..

If you un click the rest & just leave Data Access..that will mean uninstall everything & install Access only..So I just installed everything..

Still...the same..any suggestions...is there something wrong with my OS
 

A:{Resolved} Trouble Exporting From Access To Excel

8 more replies
Answer Match 55.86%

Hi all,

I have Windows 7 Professional and am using IE9. There's a website we use at work that needs data exported to excel. It works on my co-workers older computer but not from mine. I've attached the screen shots. When I right click on the screen, it gives me an option to export to excel. When I do, It gives me the screen that's says I'm not connected to the internet, which I am or I wouldn't have been able to go to the website in the first place. Anyone know of a fix? I tried downloading IE8 but it says it's not compatible. Any help would be great.

Thanks.

A:Trouble exporting data to excel from website via IE9

Use the browser window that pops up from excel (the dialogue that says you're not connected to the internet) to navigate to the webpage with the data you want to import. There will be yellow arrows to click on for the data you want.

Why it's done this way doesn't make sense but it should work.

1 more replies
Answer Match 55.86%

I recently upgraded QuickBooks. I had Basic 2004, Now have Pro 2005. When I go to Export a report to Excel (2003) the dialog box appears, but I only have the first choice "a comma separated values (.csv) file" selected.

The rest of the Basic Tab & all of the Advanced Tab is grayed out. I have no idea how to fix this.

QuickBooks won't tell me unless I sign up for their "Tech" support package. Rip-off!!!!

Can someone please help me??????

Thank you!!!!!
 

More replies
Answer Match 55.86%

Can someone please tell me how to import tables from a web page into Excel 2000. I understand that a web query can be created, but when I attempt to reference the web page, the query won't run because the web page requires user authentication prior to access. Help!
 

A:RE: Exporting Web Page Tables into Excel 2000

You could possibly save the table and open it in word and copy it (Ctrl + C) and then go to Edit --> Paste Special in Excel and it should work. Or you could just copy it from the website and used the Paste Special in Excel.
 

1 more replies
Answer Match 55.86%

I am a delegate of someones calendar and would like to export the contents into Excel. when I got to Import / Export im only seeing my local calendar in the list but not the shared. Can someone tell me how to export? thanks
 

A:Exporting a Shared Calendar into Excel using Outlook 2K3

ttt
 

1 more replies
Answer Match 55.44%

Help!!!! I have created a form in Word 97. It basically lists the information I need and there is a text box to the side for the response to the question. All I need to know is how do I fix this form so the end user can put a response in the text box and tab to the next box. I feel like an idiot, I can not figure out how this works. I could do it in excel however this is for work and has to be in Word. Any help would be greatly appreciated!!!!!!!!!!!!
 

A:Forms In Word 97

I believe all you need to do is just "protect" the form. Click the padlock on your Form toolbar. Then you can tab from field to field.

Works for me but I'm sure Dreamboat or someone else will respond if this is not correct.

------------------
Get paid to listen to music online!
http://www.radiofreecash.com
 

2 more replies
Answer Match 55.44%

I need help with Microsoft Word 2003. I am working with form fields. When I type in a form field it moves my formatting around on the same line dropping it to the next line. I tried right click to make adjustments to the form field, with no avail, I have tried double clicking in the form field with no avail.

I know I am missing something, hopefully somebody here can help. Thanks in advance.

Please see attached screen shots of Right and Double Click form fields.
 

A:Word (Forms)

7 more replies
Answer Match 55.44%

Hi Guys..

I am working on a project which has a requirement of
creating forms which has certain areas that user can
edit.
Now,
I am using word XP. Can I create certain lockable areas
in the form? Is compatibility an issues with different
word versions?
My main concern is that the forms are going on web and
are to be downloaded by the user? Can we still maintain
the control? If not, what are my options?

Please guide. Any help would be appreciated

Cheers!!
 

A:Word Forms

8 more replies
Answer Match 55.44%

I am trying to set up a from in Word. The goal is to have drop-down boxes and other web components so people can enter info. It is basically a form to request stuff from other people in the company.

I am trying to find a way to have the info from the form be emailed to someone when they click the submit button. I have a test form set up with everything I need, and then when I click the submit button I get the new email message but nothing appears in the body.

I know I am missing something, I just can't figure it out.

Thanks
 

A:Forms in Word

9 more replies
Answer Match 55.44%

Customer has a word doc, when they open it the fields appear
to be displaying a form with terms like #fieldtext# and #checkbox#
When she prints it the correct values are printed.

Is there a method to view it as it would print ?

I assume this doc is the output from a form ?
 

A:Word Forms ??

Perhaps hitting Alt-F9 will work?
 

1 more replies
Answer Match 55.44%

I made a form in word 2000. Everything worked great but if you push the "entry" key instead of the "tab" key it moves everything in the form down. Does anybody know how to disable the entry key or make it think it's the tab key?
 

A:Forms in MS Word

If it's even possible, it'll require VBA, which gives a macro virus warning on open, and they may just disable the macros anyway.

Actually, as I recall, it's not possible.
 

1 more replies
Answer Match 55.44%

Hello...

I am trying to create a form that people fill in and then the data is transferred into a new document created from a template. The Form now opens when the template is open (thank you XL Guru) but I cannot seem to get the data to transfer...

I have created a 'textform field option' in a cell in word which I have called 'Price' in the 'Bookmark:' section.

I have then entered the following code into the userform module (my user form is called userform1):

Private Sub btnUserOK_Click()

End Sub

Private Sub TextBoxPrice_Change()
vprice = UserForm1.TextBoxPrice.Text
ActiveDocument.FormFields("bkprice").Result = vprice
End Sub

I am quite new to all this so you will have to excuse my ignorance if this is complete garbage...

Do I have to enter the code into the 'Userform1 module' or the 'thisdocument' module.

I then have an OK button which I want to click and the data then be entered into the appropriate 'textform field option'

Any help will be greatly appreciated..

Thank you
 

A:Forms and Word

Word VBA is NOT my thing (dunno where Annie is lately).

Whatever button (AKA control) on the form you want to "do stuff", rightclick it & "View Code" and shove it in there.

eg:

Private Sub CommandButton1_Click()
vprice = UserForm1.TextBoxPrice.Text
ActiveDocument.FormFields("bkprice").Result = vprice
UserForm1.Hide
End Sub

HTH,
Andy
 

3 more replies
Answer Match 55.44%

Guys and Girls,

I have a program I made within excel using some complex vb. What happens is I have a button click bring up a form I made and it performs some functions. When that form is up, I can no longer look back at the excel document. The excel document is still there, I can see it, but I cant make it active while the form is open.

Any ideas for this one?

Thanks,
ASM
 

A:forms in vb/excel

Use access?
I am just kidding, there is probably an answer. But its seems for what you are doing access would benefit you.
 

2 more replies
Answer Match 55.44%

Hi,

I am experiencing a dramatic image quality loss when exporting to PDF from Word 2013. I have set my options (options > advanced > do not compress images in file) and gone to save as > tools > compress pictures to alter the target output, yet it continues to happen, even with new documents.

Is there anything I can do to maintain the image quality? I appreciate any help that you can provide!
 

A:Word 2013 - Image Quality Loss When Exporting as PDF

I don't like posting links but this is a good one with a lot of detail.
http://wordtopdfimage.blogspot.com/2012/02/preserve-image-quality-when-saving-from.html
 

2 more replies
Answer Match 55.02%

i am facing problems while updating the records from Excel File.the excel file contains all values.but when tried to bs a source it is generating errors as nulls
 

More replies
Answer Match 55.02%

I am using MS XP Home Edition as OS and MS Office 2000.

I want to export the email IDs along with message content from all messages in a folder in MS Outlook to an excel sheet.

The option on 'Export' to an excel sheet is not working and requires installation from Office CD (which i tried but it fails to identify the Data1.msi file therein).

Is there any other way I can export the content using some other route or a freely downloadable utility.

I need to urgently export the mails as i need the message sender's ID and the message content as data.
 

More replies
Answer Match 55.02%

Need to setup a process of importing vendor/company/bills using Excel and files in the IIF format to bring data into Quickbooks and then take that over to my Wachovia Online Account to cut checks. Anyone have experience using QB and the importing and exporting back from online banking thru to QB and then back to my back office?
 

A:Quickbooks importing and exporting Excel and IIF format files

It's been a long time since I've done this, but I believe the last time I did importing into QB, I found the best way was to Export a file first to give me a template to work with.

Just thought I'd mention it to give you an idea.
 

1 more replies
Answer Match 55.02%

I have MS Word forms that are filled out and saved. On all my machines (XP with Office 2000) all is well. We open the forms, all the check boxes and fields are seen and can be edited.
On one machine, also XP with Office 2000 all the forms formatting are not there. The forms tool bar is there, but protecting or un protecting the form does nothing. The text is there, but the fields and check boxes are missing.

Taking the exact same form to another machine yields the correct formatting.
It seems obvious that the copy of Word on my "bad machine" is missing some function.

Can anyone tell me what the problem is and how to fix it.
Thanks
 

A:Forms in word 2000

A bit of an update.

I downloaded from an on-line backup service we use a word document that has formatting. (Same file as opened on the host computer that is having problems.)

The newly downloaded file opened with the forms function intact!
It is not Microsoft Word!

The next most likely suspect is that I initially put the documents into the offending computer from a pocket PC. I set up a partnership between two computers and the pocket PC. The sync appeared to be successful but it seems that it may have stripped the formating.

I don't know if this is the correct forum to keep this post going.

Any help would be appreciated.

I am thinking of transferring the word documents into the second computer by a physical transfer such as using a flashdrive first. Then establishing a partnership?
Any ideas are welcome.

Thanks
 

1 more replies
Answer Match 55.02%

Hello, I am using word 2007 and have created a document which includes some form fields (a date field and several check boxes). The form works fine for me after turning on protection. When I email it to my coworker though, the form does not work for her (she also has 2007) and it won't let her turn on protection so that the form fields will work. Can anyone offer any suggestions on how to correct this problem?

Many thanks!
 

A:Word 2007 Forms

Welcome to the forum. Can you please zip and post the file as an attachment to see what is happening? How are you protecting it?
 

1 more replies
Answer Match 55.02%

I have a form which my customers use to request samples from me but when it comes through, the info order is mixed up (not garbled -- just not in the order of the original format). I contacted my server because I thought it might be a CGI conflict. They suggested I rewrite it through Word so that it was compatible with Microsoft Outlook which is my e-mail system. It didn't work!! Why is this happening? Does anyone have any suggestions?
 

A:Word Forms Formatting

You know, I can think of a million questions to ask you, but I think it would just be easier to ask you to email me a copy of your form. Send to [email protected] I'm very good with forms so I don't think you'll be wasting your time.

Off the top of my head it sounds like you are not protecting your form, or the users are unprotecting it.
 

3 more replies
Answer Match 55.02%

Hi guys,

Could someone please give me a hand with a little project I'm working on.
This is a little complicated, I hope you understand what I am trying to say

In MS WORD, I am currently able to make drop down forms.

Is it possible that if I were to have multiple drop down forms; I could use the first form menu to define what is listed in the other form menu's.

E.g. [Drop-down form 1] has 3 catogorys in its lists;
- Menu 1
- Menu 2
- Menu 3

When Menu 1 is selected from [Drop-down form 1], [Drop-down form 2] menu changes to whatever list I pre-define for menu 1. However if Menu 2 were seleceted, then [Drop-down form 2] will display Menu 2's list accordingly. Etc

Is this possible? I've seen it used many times before on website forms, but can I do the same in word?

If the above is possible... to take things one step further.. Can I do the same with the 2nd drop-down form; (any option that I select from it) to predefine choices for for a 3rd drop down menu?

Sorry if this is confusing, if there is any part you want me to clarify I'll be happy to do so.

Thanks for your help in advance.
 

A:Help with MS Word DROPDOWN forms

9 more replies
Answer Match 55.02%

I am attempting to create a letter template that contains a form for the operator to select various options. After the form has been populated and the okay button pressed, there are a number of message boxes to be completed before the letter can be finished.

I am trying to get the form to disappear from the screen whilst the message boxes are completed by the operator but have been unable to make this happen. I’ve tried using ‘hide’ and ‘unload’ in the code but it’s still there when the message boxes are displayed.

Any ideas how I can lose the form once I have finished with it?

It's works PC and we only have Office '97 - state of the ark!!
 

More replies
Answer Match 55.02%

I've searched high and low, yet I cannot find the answer to my question.

Basically what I'm trying to do is make a customer-editable lease contract document for a customer of mine. I know the basics of Word forms, and I've entered the various fields (ie. Lessee's Name, Address, Phone, etc), and there are a couple of redundancies in information (specifically names of Lessee and Co-Lessee, so text). Instead of making the lessee type out the same info twice, I thought that I'd set it up so that if they enter their name at the top, it would be entered at the bottom in the same field automatically. I can get this behaviour to work time and time again with numbers (quite simple really), but is this at all possible with text? No matter what I've tried, I can't get it to work, and I've tried everything except ask someone. I'm a reasonably logical and intelligent guy, but I'm at wit's end here with this one.

Thanks,
Cam
 

A:Word XP Forms question

10 more replies
Answer Match 55.02%

I'm stuck on these 3 things:

1)How to keep the autotext "document name" updated in a form/template (as the form is saved to a new name this doesn't change).

2)Is there anyway to get a TOC to work in a form/template? Clicking on a TOC entry in a template does nothing, but it's suppose to take you to that point in the document. I guess it needs to autoupdate some how?

3)Is there anyway to add row to a Table in a Form? In a typicaly table, if you Tab to the end of the Row, a new Row appears below. But this doesn't work in a Form/Template.

Thanks very much!
 

More replies
Answer Match 55.02%

Hi, I am creating a form in Word 2003 (Running over Window XP Professional). I have inserted a field called Sdate and on the next line Firstname. When I reference the field Firstname in other parts of the document, it also includes the field Sdate.
So my result looks like this:
Dear Sdate
Firstname
instead of
Dear Firstname

I am having no problems with referencing other fields, only these two. I have removed the date field and put it back in and still the same result.

Hope this makes sense and hope you can help.

Lotsacats
 

A:MS Word 2003 Forms

Hi lotsacats,

Are you using Bookmarks as Field References?
Maybe the Ref for Firstname also spans the previous line including Sdate:

In Tools /Options/View tick the Bookmarks box and then check if the square brackets [ ] are like this:

[Sdate
Firstname]

If so, delete the bookmark for Firstname and recreate it ensuring it only covers the Firstname line.

HTH
Hew
 

1 more replies
Answer Match 55.02%

Hey there I really have got a real probalem, I am using excel for my A level ICT project and am having a problem with data form as said above!

What I want to do is open up the data form with a macro button but when ever I comes up with the run time error in the first box, so I debug and I can't find anythin wrong with the code, can any of u guys or ladies help?
 

A:Excel and data forms

What's the error you're getting? Is the correct sheet active when you run the macro?
 

1 more replies
Answer Match 54.6%

I am using Word 2002 at work to create a handbook full of pictures and text. On one of my handbooks, Word keeps repaginating up to 50,000 pages (or more!) and then erases all of my formatting. I have tried to copy/paste, except the last paragraph mark, into a new document. No luck. I ended up exporting it as a PDF, and I just hope no one ever has to edit it.

Now, on another document, Word adds random spaces, empty pages, or even deletes spaces and crowds all my words and pictures together.

Everything will be formatted beautifully. Then, I will save the document and reopen it. Upon reopening, the formatting is ruined and I have to go through the ENTIRE document to fix it. Word ignores my page breaks, section breaks...

I have saved the documents to our servers and have opened them on other computers with Word 2002. Sometimes, they look perfect while the original document looks destroyed. Other times, both computers show destroyed documents.

What can I do? My deadline is tomorrow and I can't afford to call Microsoft for Tech Support. I work in IT, so I feel pretty stupid because I don't know what to do about this. Every time I save the document, I'm taking a huge risk. HELP!
 

A:Word 2002 reformats all of my documents during printing, saving, and exporting...

I've seen exactly what you're talking about happen in MS Word. It seems once it starts screwing stuff up there is no end to it. Then It works perfectly for another person. Large compilations seem to do better split up into chapters or whatever...

I'm just wasting your time offering condolances but...nobody expects perfect documents from IT!!
 

2 more replies
Answer Match 54.6%

Hi folks, not sure if this is possible or not but I'll try to explain what I'd like to do.

On the first sheet, I have a simple sheet to be filled in daily. The date is changed, and then daily pick figures and hours picked are updated by the relevant department.

I then have to manually put all of the data into the second sheet, which acts as a log of previous pick figures.

Is there a way the second sheet can automatically be filled in when the date is changed and new figures are put into sheet 1?

I hope I've explained this well enough, I'm trying to teach myself excel as I'm going along! Thanks.

Edit - I've had to delete peoples names' for obvious reasons, initials in sheet 2 will correspond to people in sheet 1.
 

More replies
Answer Match 54.18%

I have a UserForm which contains about 20 products which when selected are
output to the appropriate place in a Word document.

Is it possible to save the UserForm to a central point so it can be accessed
by several different letters? At the moment each letter template I produce
has its own copy of the UserForm, so if one of the available products
changes, I have to go into each template in turn and apply the change.

It would cut down editing time considerably if I only had to make the
amendment once.

Only have Word 97 at work
 

A:Microsoft Word - User Forms

6 more replies
Answer Match 54.18%

Hi there

Last year I created an Appraisal form that we use at work for about 500 people. It's a Word protected form with form fields set in a number of seperate tables

For this year, I need to add a function that allows a user to open up last year's form, copy one table from it and paste the data into a different table in another copy of the same form

The table with the data in it is 4 columns wide but may have any number of rows in it. Row 2 onwards needs to be copied across

The table for the data to be pasted into is 6 columns wide and may not have enough rows to accommodate the pasted data so would need some sort of error trapping to pick up that it needs extra rows adding before pasting.

Data should be pasted into row 2 onwards and should sit within the first 4 columns of the receiving table. The idea is then the user fills in column 5 and 6 adding comments about the data they have pasted in

If any extra cells are needed to fit the incoming data they should have form fields in columns 5 and 6 too for entering the comments above

Phew...hope this makes sense

My experience of this kind of thing is limited to modifying other people's VB code/macros to add some functionality myself. This is a bit beyond me!
 

More replies
Answer Match 54.18%

I'm creating a questionnaire form with almost all text boxes. The problem is that the people that fill out the form sometimes hit enter instead of tab resulting in unsightly new lines below the text box. Is there a way to disable multi-lines?
 

A:Word 2000 Forms Problem

Well, you can double-click an unprotected text form field and give it an exact number of characters to allow. Sometimes, that won't work well, so what I do is put most of my form into a table (anyway), and put this specific field into a one-cell row, and then I set the height of the row to EXACTLY 14 or 16 points or whatever you like. That way, they can hit enter all they like, but it'll never show...

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

3 more replies
Answer Match 54.18%

I sure hope i can get a computer guru to help me. My computers at work have just been upgraded at work to xp and some of the excellent programs now do not work. any way stop rambling.

I made some forms on Microsoft Access 2000 and wish to link the information that is being imputed onto pre made word templates.

the forms look aoutstanding a masterpiece in engeneering however i cant the life of me workk out how to when i click ok the information is transferred onto the templates, like a mail merge sort of thing.

Please help

Taipan
 

A:linking my forms into templates on word

Why not just output the report? You can also make any report output to RTF but that may mess up any formatting. I don't think you can output to a template other than an HTML one.
 

1 more replies
Answer Match 54.18%

i am making a 50-page document with lots of forms in it. i made a nice little table of contents that links to each page to make navigation easy (and "back to table of contents" on each page), BUT when i lock the forms i lose the ability to click on links! i noticed that the scroll-by-whole-page is disabled as well. i went to dreamboat's word page and learned a few new things about forms, but didn't see this particular problem addressed. can anybody help me?
thanks,
melias
 

A:word 2000 forms and links

6 more replies
Answer Match 54.18%

I've created a form in Word that users fillout and print and save. Is there a way to make certain fields required?
I need it to be compatable with Word 2007 and 2002
 

More replies
Answer Match 54.18%

I have a problem! I made a form field in Word and placed a second form field right after the first field. When I started to fill the first field the second just moves closer to the right side of the page. How can I keep the fields form moving. I locked the form fields but that makes no difference. Thanks for your help.
 

A:Making forms in Word 2003

16 more replies
Answer Match 54.18%

I've tried and tried and have tried reading various help manuals. I am trying to create a fill in form using Word. It is for my husband's small business. Thank you!
 

A:Word: How to Create Fill-in Forms

Originally posted by ruhler1
I've tried and tried and have tried reading various help manuals. I am trying to create a fill in form using Word. It is for my husband's small business. Thank you! Click to expand...

I could possibly help ... but, what exactly do you mean by fill-in form. I want to be sure that we're thinking of the same thing. I could possibly know how to help. Feel free to email me! Or post your reply.

Thanks!

- Isabel
 

3 more replies
Answer Match 54.18%

Hi

I am trying to enable spellchecking in a protected word document containing forms. I am at the stage where i know that a macro is necessary to do this. I have tried a macro which i downloaded but when i try to compile it i am getting an error.

Does anyone have a macro that works or an alternative solution to this? Also i would like to extend this as far as being able to edit(bold, italicise etc) text within the protected form as well but the former question is definitely priority!

Thanks for your help!
 

A:Spellchecking protected forms in word

12 more replies
Answer Match 54.18%

I was wondering if anyone knew a way to have the "save data only for forms" option always active.

At the moment if you activate it and then close word it becomes inactive again.

Thanks in advance.
 

More replies
Answer Match 54.18%

When making forms in Microsoft Word (2003), is there any way to enable spell check for the areas that users can input data while still keeping the form protected?

Any assistance would be greatly appreciated.

Thanks,

SED
 

A:Using Spell Check in Word Forms

Here you go, SED.
http://vbaexpress.com/kb/getarticle.php?kb_id=388
 

1 more replies
Answer Match 54.18%

Hi all,

I am writing a VBA program that will read a table of names in Excel, search an html form and display in Excel the returned form data.

How do i link from VBA to the form and read back the data in a VBA friendly manner? Is this possible?

any questions just ask if i am not clear above.

* the form is on www.tuftslife.com: the name directory

Thanks in advance
 

More replies
Answer Match 53.76%

Here's what I need... - to be able to type information in on forms - save it - email it - allow people to fill in the form- save it- email it...I recently converted a bunch of pdf files we've been using to forms. That way people could fill them out before they print them. I should have asked for more detail because now people want to be able to save and email those forms. The only problem with that is that you can only save and email those forms if you have acrobat.So, I'm looking at converting a bunch of pdfs and pdf forms into MS Word forms. I can't imagine how much time it will take me to do some of the more complicated forms even with copy/paste.Has anyone had a similar problem before? Do you know of any tools that would make the conversion quicker? Do you have any links to tutorials on MS Word Forms?Do you know of any other way to accomplish those goals other than a form in MS Word?Thanks

A:Quickly Converting Pdfs To Ms Word Forms

link

2 more replies
Answer Match 53.76%

Folks,

I want to create one Attendance Form wherein employee will fill the same and send.

Also, If we can solve this in Word Form or Outlook Form or Access Form. Post the same with the help of Macro we would consolidate the leave.

Form Example :

Employee Name :
Employee ID :
Direct Manager Name :
Direct Manager ID :
Business :
Function :
Type of Leave : Sick Leave, Casual Leave, Maternity Leave, Sabbatical Leave, Long Leave.
From / Start Date : Employee would be able to select Calendar
To / End Date : Employee would be able to select Calendar
Remarks :
Would appreciate your prompt action / views on the same.
Rahul Gandhi
+91-97-11-772297
 

A:Help Required in Forms : Outlook / Word / Access

I think you need to be more precise about how this "Form" is supposed to work.
 

3 more replies