work with two maps
 

hello to everything,

I must work with two Excel maps, because several users should acces
the data.
If the second map is opened, I am able to come:
Workbooks(Mappe2).Worksheets("Tabelle1").ActiveShe et.UsedRange.Rows.Coun

… The number of the lines determine. Thus a connection with the secon
map and the "Tabelle1" or already, nevertheless, exists?

Why I am able to come then:
Workbooks(Mappe1).Worksheets("Tabelle1").Range(dat Range2)
Workbooks(Mappe2).Worksheets("Tabelle1").Range(dat Range2).Value
Not the data of the second map in the other copy?!
It appears with me always the error message:
“ Term mistake '9': Index beyond the valid area “
Why???

In the first map the "Tabelle1" is selected, I have this with:
Set shtSheets = ActiveWorkbook.Windows(1).SelectedSheets
For Each wksWorksheet In shtSheets
vbResult = MsgBox(wksWorksheet.Name, vbOKOnly)
Debug.Print wkbWorkbook.Name
Next wksWorksheet

… Checks and it also came as an announcement the "Tabelle1"!

And I can access the "Tabelle1" in the second map, nevertheless, als
already (because of Rows. Count).
Thus what do I still make wrong?!
How can I so select the maps and/or tables and/or activate that n
error message comes and I have the desired access?

I would be really grateful for help
walke

--
walker00
-----------------------------------------------------------------------
walker002's Profile: http://www.excelforum.com/member.php...fo&userid=2591
View this thread: http://www.excelforum.com/showthread.php?threadid=39291