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