What if you replace this:
FileFormat:=xlExcel8
With this:
FileFormatNum = -4143
I know from another piece of code I wrote that I had better success with a similar operation using FileFormatNum. For the earlier version of excel (Val(Application.Version) < 12), that is the .xls format number.
First post so hello to all.
I wrote some code for a project awhile back which does the following:
(a) creates a SQL String from a user form (strSQL is the string variable) and then
(b) inserts the string into a Access Database using an ADO conenction
This all works fine:
strSQL =...