mcwsky09
04-08-2012, 09:30 AM
I am running into what appears to be a limitation of the built in GetOpenFilename function - in that I cannot change the buttons.
After the user selects a File to open - I pop up a question to either Append to Existing or Replace Existing - I would prefer to have that be options directly on the open file dialog.
If there is no way to edit the built in dialog - then perhaps I need to create my own Open File dialog entirely?
Or another approach would be to have a separate Erase Existing button that can be fired off first - and have the get open file always use my append method. Which may be the route I end up with - since I will be building a third option - Insert as New - meaning that I want to have the option to add a new worksheet such that I can have a new page for a new location for example.
If anyone any point me to a way to customize the built in dialog - or code that is already written for a fully customized Get File routine that would be helpful. thanks.
After the user selects a File to open - I pop up a question to either Append to Existing or Replace Existing - I would prefer to have that be options directly on the open file dialog.
If there is no way to edit the built in dialog - then perhaps I need to create my own Open File dialog entirely?
Or another approach would be to have a separate Erase Existing button that can be fired off first - and have the get open file always use my append method. Which may be the route I end up with - since I will be building a third option - Insert as New - meaning that I want to have the option to add a new worksheet such that I can have a new page for a new location for example.
If anyone any point me to a way to customize the built in dialog - or code that is already written for a fully customized Get File routine that would be helpful. thanks.