Creating a file name from a tag.value
Set MyTagGroup = Application.CreateTagGroup(Me.AreaName)
Dim Fname, Dfile As String
Dim NewFile As Tag
MyTagGroup.Add "Recipe\Recipe_FBK_Formulation"
MyTagGroup.Active = True
Set NewFile = MyTagGroup.Item("Recipe\Recipe_FBK_Formulation")
Fname = "C:\Access_DB\Data_Base.xls" 'name of already created excel file
Dfile = "C:\Access_DB\" & NewFile.Value & ".xls" 'name of new excel file
FileCopy Fname, Dfile
End Sub
So Fname already esist on the path
Dfile is suppose to take the value of Recipe\Recipe_FBK_Formulation and plug it into the
new file name.
Instead of the value it seem to be plugin in /::Recipe\Recipe_FBK_Formulation
So what am I doing wrong
Set MyTagGroup = Application.CreateTagGroup(Me.AreaName)
Dim Fname, Dfile As String
Dim NewFile As Tag
MyTagGroup.Add "Recipe\Recipe_FBK_Formulation"
MyTagGroup.Active = True
Set NewFile = MyTagGroup.Item("Recipe\Recipe_FBK_Formulation")
Fname = "C:\Access_DB\Data_Base.xls" 'name of already created excel file
Dfile = "C:\Access_DB\" & NewFile.Value & ".xls" 'name of new excel file
FileCopy Fname, Dfile
End Sub
So Fname already esist on the path
Dfile is suppose to take the value of Recipe\Recipe_FBK_Formulation and plug it into the
new file name.
Instead of the value it seem to be plugin in /::Recipe\Recipe_FBK_Formulation
So what am I doing wrong