bmckenna
New Member
- Joined
- Oct 15, 2009
- Messages
- 33
Hey All,
My goal:
- I have an existing workbook ("MAIN.xlsm").
- In that workbook I have a user interface worksheet ("INTERFACE") that has a command button that I want to "Import Data" into a worksheet ("DATA1")
- Upon clicking that command button, I would like to have a box that pops up (similar to the "Excel Button > Open" style) to select a file (file name changes regularly with no specific order) and then import all the contents of that file into cell "A1" of worksheet "DATA1".
It doesn't have to be exactly this, but something that is fairly user friendly. I have figured out how to do it by defining the file path in VBA, but not while allowing a user to select that path/file visually/easily.
Thoughts?
My goal:
- I have an existing workbook ("MAIN.xlsm").
- In that workbook I have a user interface worksheet ("INTERFACE") that has a command button that I want to "Import Data" into a worksheet ("DATA1")
- Upon clicking that command button, I would like to have a box that pops up (similar to the "Excel Button > Open" style) to select a file (file name changes regularly with no specific order) and then import all the contents of that file into cell "A1" of worksheet "DATA1".
It doesn't have to be exactly this, but something that is fairly user friendly. I have figured out how to do it by defining the file path in VBA, but not while allowing a user to select that path/file visually/easily.
Thoughts?