how to publish excel workbooks

[Francis]

Hello
My problem is simple, i need to publish to my clients a catalog of
electrical material that has over 60.000 entries, and with links
between more then one sheet.
Problem is i dont want users to copy/paste, or change the data, only
can view it.

Of course i wont use Excel built in protection since it offers no
security at all, the same problem applies to VBA coding, that can be
easily forced in.

Solution was to export this to html, and from html to flash, but i
think it will be very slow.

Basically the ideal would be to export he whole workbook intact to
flash, that would be swell.

Ok this is the ultimate tool for excel, a flash conversor.

Ok any informations are appreciated.

BtW: using mde of Access wont do it, bcose once again is not safe
enough and can be reverse engineered the whole objects.

Thanks in Advance
F Costa

 

[Lyle U]

PDF?

 

[Francisco Parrilla]

Maybe to do it, you can perform a file HTML for an consult by DAO / ADO
with a select into the file XLS.

Yo can divide the type materials on section for the combo in HTML file or
choice options.
All depend of the file structure.

It can be HTML or ASP, would you like

regards

Francisco Parrilla

 

[Francisco Parrilla]

Ups Sorry I don´t read well, Wiil you make an addin for XLS or well make it
in Vbasic like a COM.

regards

Francisco Parrilla

 

[Francis]

Hi,
regarding PDF suggestion its out of question since, it creates a huge
file, but the worst is that, it wont actually prevent copy/paste.

wOW sounds very interesting F Parrilla, actually the workbook is
simple, i have this structure:

Sheet1 - Entrance Menu: (4 links see below hierarchy)

-> Sheet2 - electrical material1 (search by function/
application): 1 Link
-> Sheet3 - electrical material Product/
Price: links to Sheet1
-> Sheet4 - renewable energies1 (search by function/
application): 1 Link
-> Sheet5 - electrical material Product/
Price: links to Sheet1
-> Sheet6 - electrical material2 (search by brand/
producer): 1 Link
-> Sheet7 - electrical material Product/
Price: links to Sheet1
-> Sheet8 - renewable energies2 (search by brand/
producer): 1 Link
-> Sheet9 - electrical material Product/
Price: links to Sheet1

so im using here a lot of Hyperlinks, im more of an expert in Access
VBA, but this kind of thing is easier to develop in Excel since i have
easily like 200.000 products! To pick from.

what would be really quewl would to maintain everything as we see in
Excel, but avoid any copying/paste and read-only.

Looking forward for more ideas, The COM idea sounds really ok so i
would like to know more about this, ok thanks.

Thanks in advance,
Francis (Portugal)

Francisco Parrilla escreveu:

 

[Francis]

Any ideas ?


Francis escreveu:

Hi,
regarding PDF suggestion its out of question since, it creates a huge
file, but the worst is that, it wont actually prevent copy/paste.

wOW sounds very interesting F Parrilla, actually the workbook is
simple, i have this structure:
-> Sheet2 - electrical material1 (search by function/
application): 1 Link
-> Sheet3 - electrical material Product/
Price: links to Sheet1
-> Sheet4 - renewable energies1 (search by function/
application): 1 Link
-> Sheet5 - electrical material Product/
Price: links to Sheet1
-> Sheet6 - electrical material2 (search by brand/
producer): 1 Link
-> Sheet7 - electrical material Product/
Price: links to Sheet1
-> Sheet8 - renewable energies2 (search by brand/
producer): 1 Link
-> Sheet9 - electrical material Product/
Price: links to Sheet1

so im using here a lot of Hyperlinks, im more of an expert in Access
VBA, but this kind of thing is easier to develop in Excel since i have
easily like 200.000 products! To pick from.

what would be really quewl would to maintain everything as we see in
Excel, but avoid any copying/paste and read-only.

Looking forward for more ideas, The COM idea sounds really ok so i
would like to know more about this, ok thanks.

Thanks in advance,
Francis (Portugal)

Francisco Parrilla escreveu: