Link to home
Start Free TrialLog in
Avatar of simonwait
simonwaitFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Append csv

This has been asked before I know but its just not making sense.  I have several variables.  Logdate, Logtime, StartTime, Finish Time, Duration, Moves, GoodMove, Bad Moves.

I need to look for a csv file as referred to in txtSaveAs.text and if it doesn't exist, create it.  I then need to add a line to a loop which creates the variables above which will append to this csv with semi colons as the separator.

Thanks in advance
ASKER CERTIFIED SOLUTION
Avatar of eemit
eemit
Flag of Germany image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of simonwait
simonwait
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks for that.  I added the code in and put everything below your comment about class code into a class module called cAppendtoCsv but I get a user defined type not defined on the line

Private m_oCAppendToCsv As CAppendToCsv
Avatar of eemit
eemit
Flag of Germany image
I've attached the file below.
CAppendToCsv.cls
Avatar of simonwait
simonwait
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Turns out I did a typo so thanks for the cls.