Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
msoFileDialogFilePicker Question
Is it possible to use the msoFileDialogFilePicker to allow a user to navigate
to a specific folder of their choice and then input the name of a new file to be stored in that folder? Or, does it only work with existing files? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
msoFileDialogFilePicker Question
ebferro,
You can use msoFileDialogSaveAs to do this. Be aware that it has the same effect as doing a Save As from the file menu, i.e., you'll now be working within the newly saved file and the next time you save it you'll be saving to the new directory. hth, Doug Glancy "ebferro" wrote in message ... Is it possible to use the msoFileDialogFilePicker to allow a user to navigate to a specific folder of their choice and then input the name of a new file to be stored in that folder? Or, does it only work with existing files? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions |