| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get Properties Generate tab Location value
Hi Reader
How to get Properties Generate tab "Location" value ? What location is file saved directory. Below coding just return file name only. Sub FileName() Dim xname As String xname = Application.ActiveWorkbook.Name xname = Application.InputBox("File Information", "Detail", xname) End Sub moonhk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| File Properties Location retrieve to refresh background query? | Excel Programming | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
| Mouse Location, Movement and Spreadsheet Location | Excel Programming | |||
| Properties transferring from excel cells to word file properties | Excel Programming | |||
Threaded Mode
