RE: [ProgSoc] opening files in VB

["Glenn" <dubz@nospam.progsoc.org>]

Do you mean VBA in Excel or VB launching Excel?

Golden rule of VBA programming: record a Macro, then have a look at the
code. Thats how I've done every single bit of VBA in my life.

  gleNN

> -----Original Message-----
> From: owner-progsoc@nospam.progsoc.uts.EDU.AU 
> [mailto:owner-progsoc@nospam.progsoc.uts.EDU.AU] On Behalf Of Vik
> Sent: Thursday, March 14, 2002 1:25 PM
> To: The Programmers' Society
> Subject: Re: [ProgSoc] opening files in VB
> 
> 
> > Using Visual Basic, I have to write a program that opens a 
> text file 
> > in
> > excel, puts the data into the appropriate columns and then 
> creates pretty 
> > graphs for managers to look at.
> > 
> > www.msdn.microsoft.com is giving me leads, but not answers. 
> How do I 
> > do
> > this? The text file has spaces between fields.
> 
> that's what u get 4 using micros~1 (sorry, can't answer an MS 
> related question without a quick sledge)
> 
> The way I have done this in the past (in VB4) was to use the 
> database features of VB, and as the source of the database 
> have it read a text file
> - IIRC u can set this to be comma delimited, tab delimited or 
> maybe space delimited. So u have to pretend the text file is 
> a database.
> 
> chow
> 
> vik
> 
<http://www.progsoc.org/~vik>
PGP: <http://www.progsoc.org/~vik/pgp.txt>

"I think it would be a good idea." Ghandi, on Western Civilisation


-
You are subscribed to the progsoc mailing list. To unsubscribe, send a
message containing "unsubscribe" to progsoc-request@nospam.progsoc.uts.edu.au.
If you are having trouble, ask owner-progsoc@nospam.progsoc.uts.edu.au for
help.


-
You are subscribed to the progsoc mailing list. To unsubscribe, send a
message containing "unsubscribe" to progsoc-request@nospam.progsoc.uts.edu.au.
If you are having trouble, ask owner-progsoc@nospam.progsoc.uts.edu.au for help.