Data entry in two excel files using a form

Closed
bhavikalkesh Posts 1 Registration date Sunday February 6, 2011 Status Member Last seen February 6, 2011 - Feb 6, 2011 at 05:37 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 04:20 PM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2011 at 04:20 PM
I dont think you can do without opening the file. you have to open the connection to the file
1