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
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
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
"[email protected]" 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
>
>
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
>
> "[email protected]" 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
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks