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.

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.

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.

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.

Try to create new workbook, in range("a1") write text with more than 255
char, save it as xls file and then convert to an addin. You'll see that after
converting excel truncates data to 255 char in range("a1").


"Tom Ogilvy" wrote:

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.

Hi Joseph,

I followed your suggestions but I was unable to replicate your results.

Using xl2k, a 360 character test string remained untruncated.

---
Regards,
Norman



"JosephVBA" wrote in message
...
Try to create new workbook, in range("a1") write text with more than 255
char, save it as xls file and then convert to an addin. You'll see that
after
converting excel truncates data to 255 char in range("a1").


"Tom Ogilvy" wrote:

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.

I'm sorry, I made a mistake. When I converted xls file to add-in, sheet with
data was invisible, so I copied sheet:
workbooks("data.xla").sheets("data").copy. It created new workbook, but I
forgot that's normal that by copying Excel truncates the data to 255 char.
Now I try msgbox workbooks("data.xla").sheets("data").range("a1") and it
shows correct.
Thanks for your help.

"Norman Jones" wrote:

Hi Joseph,

I followed your suggestions but I was unable to replicate your results.

Using xl2k, a 360 character test string remained untruncated.

---
Regards,
Norman



"JosephVBA" wrote in message
...
Try to create new workbook, in range("a1") write text with more than 255
char, save it as xls file and then convert to an addin. You'll see that
after
converting excel truncates data to 255 char in range("a1").


"Tom Ogilvy" wrote:

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.