Please could anybody help with a file

[Guest]

I have an order form for product in an excel file like this
Item Description Unit Quantity CaseSelling PriceQuantity


F1AL1080 Capless KG 83.49 5 9.68 1
F1AL1085 Whole KG 100.09 3 24.739 1
F1AL1091 RTS KG 404.46 21 9.68 1

What I need to do is to create an EDI file with the above information in
order to be able to import that file into my system

Could anybody help me?

 

[Guest]

SAve the file as text or CSV.

 

[Guest]

Joel, thank you for answering my question, what happens is that I need to put
the information in an EDI format as follow:

ISA*00* *00* *ZZ*46 *01*254185739
*070212*0738*|*00406*000000016*0*P*:~
GS*PO*46*254185739*070212*0738*16*X*004060~
ST*850*0000031~
BEG*00*SA*TestOrder1**20070212~
DTM*064*20070212~
DTM*063*20080212~
MSG*CommentLine~
N1*ST**92*24KARA~
PO1**4**8.50**VN*EV0336-001~ (4=quantiy of my order,8.5 price,ev0336=item
code)
PO1**14**9.50**VN*EV0346-001~
PO1**24**11.50**VN*EV0396-001~
PO1**124**18.50**VN*EV0936-001~
CTT*4*~
SE*14*0000031~
GE*1*16~
IEA*1*000000016~

From above I need to figure out, how to get there the information related to
the quantity, item code and price

 

[Guest]

I don't know what EDI format is. It doesn't look like the two files contain
the same data (EDI and spreadsheetA). I have written plenty of I/O programs
converting text from one format to another.

Using VBA you can open a text file and same the worksheet format to the text
file any way you want to.

If you give more info on the EDI format I can help

 

[Guest]

Joel, I have some documentation in word but as this is my first time posting
a question I don't know how to attach the document, I've tried to paste it
but unsuccefully,
Eduardo

 

[Guest]

This website doesn't allow attachments. Sent to my email address

(e-mail address removed)
I will look at this weekend.

 

[Guest]

Joel, I've sent the file thanks again for your help

 

[NickHK]

It would appear that saving Excel data in EDI format is not a trivial task:
http://edidev.com/XMLvsEDI.html

And these seem aimed at Java, but may be useful:
http://www.americancoders.com/OpenBusinessObjects/index.html
http://www.stylusstudio.com/data_conversion.html

NickHK

 

[Guest]

Hi Joel, when trying to run the macro give me an error message "Run-time
error '76": Path not found, when debug is highlighting "fs.CreateTextFile
MyFileName 'Create a file "
Thanks Eduardo

 

[Guest]

Hi Joel, I found what was wrong, now macro is working, thanks

 

[Guest]

Joel, thank you very much for your help it works perfectly, without your help
it'd be impossible for me to get that macro. My expertise is accounting,
budgeting and forescating if at any time you need some help don't hesitate to
contact me. Thank you again