Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling value from cell to complete path name
I'm looking for a way to extract a value from an Excel form to complet
path for SaveAs operation. This what I currently have: Need to save form as : sPath = "\\Cpgbyfs03\comrfq\GBY\20\MyForm.xls" (where 20 is a folde for a specific district) The thing I'm running into is by specifying the district as part o sPath, I need to change 17 of these forms each time for 6 macros whe master form is split into districts (17 districts and 6 approva locations). Obviously, this would not be very productive. My first thought was to provide user with input box to enter district but all users are not computer savy and concern over typos exists. Cell G10 on the form currently contains a value for that district' number. What I'm looking to do is insert the value from cell G10 o active form and make it part of the sPath code so each form will b routed to correct location on a terminal server. Any suggestions would be greatly appreciated. tschult -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy the first word or two words from a cell containing a complete sentence to another cell | Excel Discussion (Misc queries) | |||
Complete path info on Excel window | Excel Discussion (Misc queries) | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
Pulling a Letter from a cell and filling another cell with info | Excel Worksheet Functions | |||
Pulling in the path to a filename | Excel Worksheet Functions |