Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File opening from Custome Toolbar
I would like to have a toolbar with seven buttons, each
of which would open a specific Excel file. I would use fully qualified path names e.g., "\\FIL-NW02-06 \MPTTechTeamLeaders\8_Tech_Team_Scorecard\Reddy Team Scorecards\[2005_Define_Scorecard_Hixson.xls" The only difference in any of the path names is the last part e.g., the Hixson in this one. So is there a way to set a module-level string equal to the first part of the path and append a different "end part" e.g. Hixson" to get the full path name, depending on the button pushed? I'm still new to this but having fun learning. Thanks Wayne |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File opening from Custome Toolbar
To do what you want, just declare the variable for the common part of the
path as a constant in the declarations section of the module (before any subs or functions): Const MyFilePath as String = "FIL-NW02-06\MPTTechTeamLeaders\8_Tech_Team_Scorecard\Reddy Team Scorecards\[2005_Define_Scorecard_" Then for each of your buttons, just append the rest; e.g. in the code for your "Hixon" button; SavePath = MyFilePath + "Hixon.xls" "Wayne" wrote: I would like to have a toolbar with seven buttons, each of which would open a specific Excel file. I would use fully qualified path names e.g., "\\FIL-NW02-06 \MPTTechTeamLeaders\8_Tech_Team_Scorecard\Reddy Team Scorecards\[2005_Define_Scorecard_Hixson.xls" The only difference in any of the path names is the last part e.g., the Hixson in this one. So is there a way to set a module-level string equal to the first part of the path and append a different "end part" e.g. Hixson" to get the full path name, depending on the button pushed? I'm still new to this but having fun learning. Thanks Wayne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How 2 Fix/Jam a custome ToolBar? | Excel Discussion (Misc queries) | |||
How to hide the outlook toolbar when opening an excel file | Excel Discussion (Misc queries) | |||
How to deploy custome toolbar/Menu commands in Excel? | Excel Worksheet Functions | |||
how to stop Reviewing toolbar from opening when I open a file | Excel Discussion (Misc queries) | |||
opening toolbar with file | Excel Programming |