Re: File name in Post_processing for Excel Macro (156 Views)
Reply
Frequent Advisor
Anthony1bd
Posts: 49
Registered: ‎05-20-2014
Message 1 of 2 (196 Views)
Accepted Solution

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
William Schmitt
Posts: 340
Registered: ‎04-02-2008
Message 2 of 2 (156 Views)

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.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.