I have never heard that excel truncates data if you convert the workbook to
an addin. Perhaps it hasn't, but you are not retrieving all the data.
What action leads you to believe your data has been reduced to 255
characters?

--
Regards,
Tom Ogilvy

"JosephVBA" wrote in message
...
Thanks, you solved problem. I have one question yet. Is any way how to
reach
that the cell in add-in may contain more than 255 char? I have one
database
as excel sheet and I want to save it as add-in, but then I lost some data
in
cell if it contains more than 255 char.
Or the solution is only to have this data in Exel sheet (xls) and make a
reference in vba macro in add-in?

"Tom Ogilvy" wrote:

How are you trying to create the addin.

Assume you have MyAddin.xls open in Excel.

go to the vbe and select the project in the project explorer. Click on
the
ThisWorkbook entry and in the properties window, change IsAddin to true.

Go to the immediate window and execute the command

Workbooks("MyAddin.xls").SaveAs "C:\MyAddin.xla", FileFormat:=xlAddIn

--
Regards,
Tom Ogilvy


"JosephVBA" wrote in message
...
I tried to create add-in, but there is an alert message something like
"File
is not compatible with SYLK....You can choose Yes but you may lost
some
function, or data, or choose No and save it like xls file. So I cannot
create
an add-in.
When I choose Yes, it creates xla file, but if I try to add it to
excel,
it
message Add-in xxx is not valid.