Excel VBA to transform CSV & XLS file into template

We have an Excel template (Loading Quote Items as Products into Salesforce [url removed, login to view]) that needs to be populated from one of 2 sources.

1. [url removed, login to view]

2. [url removed, login to view]

We need a button within the Excel template which will enable the user to select which of the 2 Suppliers we are loading data from.

Then a Select File Dialog box will be displayed (limited to CSV for Supplier 1; XLS for Supplier 2)

When the file is selected the application should populate data into the Data sheet of the Template (see the Mapping Tabs for examples of where data is to be mapped to plus a few additional notes).

Compétences : Excel, Visual Basic pour les apps

en voir plus : excel vba csv template, salesforce one, application template excel, salesforce applications, xls, excel/vba, excel-to-csv, excel visual basic, Excel to CSV, excel vba salesforce, populate template excel vba, amp visual basic, vba amp, application vba, xls visual basic, mapping excel vba, sheet excel visual basic, excel additional, 504, vba excel salesforce, visual basic amp, vba sheet, data vba, amp vba, csv quote

Concernant l'employeur :
( 7 commentaires ) Narangba, Australia

Nº du projet : #2359262

Décerné à:


Easy job for me. Please check PMB for details.

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% AUD en 1 jour
(10 Commentaires)

6 freelance font une offre moyenne de $170 pour ce travail


Please check PM. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(31 Commentaires)

Consider it done. Check your PM for my bid details.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(49 Commentaires)

Dear Sir, Today I have found this job post and i am very interested in your job post involving these skills. I have good experience in data entry and Ms-office,MS-Excel,MS-PowerPoint. I believe my skills would be ideal Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 15 jours
(0 Commentaires)

Hi, I have 9 years experience in computer programming. Consider your requirements done with great quality.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(0 Commentaires)

HI, I have strong Excel and VBA skills and can do the job. Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)