Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tool to pick from currently unsaved files?
I am using Office 2003 on Windows XP.
I really like using the "FileDialog" to display a dialog so users can pick a saved file. I need a smart way to do this only I need to include currently open and unsaved files as well. Is there a way to do this? I have several programs that run from toolbars and build files from scratch. The scratch files are not always saved because sometimes the users do not want to keep the data, they only want to check results. Sometimes files are saved sometimes not - at user discretion. The users may flip between the program-created file and something of their own. I need a way when the user runs a subsequent process from my toolbar to be able to pick from a list of currently open files - as previously stated sometimes a saved and sometimes an unsaved file. Rather than building a userform I was hoping that someone would be able to tell me how to use the "FileDialog" to get and show that info - or some similar tool. Does anyone have any suggestions? Thanks much in advance for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tool to pick from currently unsaved files?
quartz,
You'll need to use a userform. HTH, Bernie MS Excel MVP "quartz" wrote in message ... I am using Office 2003 on Windows XP. I really like using the "FileDialog" to display a dialog so users can pick a saved file. I need a smart way to do this only I need to include currently open and unsaved files as well. Is there a way to do this? I have several programs that run from toolbars and build files from scratch. The scratch files are not always saved because sometimes the users do not want to keep the data, they only want to check results. Sometimes files are saved sometimes not - at user discretion. The users may flip between the program-created file and something of their own. I need a way when the user runs a subsequent process from my toolbar to be able to pick from a list of currently open files - as previously stated sometimes a saved and sometimes an unsaved file. Rather than building a userform I was hoping that someone would be able to tell me how to use the "FileDialog" to get and show that info - or some similar tool. Does anyone have any suggestions? Thanks much in advance for your assistance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tool to pick from currently unsaved files?
Thanks Bernie. I figured that would be the answer, but sometimes I'm
surprised, so I thought I would post anyway. Thanks again. "Bernie Deitrick" wrote: quartz, You'll need to use a userform. HTH, Bernie MS Excel MVP "quartz" wrote in message ... I am using Office 2003 on Windows XP. I really like using the "FileDialog" to display a dialog so users can pick a saved file. I need a smart way to do this only I need to include currently open and unsaved files as well. Is there a way to do this? I have several programs that run from toolbars and build files from scratch. The scratch files are not always saved because sometimes the users do not want to keep the data, they only want to check results. Sometimes files are saved sometimes not - at user discretion. The users may flip between the program-created file and something of their own. I need a way when the user runs a subsequent process from my toolbar to be able to pick from a list of currently open files - as previously stated sometimes a saved and sometimes an unsaved file. Rather than building a userform I was hoping that someone would be able to tell me how to use the "FileDialog" to get and show that info - or some similar tool. Does anyone have any suggestions? Thanks much in advance for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
retrieving unsaved files | Excel Discussion (Misc queries) | |||
retrieving "unsaved" files that you accidentally closed? | Excel Discussion (Misc queries) | |||
converter tool to convert XL 2007 files to XL 2003 files | Excel Discussion (Misc queries) | |||
need flexible tool to work with flat files - Excel No Good | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) |