Runtime 1004 error

[HERMONES]

I have this code below which is causing a runtime error on the first row.
I have set the getfilesfrom and filenameimport as variables.
Im not sure why its happening, it opens the files fine, but then refers to a column in the spreadsheet saying it cannot find it, but the VBA does not tell it to find it?

Workbooks.Open FileName:=GetFilesFrom & FilenameImport (ERROR)
Workbooks.Open FileName:=TemplateFolder & TemplateName
Windows(FilenameImport).Activate
Worksheets.Item(3).Activate
Range("A1").Select
ActiveCell.Offset(1, 0).Select
If ActiveCell.Value = "" Then
Application.Run ("BuildContacts")

End If


Confused!

 

[Andrew Poulsom]

What's assigned to the variables GetFilesFrom and FilenameImport?

 

[HERMONES]

Thanks for your response. Yes thats correct.

Dim EmployeeId As String
Dim TemplateName As String
Dim GetFilesFrom As String
Dim TemplateFolder As String
Dim BuildLocation As String
Dim SaveBuiltDBFilename As String
Dim FilenameImport As String
Dim ThisFilename As String
Dim LastRow As Long
Dim FirstRow As Long
Dim MsgDone As String

FilenameImport = Range("C4").Value
TemplateName = Range("C5").Value
TemplateFolder = Range("C6").Value
BuildLocation = Range("C7").Value
ThisFilename = Range("C8").Value
GetFilesFrom = Range("C9").Value
SaveBuiltDBFilename = Range("C10").Value

 

[Andrew Poulsom]

Yes, but what do those variables actually contain when you get the error? Maybe you are missing a path separator at the end of the folder.