Thanks for your link, I've fixed the problem. Just need to change the
value of Thisworkbook.IsAddin property to False before copying the
workbook over to add-in liabrary.

For your information, following is the final code I use.

Code:
--------------------

ThisWorkbook.IsAddin = True 'set IsAddin property to true

ThisWorkbook.SaveAs FileName:=fldr.Path & "\myAddin.xla" _
, FileFormat:=xlAddIn
--------------------


Strangely, without tweaking *IsAddIn * property, the -FileFormat -
parameter in *SaveAs * Method doesn't help at all even when you specify
the format as -xlAddIn-. I could copy over the file to personal Addin
folder but Excel couldn't recognise it as a valid addin. Problem was
fixed after I change the IsAddin Property of the workbook. Do you know
why?

Thanks,

Huyeote


Mel Arquiza Wrote:
Hi Huyeote,

If you follow all this steps below in this weblink:

http://www.exceltip.com/st/How_to_Us...n_VBA/630.html

The problem next could be your Office XP Service Packs (SP3) not
updated no
also sure.

Where is the code?




--
Huyeote
------------------------------------------------------------------------
Huyeote's Profile: http://www.excelforum.com/member.php...o&userid=13894
View this thread: http://www.excelforum.com/showthread...hreadid=472498