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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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