Post userform data to workbooks on A Network

[simora]

I am trying to post userform data to multiple workbooks, but the 2nd workbook is on a network server. p:\NetServer\MyDir\my2009Files\PostData2009\mydec.xls

How do I post the same data to the network workbook (Sheet1) which is mydec.xls ,

The contents of Userform TextBox3 is posted to a column in mydec.xls based on the value of TextBox2 so the code has to search for the appropriate column once the network workbook is activated.

Any ideas and code appreciated.

 

[Trevor G]

I am trying to post userform data to multiple workbooks, but the 2nd workbook is on a network server. p:\NetServer\MyDir\my2009Files\PostData2009\mydec.xls

How do I post the same data to the network workbook (Sheet1) which is mydec.xls ,

The contents of Userform TextBox3 is posted to a column in mydec.xls based on the value of TextBox2 so the code has to search for the appropriate column once the network workbook is activated.

Any ideas and code appreciated.

Behind a command button do something like this, run the code to the sheet first then same to the other book:

sheets("sheet1").select
Range("b2").select
do until activecell.value=""
activecell.offset(1,0).select
loop
Activecell.value=me.textbox3.value

Workbooks.open.p:\NetServer\MyDir\my2009Files\PostData2009\mydec.xls
sheets("sheet1").select
Range("b2").select
do until activecell.value=""
activecell.offset(1,0).select
loop
Activecell.value=me.textbox3.value

 

[simora]

Thanks Trevor G:

Your code Makes logical sense.