#1   Report Post  
Posted to microsoft.public.word.tables
motocrossed
 
Posts: n/a
Default data entry

ok, probably could also be posted in one of the visual basic groups
but, I will start here. I have a very large Word table I use to track
projects, 4 simple columns (great responses here for color codeing and
adding new rows). I prefer not to keep the document open all day and
would like to create a very simple visual basic form that I could use
to update the table, the VB form would stay on my desktop. While
creating the form is not and issue, the VB code to update the table is
beyond my capabilities.

Thanks

  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP
 
Posts: n/a
Default data entry

Dim mdoc as Document
Dim mtable as Table
Set mdoc = Documents.Open("path\filenameoftablecontainingdocu mnet
Set mtable = mdoc.Tables(1)
With mtable
.Rows.Add
.Cell(mtable.Rows.Count, 1).Range.InsertBefore "Dataforfirstcolumn"
.Cell(mtable.Rows.Count, 2).Range.InsertBefore "Dataforsecondcolumn"
'etc'
End with
mdoc.Save
mdoc.Close

--
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

"motocrossed" wrote in message
oups.com...
ok, probably could also be posted in one of the visual basic groups
but, I will start here. I have a very large Word table I use to track
projects, 4 simple columns (great responses here for color codeing and
adding new rows). I prefer not to keep the document open all day and
would like to create a very simple visual basic form that I could use
to update the table, the VB form would stay on my desktop. While
creating the form is not and issue, the VB code to update the table is
beyond my capabilities.

Thanks



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I setup a data entry form in Word? [email protected] Microsoft Word Help 2 January 12th 06 02:56 PM
Add an option to require data entry for a form field Reedo Microsoft Word Help 0 November 29th 05 08:22 PM
how do I put a data entry page on front of a document Joe Kelly Microsoft Word Help 1 September 21st 05 09:27 AM
How to add a button to Unsave data entry form elillis New Users 2 August 3rd 05 01:04 PM


All times are GMT +1. The time now is 08:24 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"