PC Review


Reply
Thread Tools Rate Thread

Converting data from a form to an excel worksheet

 
 
=?Utf-8?B?VGVyZXNhIE5ldmVz?=
Guest
Posts: n/a
 
      19th Sep 2006

I design a form to control the quality of services in our IT department.

Can I convert the data inside the form to, for example, a excel worksheet?
 
Reply With Quote
 
 
 
 
Doug Robbins - Word MVP
Guest
Posts: n/a
 
      19th Sep 2006
See the last of this series of articles (starting at the first if you need
to)

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Teresa Neves" <Teresa (E-Mail Removed)> wrote in message
news:87EB86A9-AFC6-47BC-816F-(E-Mail Removed)...
>
> I design a form to control the quality of services in our IT department.
>
> Can I convert the data inside the form to, for example, a excel worksheet?



 
Reply With Quote
 
CyberTaz
Guest
Posts: n/a
 
      19th Sep 2006
Tools>Options - Save, check the box to save Data Only For Forms (which is a
document-specific setting). When you save you will get a typical Save As
dialog where you can use the Save As Type: list to pick a file format. You
won't find Excel in the list as Word can't save in that format, but a txt
file (among others) can be used by Excel.
--
HTH |:>)
Bob Jones
[MVP] Office:Mac

"Teresa Neves" <Teresa (E-Mail Removed)> wrote in message
news:87EB86A9-AFC6-47BC-816F-(E-Mail Removed)...
>
> I design a form to control the quality of services in our IT department.
>
> Can I convert the data inside the form to, for example, a excel worksheet?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CONVERTING MS WORD FORMATTED DATA INTO EXCEL WORKSHEET NSNR Microsoft Excel Misc 3 12th Mar 2009 09:54 PM
How do I save worksheet form data into a table in Excel 2003? =?Utf-8?B?Qm9iIFMu?= Microsoft Excel Misc 0 31st Dec 2005 04:33 PM
How to..use worksheet form and save data to an Excel list =?Utf-8?B?SmFu?= Microsoft Excel Misc 2 10th Jun 2005 04:45 AM
Converting Lotus 123 macro to Excel - copy/move data to worksheet Bernice Microsoft Excel Programming 7 12th Feb 2004 03:47 PM
add data from form to Excel Worksheet Ravi Verma Microsoft Outlook Form Programming 0 24th Jul 2003 07:08 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:33 AM.