|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
05-18-2004, 12:24 PM
|
#1 |
|
Member (9 bit)
Join Date: Dec 2001
Location: US
Posts: 468
  |
Detect the Excel File Name in Visual Basic
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.
|
|
|
|
05-18-2004, 01:01 PM
|
#2 |
|
Professional gadfly
Join Date: Jan 2002
Location: Minneapolis, MN
Posts: 6,364
 |
Assuming you are doing this from Excel, I believe that Application.ActiveWorkbook.Name will give you the name of the loaded file.
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
