[mso] Re: Excel Web Form Wizard Missing?

I guess I'm missing something, but if you are going to be putting it all
into Access anyway, why use Excel at all?  Why not just use Access and let
Access make the web form and put it directly into the table? Since it's a
web form, it doesn't matter what software is installed on the remote users'
computers.  Why put Excel in the middle in the first place?


Linda F. Johnson
Linda's Computer Stop
Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
http://personal-computer-tutor.com

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Cathy.Evans@xxxxxxxxx
Sent: Friday, May 26, 2006 3:13 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel Web Form Wizard Missing?

Thanks.  Hmm, maybe the instructions are out of date?  I'm using 2002.
Maybe I need to keep looking.  I really wanted to just make a form but my
form field edit box is greyed out and I didn't want to put vb form controls
in there.

My goal is to have a solid form they can only enter data in one format, and
not add rows, etc., as I'm going to simply be importing that data into an
access table.  Remote users from all over will be completing the Excel
form, and I'm creating an automatic import that will just grab the data
each time a new form comes in, and append it to the access table.  So
consistency was the key of what I was going for.  I was looking at the web
form option because my form edit field being greyed out.

Maybe it's just handled differently in Excel, I'm used to Word form fields
and access.  Is it all handled in Excel through setting protections on
cells?

Will switch directions, then, thanks.



*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: