The Materials Required

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

The Materials Required

Logged in as: Guest

arrSession:exec spGetSession 2,7,33805

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [General Forum] >> Other Programming/Scripting Languages >> The Materials Required
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

The Materials Required - 4/24/2006 2:07:43 AM

Enda

Posts: 3
Score: 0
Joined: 4/23/2006
From: Ireland
Status: offline

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

Post #: 1

RE: The Materials Required - 4/24/2006 2:29:07 AM

ebgreen

Posts: 4613
Score: 31
Joined: 7/12/2005
Status: offline

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.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to Enda)

Post #: 2

RE: The Materials Required - 4/24/2006 3:03:02 AM

Enda

Posts: 3
Score: 0
Joined: 4/23/2006
From: Ireland
Status: offline

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 :-)

(in reply to ebgreen)

Post #: 3

RE: The Materials Required - 4/25/2006 1:32:07 AM

ebgreen

Posts: 4613
Score: 31
Joined: 7/12/2005
Status: offline

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.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to Enda)

Post #: 4

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.

All Forums >> [General Forum] >> Other Programming/Scripting Languages >> The Materials Required

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts