Click here to Skip to main content
15,904,415 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
how to get current excelfile name with path in excel add in using vb.net
Posted

1 solution

Use FullName[^] property for Workbook object.

Note: Newly created workbook do not contains path/directory, only default name (Workbook1, Workbook2, etc.).

More about VB Excel Automation addin (VBExcelAutomationAddIn)[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900