Hello everyone
I want to use the SendKeys to open file using FollowHyperlink method.
I have a constant called StrPath
Public Const strPath As String = "J:\Public\Spares & Consumables\"
All my files are named with the pattern yy-0000 (example 11-1025; 12-1523) where yy is the abbreviation of the year. The file name ends containing some information that indicates what that file is about . Example:
12-1523 - Nitrogen Bottles.xls
Everyweek we received a list containing a lot of these code (yy-0000 - Name of the file.xls) and we need open all of them. I would like to use the Followhyperlink to open the file using sendKeys, I mean, when the cells contains the code I'll press F8 key and it will open the respective file using the followhyperlink method just checking with the code of file.
Luthius
I want to use the SendKeys to open file using FollowHyperlink method.
I have a constant called StrPath
Public Const strPath As String = "J:\Public\Spares & Consumables\"
All my files are named with the pattern yy-0000 (example 11-1025; 12-1523) where yy is the abbreviation of the year. The file name ends containing some information that indicates what that file is about . Example:
12-1523 - Nitrogen Bottles.xls
Everyweek we received a list containing a lot of these code (yy-0000 - Name of the file.xls) and we need open all of them. I would like to use the Followhyperlink to open the file using sendKeys, I mean, when the cells contains the code I'll press F8 key and it will open the respective file using the followhyperlink method just checking with the code of file.
Luthius
