| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy History (recently opened) to Cells
If I pull-down File from the menu bar, I can select from a short list of
recently opened workbooks to open. The list represents a kind of history of recent usage of Excel. How can I copy this list to a column in the worksheet? For example, this list might show: C:\test\shell.xls C:\Temp\todo.xls I would like A1 to contain the text: C:\test\shell.xls A2 to contain the text: C:\Temp\todo.xls etc. Thanks in advance for any suggestions -- Gary''s Student - gsnu2007xx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy History (recently opened) to Cells
Sub GetRecentfiles()
For i = 1 To Application.RecentFiles.Count MsgBox (Application.RecentFiles.Item(i).Name) Next i End Sub "Gary''s Student" wrote: If I pull-down File from the menu bar, I can select from a short list of recently opened workbooks to open. The list represents a kind of history of recent usage of Excel. How can I copy this list to a column in the worksheet? For example, this list might show: C:\test\shell.xls C:\Temp\todo.xls I would like A1 to contain the text: C:\test\shell.xls A2 to contain the text: C:\Temp\todo.xls etc. Thanks in advance for any suggestions -- Gary''s Student - gsnu2007xx |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy History (recently opened) to Cells
Thanks!
-- Gary''''s Student - gsnu200803 "Joel" wrote: Sub GetRecentfiles() For i = 1 To Application.RecentFiles.Count MsgBox (Application.RecentFiles.Item(i).Name) Next i End Sub "Gary''s Student" wrote: If I pull-down File from the menu bar, I can select from a short list of recently opened workbooks to open. The list represents a kind of history of recent usage of Excel. How can I copy this list to a column in the worksheet? For example, this list might show: C:\test\shell.xls C:\Temp\todo.xls I would like A1 to contain the text: C:\test\shell.xls A2 to contain the text: C:\Temp\todo.xls etc. Thanks in advance for any suggestions -- Gary''s Student - gsnu2007xx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| History of Workbooks opened | Excel Worksheet Functions | |||
| history of dates/times an excel worksheet was opened? | Excel Discussion (Misc queries) | |||
| Customise the number of recently opened docs listed in File drop | Setting up and Configuration of Excel | |||
| saving the history of recently used excel documentsto another comp | Excel Discussion (Misc queries) | |||
| Removing the RECENTLY OPENED submenu item | Excel Programming | |||
Hybrid Mode
