Hola todos ! I have some problems to work with different workbooks. Whe
I start my principal workbook, I open different workbook wit
workbook_open().

In my module I use a procedure to identify my variables:

Sub SetRefs()

Set wbBook1 = Workbooks("Logiciel_Production_Soumission.xls")
Set wbBook2 = Workbooks("Projets.xls")
Set wbBook3 = Workbooks("Liste_Prix.xls")
Set wbBook4 = Workbooks("Clients.xls")

I call it in at the beginning of my module, but I have many problem
with my other procedures. Here is a example:

Private Sub RechercheProjetActif()

wbBook1.Worksheets("Feuille Calcul").Select
ProjetActif = Cells(3, 5).Value

wbBook2.Worksheets("DataBaseFrmMoldBase").Activate
ActiveCell = Cells(1, 1)

Do
If (ActiveCell = ProjetActif) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until (ActiveCell = ProjetActif) = True

Refligne = ActiveCell.Row

End Sub

I get an error 1004 with that.

Can someone can help me to work with different workbook at the sam
time ?

gracia

--
zapatista6

-----------------------------------------------------------------------
zapatista66's Profile: http://www.excelforum.com/member.php...fo&userid=1195
View this thread: http://www.excelforum.com/showthread.php?threadid=26851