LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Compile XLS sheet into EXE

Hi All,

I have a lot of excel sheets that containt formula and macros. They are
distributed among different departments who enter the data and send
them back to me for collating all the data into a report. The problem
is : the users frequently meddle with the formula and macros. I've
tried to password protect the cells/macors, however it becomes an issue
when there is a need to change the formula range or macro to include
more columns, ranges etc. I then have to send them the password and
they will then modify the the formula to suit their needs.

Also, the files run into large ones (usually greater than 100MB) at
times.

I would like to know if there is a way we can compile the xls sheet/
workbook into an exe so that it would be more secure and also compress
the xls sheets. I know of the commercial xls compiler(DoneEx XCell
Compiler). I will greatly appreciate if someone would/could point out
the source to a similar program.

Looking forward to your respones.
Thanks & Regds

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
compile Duplatt New Users to Excel 5 March 26th 09 01:51 AM
Won't Compile GeorgeJ Excel Discussion (Misc queries) 3 July 30th 07 09:22 PM
Help with using a work sheet to compile data lowspark Excel Worksheet Functions 2 May 30th 06 02:47 PM
Compile Different sheets in one sheet Bijan1231 Excel Discussion (Misc queries) 1 January 24th 06 06:31 AM
VBAProject name compile error, not defined at compile time Matthew Dodds Excel Programming 1 December 13th 05 07:17 PM


All times are GMT +1. The time now is 04:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"