Create Excel VBA script to rename PO pdfs from csv -- 2

Ολοκληρωμένο Αναρτήθηκε Oct 30, 2015 Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

Need to write some vb code for repeat task

**Requires renaming of pdf files.**

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 για Εφαρμογές

Ταυτότητα Εργασίας: #8804503

Σχετικά με την εργασία

9 προτάσεις Απομακρυσμένη εργασία Ενεργό Oct 31, 2015

Ανατέθηκε στον:

gokulanand

Hello I can get you this task done in the next 6 to 12 hours. Let me know if you are interested. Thanks

$25 USD σε 0 μέρες
(65 Αξιολογήσεις)
5.4

9 freelancers κάνουν προσφορές κατά μέσο όρο $26 για αυτή τη δουλειά

prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel :) and also i can do rename data via VBA please give me a chance for doing your job and im able to start doing your job right now :) T Περισσότερα

$15 USD σε 1 μέρα
(150 Αξιολογήσεις)
5.9
Grunty

Hi, I offer you top quality programming in VBA for Excel and Access. I'm ready to do your project. Looking forward to your contact, Grunty.

$30 USD σε 1 μέρα
(15 Αξιολογήσεις)
4.4
teeares

Please include the csv file as a part of the project for better understanding of the project. I have created many macros in Excel, hence this one will not pose any problems.

$15 USD σε 1 μέρα
(32 Αξιολογήσεις)
4.4
surekash7096

I have the expertise in scripting in VBA and can do this task quickly and accurately. Ready to start work now

$25 USD σε 1 μέρα
(22 Αξιολογήσεις)
4.1
mantumalakar10

hello, I have understood your requirements , please contact me so that we can start your work straight way. Thanks for your project. please check our profile . regards, Mantu

$40 USD σε 1 μέρα
(1 Κριτική)
0.0
kukuhmirdas45

dear sir I'd like to join in your progress to work some excel program and I can work with maximum thank you if you accept me in your progress

$25 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0