PDA

View Full Version : Rename Current PDF file name using Excel Sheet List



hardeep
01-09-2017, 10:16 PM
Hi! All,

Is it possible to rename .PDF file name using excel Sheet?

Basically, we are working in Tally, and we need to generate Sales Invoice from Tally, and by default, tally save the invoice from Sales Invoice Number(Sales-101), and as per client requirement, they need Invoice number with Party Name (Sales-101-ABC), we have 2300 Ledger, and on daily basis we are generating 500 Sales Invoices.

PDF file save in (D:\INVOICE PDF-TALLY\PDF), and I need to rename file in this folder and save to another folder (D:\INVOICE PDF-TALLY\PDF rename) with updated File name.

My excel file location (D:\INVOICE PDF-TALLY\Sales Invoice Master.xlsx) file name “Sales invoice Master”, Column A have old File name and Column B have New File Name (Need to replace with Old Name)

Thanks in Advance

hardeep
01-10-2017, 09:59 PM
86 Views not a single reply,strange

Aussiebear
01-11-2017, 04:06 AM
86 Views not a single reply,strange

Not really given the large number of people who frequent the forum, simply watching trying to learn....