title: Reading/writing data from/to another excel file in userform (vba)
body: <p>I have a lot of seperate excel files in which they have micros and they are doing some calculation. Now I want to make an userform with different tabs for each excel file. So via this userform I want to give the input for each excel file and then read the results from them. I just know how to read/ write within the excel file that I am making the userform. For example i activate the sheet by following code and write my data on a specific cell:</p>
  <p>Sheet1.Activate</p>
  <p>Cells(4, 2).Value = TextBoxG.Value</p>
  <p>Now my question is how can I activate a sheet in another excel file and write on it? I tried this but doesn't work:</p>
  <p>Workbooks(&quot;N:\Navid\Excel.xlsm&quot;).Activate
  Workbooks(&quot;N:\Navid\Excel.xlsm&quot;).Sheets(&quot;Sheet1&quot;).Activate</p>