The Materials Required

Original message moved by mbouchard
Reason : Moving to a more appropriate forum
Not sure what materials to use for this Project!

I am using Excel 2003 and a SQL server to build a program to track inhouse inventory

What is the best type of VB Script to use to interact with excel.

I started programming VB 6 yrs ago, and since then in college programming
Java and all that goes with it

Unsure what VB engine would be the most suitable for my program?

Any suggestions on the above

It depends on how much functionality you need in your GUI and how encapsulated you want the app to be. VB6 will give you the most functionality in the GUI and will make the most tamperproof app. VBA is a close second on these points. VBA also provides tha most encapsulation because everything resides in the Excel file. VBScript will provide that least GUI functionality (although a fai amount still as an HTA) and will provide no tamper resistance at all.

Hi there, thanks for the information

VB6 for security - Yes

Is it possible to use https/ssl or some other secure method?

Thanks in advance :-)

You can use HTTP if you are using it in a hosted method on a secure server. That would provide security on the par of a compiled app.