Probelm with Data formatting

A

amit

Anyone who can help me on this issue .
I am posting this issue again

Regards
Amit

Hi ,
I tried what you suggested but it did not work
here the same code i used to laod a text file and sample data file i try
to load
string m_sTempCSVFilePath =
"D:\\abc_051b66ed-532c-4bab-a068-b63eb2c239d8.txt" ;

axSpreadsheet1.ActiveSheet.Cells.get_Item(1,1).
LoadText(m_sTempCSVFilePath,";",false,"' '");

axSpreadsheet1.Show ();

content of abc_051b66ed-532c-4bab-a068-b63eb2c239d8.txt file

CORE DESC;CORE
3" GRNSTRIPE NOTCHED;3GN
3" HVYWALL INSERTED;3HI
3" HVYWALL NO NOTCH;3HP
3" HVYWALL NOTCHED;3HN
3" MEDWALL NO NOTCH;3MP
3" REGWALL INSERTED;3RI
3" REGWALL NO NOTCH;3RP
3" REGWALL NOTCHED;3RN
3" THINWALL NO NOTCH;3TP
3" THINWALL NOTCHED;3TN
3"GRNSTRIPE NO NOTCH;3GP
4" MEDWALL NO NOTCH;4MP
4" REGWALL INSERTED;4RI
4" REGWALL NO NOTCH;4RP
4" REGWALL NOTCHED;4RN
5" MEDWALL NO NOTCH;5MP
5" MEDWALL NOTCHED;5MN
5" REGWALL INSERTED;5RI
5" REGWALL NO NOTCH;5RP
5" REGWALL NOTCHED;5RN
6" HVYWALL NO NOTCH;6HP
6" HVYWALL NOTCHED;6HN
6" REGWALL INSERTED;6RI
6" REGWALL NO NOTCH;6RP
6" REGWALL NOTCHED;6RN
723456789012345A;77W
8" REGWALL NO NOTCH;8RP
8" REGWALL NOTCHED;8RN
FHFHA;76P
NO CORE NEEDED;...
RWQRA;77B
STANDARD LINER CORE;STD
 
B

BrianB

Don't really understand your problem. Your code looks wrong. If you
set to record a macro as you open the file you get something like :-
Workbooks.OpenText FileName:= _ ............ etc.

Regards
BrianB
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top