For Programmers: Free Programming Magazines  


Home > Archive > MSDN > June 2004 > excel VBA









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author excel VBA
Frank

2004-06-09, 3:56 pm


Could you please help, I like to open a text file and take its data which
are X, Y coordinates of a excel chart in to a excel datasheet. What I found
out is that I can use the VBA to open a text file and load its data to the
worksheet but I dont know how to load it in to a datasheet. Could anyone
help.


thank you in advance


Graham [MVP]

2004-06-09, 8:55 pm

Try www.bmsltd.co.uk for your Excel VBA Answers. It always works for me.

good luck

Graham.


"Frank" <p_guru_2050@yahoo.com> wrote in message
news:0tGxc.201$5bq.162@news04.bloor.is.net.cable.rogers.com...
>
> Could you please help, I like to open a text file and take its data which
> are X, Y coordinates of a excel chart in to a excel datasheet. What I

found
> out is that I can use the VBA to open a text file and load its data to the
> worksheet but I dont know how to load it in to a datasheet. Could anyone
> help.
>
>
> thank you in advance
>
>



Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com