Hello,
i'm hoping someone can help with this code. i have a standard excel format file that has to be saved as *.csv with '|" pipe delimiter. also each record must have a header and line items. "H" for header and "I" .
please see sample attached. Please help.
thanks heaps.
Last edited by spr2017; 11-04-2018 at 11:02 PM.
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
this is great. however i can we do some formatting on d(1,1) as yyyymmdd? i can put this in this in the excel but will need a separate cell to convert. I really appreciate your help. its perfect.
Thanks for rep.points. Just add the code line in red below :
Please Login or Register to view this content.
Perfect thanks heaps
Hello Karedog,
there is a slight change to this file and I've tried making it in this file but was unsuccessful in changing the code. can you please help? I've attached a new version of the file and highlighted the row.
i get an error on 'z(strKey)(4).Add Array(a(i, 2), a(i, 3), a(i, 7))' I've moved the cols across but not sure why.
oPlease Login or Register to view this content.
It should be :
Please Login or Register to view this content.
thanks heaps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks