Excel visual basic current file name

Need more help? Expand your skills. Get new features first. A subscription to make the most of your time. Try 1 month free. Was this information helpful?

Yes No. Thank you! Any more feedback? The more you tell us the more we can help. This works. Keep in mind that if the file is unsaved, both ThisWorkbook. Name and ThisWorkbook. FullName will return the file name e. Book1 without a file extension or path. It might be useful to first check if the workbook has ever been saved. Mitch Wheat Mitch Wheat k 42 42 gold badges silver badges bronze badges. The op says inside sample. I suspect VBA. Louis Louis 39 2 2 bronze badges. Emil 7, 17 17 gold badges 74 74 silver badges bronze badges.

Name it would return sample. Reeno 5, 10 10 gold badges 37 37 silver badges 49 49 bronze badges. TheAccountant TheAccountant 1. Caption, 1, InStrRev Application. Caption, "-" - 2 End Function. Why do you say this is a universal way? This does not even answer the question. All your function does is the same as: ThisWorkbook.

Name — Excel Hero. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback!