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: 31
Default Converting excel speardsheets/macro into a database system

I have constructed many interlinking excel based spreadsheets which have
numerous functionality through a series of macros I have written.

I realise that a lot of the calculation in the spreadsheet can be
altered/tampered with. Is there some system/software where I can have the
calculations in the background and just display the results so the
calculations cannot be tampered with and the new inputs can be easly entered?

Please note the only programming experience I have is with excel VBA, so I
doubt I wil be able to cope with any really complicated programming languages
(C++ etc).

For the meantime I have protected the cells/worksheets where possible.

Can anyone offer me any suggestions of how I can improve my systems?
 
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
How do I open an Excel file on XP system, saved on a Vista system JLS7 Excel Discussion (Misc queries) 3 December 2nd 08 04:21 AM
Converting Excel spreadsheet with formulae to Access database AndyL82 Excel Discussion (Misc queries) 1 February 3rd 07 06:53 PM
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row rjr Excel Programming 5 June 11th 06 09:43 PM
Link to ACT! customer database system Mark Bigelow Excel Programming 0 January 16th 04 03:55 PM
Link to ACT! customer database system andrew blakeley Excel Programming 0 January 14th 04 03:12 PM


All times are GMT +1. The time now is 01:10 AM.

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"