borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (Sideways/Vertical Text)Next Topic (barcode) New Topic New Poll Post Reply
AndreaVB Forum : VB General : CSV and xls files
Poster Message
Sekar
Level: Sage

Registered: 11-03-2004
Posts: 63

icon CSV and xls files

I created a csv text file using FSO and loaded comma delimeter records from the db. After that I opened csv file using exel. Than insert a column and appended some more data. The problem is it's not saving the newly added data. When I open the csv file, it's opening in READ-ONLY mode. Why? After I insert a column and data how do I store it? Thanks in advance.

28-08-2004 at 01:32 PM
View Profile Send Email to User Show All Posts | Quote Reply
Goran
Level: Moderator

Registered: 16-05-2002
Posts: 1681
icon Re: CSV and xls files

Are you saying that your csv file has Read-Only attribute? If so, you can remove it using API's, like SetFileAttributes

____________________________
If you find the answer helpful, please mark this topic as solved.

31-08-2004 at 01:13 AM
View Profile Send Email to User Show All Posts | Quote Reply
pavane
Level: VB Lord

Registered: 26-04-2004
Posts: 179
icon Re: CSV and xls files

Are you by any chance using Win2000?
Sometimes it seems to keep hold of a file even after you have closed it in your code (But didn't close the application itself)

I had this problem when writing temporary MIDI files - in WIN2000, I could not just overwrite the previous version.
It works OK in other WIN versions.

01-09-2004 at 10:45 AM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
AndreaVB Forum : VB General : CSV and xls files
Previous Topic (Sideways/Vertical Text)Next Topic (barcode) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder