Write to an Excel file

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Write to an Excel file

Logged in as: Guest

arrSession:exec spGetSession 2,7,30532

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

Printable Version

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

Page: [1]

Message

<< Older Topic Newer Topic >>

Write to an Excel file - 2/1/2006 9:38:04 AM

dawsona0526

Posts: 8
Score: 0
Joined: 10/28/2005
Status: offline

Hello Folks,

I an trying to write to an Excel using Visual Basic 6. I have a form that I have created in VB; does not have functionality beyond displaying information. The trouble I am encountering is figuring out what would be my best approach. My idea would be to have either both a menu and toolbar option that the user would click to initiate this action. Once the action has been initiated the user will now see a window; kind of like what you would see if you were about to do a 'save as', the type of file should already be set and all the user has to do is simply enter a filename and specify a path. I see alot of examples showing how to open a Excel file through a VB program, but none showing how to save to one. Can anyone give me some clues/examples on how to tackle this? Thanks!

Post #: 1

RE: Write to an Excel file - 2/2/2006 12:46:36 AM

ebgreen

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

First, this is a VBScript forum, not a VB forum. Second, the section you posted in is for posting sample code not for asking questions. Third, searching this forum for "Excel Save" turns up a plethora of postings that detail how to save an excel sheet using VBScript which you should be able to use to point you in the right direction for a VB solution.

_____________________________

"... 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 dawsona0526)

Post #: 2

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 >> Write to an Excel file

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