View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mihai[_6_] mihai[_6_] is offline
external usenet poster
 
Posts: 1
Default Error when moving sheet


The problem was that I did not shown the exact way. It works like this:

Workbooks("qsar_z.xls").Sheets(1).Mov
After:=Workbooks("qsar_detaliu.xls").Sheets(1)

As you can see I was so desperate that I even changed the names of th
files. :)
Stupid mistake

--
miha
-----------------------------------------------------------------------
mihai's Profile: http://www.excelforum.com/member.php...nfo&userid=280
View this thread: http://www.excelforum.com/showthread.php?threadid=27660