Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert cell content to filename
I have spreadsheets generated daily with respective dates. I am able to
create their names in another spreadsheet in a cell. How do I use this cell content as filename to open respective file? I appreciate any tips. Thank you. Nicole |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert cell content to filename
Nicole,
You can select the cell where you have the name of the file, go to the menu INSERT | HYPERLINK or Ctrl + K and select the path and the file that you would like to open. hope it helps regards from Brazil Marcelo " escreveu: I have spreadsheets generated daily with respective dates. I am able to create their names in another spreadsheet in a cell. How do I use this cell content as filename to open respective file? I appreciate any tips. Thank you. Nicole |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert cell content to filename
To carry this idea one step forward: I have *.txt datafiles created each day
from a data logging system, incorporating the date into the name. I want to use a calendar control to pick a date for a record to retrieve. The calendar control enters the requested date into a cell on the spreadsheet. Using a combination of YEAR(), MONTH(), DAY() and string concatenation functions, I can re-create the file name. For example, to create the file name for June 1, 2006, use the calendar control to enter "10/20/06" into cell A1. Then use MONTH(A1) to get "10" for October, DAY(A1) to get "10" for the day, and RIGHT(YEAR(A1),2) to get "06" for the year. Next, I use ="SU"&A2&A3&A4&".TXT" to re-create the original data file name, "SU102006.TXT". How do I code VBE to take that file name, insert it as the "FileName" property in a macro to get external data? "Marcelo" wrote: Nicole, You can select the cell where you have the name of the file, go to the menu INSERT | HYPERLINK or Ctrl + K and select the path and the file that you would like to open. hope it helps regards from Brazil Marcelo " escreveu: I have spreadsheets generated daily with respective dates. I am able to create their names in another spreadsheet in a cell. How do I use this cell content as filename to open respective file? I appreciate any tips. Thank you. Nicole |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
lookup cell content in multiple files | Excel Worksheet Functions | |||
Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |