Project Detail

Excel .csv add-in for format changes  

Excel .csv add-in for format changes is project number 265131
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: tusharvv

Budget: $30-250

Created: 05/22/2008 at 3:50 EDT

Bid Count: 10

Average Bid:
$ 60

05/23/2008 at 3:50 EDT

Project Creator: jonjonsson
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (8 reviews)

Bid On This Project
 

Description

I need a utility or a add-in that can when pressing on a .csv files to changes the format of the fields in Excel.
-
The problem at the moment is for example if importing the following file:

00032323 32-32-3223 abcd dfdsfds 123

Then Excel automatically changes the format of the fields to

Number, Date, Char, char, Number

I need a utility that will automatically when double clicking on .csv files in Windows put the data in the format as for example:
00032323 32-32-3223 abcd dfdsfds 123
text text text text number

So the logic is when there are leading zeros the fields become text and if there are "-" in the number or text the field becomes a text not a date.

I need a utility that will do this automatically when double clicking on the .csv file in Windows, I don't want a utility where I have to press a button or run through some kind of filter before, needs to be automatic.

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

75

0 days

05-22-2008 04:31 EDT

On your Excel Add-In, you should catch the Workbook_Open event for processing that data formats. So, when you double click any csv files, your cell will be formatted like that. Contact me and I will show you a demo.

help

 

35

2 days

05-22-2008 12:25 EDT

We can create a .xla addin which will do the needful. Btw, you have provided excellent description for a programmer.

help

 

80

2 days

05-22-2008 04:04 EDT

Hello I can create a add-in for your requirement. I'll use vb to develop it. I'm looking forward to work with you. Best regards. Libin

help

 

90

2 days

05-22-2008 17:20 EDT

Hello sir Please check your PMB for Bid details Thanks

help

 

50

1 day

05-23-2008 04:05 EDT

pzl view pm

help

 

30

1 day

05-22-2008 13:09 EDT

Hello. Ready for this job.

help

 

30

2 days

05-22-2008 12:10 EDT

(No Feedback Yet)

This can be done using VBA in excel .I have dealt with .csv file a lot.i am the right person Regards Jolly

help

 

30

2 days

05-22-2008 09:03 EDT

(No Feedback Yet)

Let's begin!

help

 

50

4 days

05-22-2008 09:40 EDT

(No Feedback Yet)

I think i can help you

help

 

130

7 days

05-23-2008 02:48 EDT

(No Feedback Yet)

Please check PMB

help


    Bid on this Project