using excel control in visual basic 6

spumbu1977

New Member
Joined
Dec 28, 2005
Messages
16
hi

i hope you can help

i am currently trying to paste a text file into an excel spreadheet control from within vb6 and am having no luck

the text file is created by a sql string which reads from a sql database and is unfortunately not delimeted in the text file creation however it is possible to do delimetation after it has been pasted in to excel itself , but the proble i am having is copying it into vb6 excel component

can anyone offer any opinions or examples that might be able to help

thanks in advance

Rob
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
You may be able to convert the text file and read it in list view and convert the send the list items to the excel sheet as an alternative option.

You would create an excel object using the excel object library, and you can write to that object by setting the ranges etc using that object model
 

Watch MrExcel Video

Forum statistics

Threads
1,118,330
Messages
5,571,570
Members
412,406
Latest member
DutchMonkey
Top