Data entry in two excel files using a form

Closed
bhavikalkesh Posts 1 Registration date Sunday 6 February 2011 Status Member Last seen 6 February 2011 - 6 Feb 2011 à 05:37
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 9 Feb 2011 à 16:20
Hello,

I have two excell files "a.xls" and "b.xls" both are having Three sheets "Sheet1", "Sheet2" and "Sheet3".
Both the sheets are protected by passwords.
In file a.xls I have created a form for data entry.
I want to keep the b.xls clossed always.
My requirement is to enter the data in "Sheet 1-a.xls" and "Sheet 2-b.xls" using the form in a.xls in the same manner, simultaneously.
Pls, help me....



1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
9 Feb 2011 à 16:20
I dont think you can do without opening the file. you have to open the connection to the file