VBA to VB (Or any significantly useful language to process massive data)

[Souleh]

Hi all

Anyone here ever use VB (note NOT VBA) to edit excel sheets etc?

Ive built a number of scripts in VBA (Learnt VBA along the way...) and turns out I can make a SAP Export go from pure garbage into useful info in 4 minutes instead of 8-16hours.......

Only problem with VBA (As seen in my password minder sheet) is there is no code protection and the IP is free for the first person to unlock the editor..

Anyone know if its possible to get VB (Im assuming it has better security strength against being de-compiled) from my VBA with the same level of functionality etc? I would imagine you could import the VBA library into the main body of VB to allow this so please correct me if im wrong

Failing that.. has anyone managed to make spreadsheet code using any other languages?

Im talking between 30,000 and 1,000,000 rows of data along ~25 Columns

Many thanks (Im googling too as we speak...)

 

[Souleh]

Many thanks guys for the starters - Seems its been certainly done before!

Very interested in hearing if the Python method is a go'er

 

[Souleh]

Speed isnt a problem, im able to create a report of 200 lines long to summarise 500,000 rows within 40 seconds using VBA - This is across about 10 columns.

I use key indexing to store data locations in the original 500k sheet and can build a summary report in Word for specific exception cases (typically about 30)
This only takes a minute at most (That most time being taken by word saving the document)

What you mention though sounds exactly what im after - Intellectual property rights protection from the average user.

Will look into the dll route - take it then you just distribute the DLL and the compiled VB code ? Sounds ideal