vba code mergefiles does not runs properly within excel 2016

1 Star2 Stars3 Stars4 Stars5 Stars (7 votes, average: 4.86 out of 5)
Loading...
Go back to All Questions Login or Register
594 views
0

Dear sir i copy’t the mergefiles code to merge a set of csv files in to one New file , the excel version is a excel 2016 . The code runs until it gets to the row

textData = Input$(LOF(fileNo), fileNo)

Must have the excel file a specific reference? Or have i done something other wrong?

Many Thanks for your Reply

Robert nijhof
R.nijhof (at)zwanenberg.nl

Simply the best place to learn VBA!