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