petersen313
New Member
- Joined
- Sep 25, 2007
- Messages
- 7
At work we have about 10 different excel programs that we use regularly, and we're trying to create a control panel program to make things easier for the less technically inclined.
The control panel program (currently named "Control Systems.xls" needs to be a shared workbook that has the ability to open, manipulate, and save other excel files. For example, we have a bidding programming (currently named "bid form.xls") that I need to have a macro from within "Control Systems.xls" access.
The user might want to open an existing bid - in which case the macro would simply need to reference a list of already created files (is it possible to create a list in excel by having a macro scan a folder and then make a list of all of the file names in that folder?) and then select from a pull down menu to open the appropriate bid.
If the user wants to create a new bid, I would need to have the macro prompt for a customer name, check to make sure that the customer name given isn't already in use, open "bid form.xls", then do a 'save as' and save the file as the customer name. They would then need to just work on and save the bid as normal.
Any ideas on how to get started (I'm pretty much a novice) would be greatly greatly appreciated.
The control panel program (currently named "Control Systems.xls" needs to be a shared workbook that has the ability to open, manipulate, and save other excel files. For example, we have a bidding programming (currently named "bid form.xls") that I need to have a macro from within "Control Systems.xls" access.
The user might want to open an existing bid - in which case the macro would simply need to reference a list of already created files (is it possible to create a list in excel by having a macro scan a folder and then make a list of all of the file names in that folder?) and then select from a pull down menu to open the appropriate bid.
If the user wants to create a new bid, I would need to have the macro prompt for a customer name, check to make sure that the customer name given isn't already in use, open "bid form.xls", then do a 'save as' and save the file as the customer name. They would then need to just work on and save the bid as normal.
Any ideas on how to get started (I'm pretty much a novice) would be greatly greatly appreciated.
