Tamamlanmış

Macro for Excel v9.0 for Mac

I have a person that creates excel worksheets in Mac Excel V9.0. There are only 6 columns being used ID MODELNO BRAND FileNo FORMAT TYPE MANUAL There may be up to 100,000 rows of data. We need 2 macros. One will remove any appostrophies. One will make sure EVERY field is a text field. I want the user to be able to highlight the range of data. Then hit the Macro that will then remove the appostophies. Or Hit a different Macro that will make sure every field is text. The problem we are having is that we upload these spreadsheets to a web site, then an ASP page takes the info off the spreadsheet and loads it into a SLQ server database. Sometimes when we Have a Model number that is all numbers - somehow that field does not upload into the database. It doesn't happen to fields that are Aplhanumeric only numeric. The problem is solved if we first convert the number into a text on the spreadsheet. The other problem is that if there is an appostrophy in a field it messes up the upload.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Excel v9.0 for Mac

Beceriler: PHP

Daha fazlasını gör: convert excel to web form, text macros, macro to upload, excel model, excel for mac, convert excel web, convert number excel macro, range macro excel, run mac, excel spreadsheet source code, install windows mac, convert code excel, mac excel spreadsheet, excel macro program, mac platform, php macro, executable mac, mac excel macro, convert excel spreadsheets numbers, macros mac

İşveren Hakkında:
( 4 değerlendirme ) United States

Proje NO: #2945016

Seçilen:

robertohvw

See private message.

%selectedBids___i_period_sub_7% gün içinde 21.25%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(12 Değerlendirme)
2.9

Bu iş için 3 freelancer ortalamada $30 teklif veriyor

elementxsoftware

See private message.

in %bids___i_period_sub_35% gün içinde42.5%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
3.5
mrnorris

See private message.

in %bids___i_period_sub_35% gün içinde25.5%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.0