Search results

  1. J

    Convert xlsx to xls in VBA

    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.
  2. J

    GoTo last record, copy it, and create new record

    Your images aren't viewable (at least for me)? Can you post them as text?
  3. J

    Using ADO connection to insert records into Sharepoint 2010 Access DB

    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 =...
Top Bottom