Rename a closed workbook without opening it

[Tejas Kore]

Hi Friends,

I am using powershell code for splitting a CSV file because it is faster than VBA on CSVs. I am splitting the file based on one specific column. So, if any values are blank in this column , powershell is generating file named .csv.

My question is can we rename this .csv file to something like Blank.csv .

I tried wbk.Open("C:/Users/tejas/Desktop/.csv") but it gave error.

 

[VBA Geek]

use this method:
https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/name-statement

 

[Tejas Kore]

Thanks a LOT VBA Geek...It worked absolutely fine... Was strugging with this since an hour