Frequent Advisor
File name in Post_processing for Excel Macro

Using Excel Macro i got "&F" to get the file name of excel report ... but its also show me the file Extension also...

 

 

i don't want the file extension   please help me what should be the code without file extension.

 

 

 

Esteemed Contributor
Re: File name in Post_processing for Excel Macro

This question is not really QC-specific and would best be asked in a MS Excel forum.  Or Google "excel vba filename without extension".  That gives many links with your answer.