I am using the fiollowing code to check for files in a dir and then open sequencially.

Do Until EGFile = ""
FileNum = FreeFile
Open EGFile For Input Access Read Shared As FileNum

'more code here'

Close FileNum
EGFile = Dir
Loop

My problem is that after the 'Open EGFile....' code I cannot see the file in Excel or use any code to pull data from various cell references within the worksheet. Do I need to activate the file somehow?


Thanks in advance.