Create Excel VBA script to rename PO pdfs from csv

$10-30 USD

Preklicano

Objavljeno

pred več kot 8 leti

$10-30 USD

Plačilo ob dostavi

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

ID projekta: 8804392

Več o projektu

1 ponudba

Projekt na daljavo

Aktivno pred 9 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

1 freelancer je oddal ponudbo s povprečno vrednostjo $29 USD za to delo

@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 v 1 dnevu