I my macro I improt data by opening a spreadsheet copying the data ove
and closing it, and therefore flick between workbooks.

This is creating my problems and flicks to the wrong workbook
occasionally.

So I need to tell it to flick back the workbook the marco is in, bu
this workbook changes its name, so I can not say:

Windows(".......").Activate

Is there a way I can at the beginning give the workbook a nam
reference early on in the macro, eg something like:

MacroWorkbook = ActiveWindow

? And then each time I want to flick to this workbook I can refer to i
as:

Windows(MacroWookbook).Activate?

Thank

--
CarolineHedge
-----------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...fo&userid=3570
View this thread: http://www.excelforum.com/showthread.php?threadid=55883

ThisWorkbook.Activate
will always activate the workbook in which the macro is located. Is
there a problem with using this?
James

CarolineHedges wrote:
I my macro I improt data by opening a spreadsheet copying the data over
and closing it, and therefore flick between workbooks.

This is creating my problems and flicks to the wrong workbooks
occasionally.

So I need to tell it to flick back the workbook the marco is in, but
this workbook changes its name, so I can not say:

Windows(".......").Activate

Is there a way I can at the beginning give the workbook a name
reference early on in the macro, eg something like:

MacroWorkbook = ActiveWindow

? And then each time I want to flick to this workbook I can refer to it
as:

Windows(MacroWookbook).Activate?

Thanks


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=558831

Try

ThisWorkbook.Activate

Regards,
Stefi


€žCarolineHedges€� ezt Ã*rta:


I my macro I improt data by opening a spreadsheet copying the data over
and closing it, and therefore flick between workbooks.

This is creating my problems and flicks to the wrong workbooks
occasionally.

So I need to tell it to flick back the workbook the marco is in, but
this workbook changes its name, so I can not say:

Windows(".......").Activate

Is there a way I can at the beginning give the workbook a name
reference early on in the macro, eg something like:

MacroWorkbook = ActiveWindow

? And then each time I want to flick to this workbook I can refer to it
as:

Windows(MacroWookbook).Activate?

Thanks


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=558831

I knew there must be a really simple way, but I just didn't know what i
was.

Thank yo

--
CarolineHedge
-----------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...fo&userid=3570
View this thread: http://www.excelforum.com/showthread.php?threadid=55883