Loans | Share Prices | Credit Card Consolidation | Loans | Mobile Phone
Detect the Excel File Name in Visual Basic [Archive] - PCMech Forums
PDA

View Full Version : Detect the Excel File Name in Visual Basic

wilbasket23
05-18-2004, 01:24 PM
how can i program in Visual Basic Application so every time when i run my program it will first detect the Excel file name and then pass the file name parameter into different module. how would i be able to achieve this.
doctorgonzo
05-18-2004, 02:01 PM
Assuming you are doing this from Excel, I believe that Application.ActiveWorkbook.Name will give you the name of the loaded file.