View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] hardeepkanwar75@gmail.com is offline
external usenet poster
 
Posts: 2
Default Rename Current PDF file name using Excel Sheet List

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 saved in (D:\INVOICE PDF-TALLY\PDF), and I need to rename files 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