Create Excel VBA script to rename PO pdfs from csv

$10-30 USD

Annullato

Pubblicato

più di 8 anni fa

$10-30 USD

Pagato al completamento

Need to write some vb code for repeat task Two simple scripts required, since user intervention needed in between MUST provide all source code unlocked. All files will occur within same folder (no subfolders) so no file-paths should be necessary. First script: On open, read in .csv file -current pdf name is in column J, new pdf name is in column S (requires some simple cleaning) -put names into input and output columns respectively End first script At this point the folder and files would all look like the 'before' folder provided. User will check output names, may need to correct on occasion. Second script: Upon user manually run query (or click button) Rename files based on input and output names. Clear CSV contents. Clear input and output for next run. Display success box to user. End Second script. At this point the folder and files would all look like the 'after' folder provided.

Excel

Visual Basic for Apps

Rif. progetto: 8804392

Info sul progetto

1 proposta

Progetto a distanza

Attivo 9 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

1 freelance ha fatto un'offerta media di $29 USD per questo lavoro

@kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.

$29 USD in 1 giorno