Create Excel VBA script to rename PO pdfs from csv

$10-30 USD

Cancelled

Posted

over 8 years ago

$10-30 USD

Paid on delivery

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

Project ID: 8804392

About the project

1 proposal

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

1 freelancer is bidding on average $29 USD for this job

@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 day