Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Writing from an excel user form on one spreadsheet write to anothe

Hello,

I'm attempt to have users write on an Excel User form and when they hit a
submit button, it needs to write to another Excel file on a share drive. Is
this feasible? Im not sure if I even know where to begin on this one.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default Writing from an excel user form on one spreadsheet write to anothe

hi
from your post, i am suspecting that you are trying to use excel as a
database. whereas some individuels have had some success at this, this is not
what excel was disigned for. my advise is to close excel, open access, import
your data into access then click on the forms wizzard. Post your next
question in access.
I think you will find this approch far more efficent.
Regards
FSt1

"mattieflo" wrote:

Hello,

I'm attempt to have users write on an Excel User form and when they hit a
submit button, it needs to write to another Excel file on a share drive. Is
this feasible? Im not sure if I even know where to begin on this one.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Write record from Form to new row in spreadsheet Tony Excel Discussion (Misc queries) 0 March 18th 10 07:35 PM
Write record from Form to new row in spreadsheet Tony Excel Discussion (Misc queries) 1 March 18th 10 02:43 PM
Writing data table to user form Mitch Excel Programming 1 May 10th 05 05:19 PM
Write in the spreadsheet having a form open lidmat Excel Programming 3 November 22nd 04 05:36 PM
PASSING DATA FROM USER FORM TO EXCEL SPREADSHEET No Name Excel Programming 12 January 7th 04 01:36 PM


All times are GMT +1. The time now is 01:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"