Recent content by antonio.manoj.derose

Hi All, I have given an ACCESS ADP Project, which gets committed in SQL Server tables. However, I don't see the connection string nor a provider in the code. But, when I run the code putting a debug point, and open the immediate window I add the '?CurrentProject.Connection.ConnectionString'...

Hi All, I am not able to save a file after processing, I am not able to see the dialog window being opened, to enter a name for the file to be saved. I am getting an error, error is attached, and am pasting the code for the section below. The code which breaks, is mentioned in red...

Hi Gina, I have resolved the issue, by doing nothing in the coding nor adding a library. How I resolved is, by simply installing the service pack 2 for the MS Office suite 2010. Gina - By the way, is there a way, I could mention or change status RESOLVED. BY the way, I will open...

Hi Gina, Tried xlsx, and resulted the same 1004 error, the code breaks in the same place where I have mentioned in red font. Thanks, Antonio

HI Gina, Original code was as you mentioned, yes the below, which still works fine for ms office 2007, and able to accept xlsm files. .ConnectionString = "Data Source='" & filename & "'; " & "Extended Properties='Excel 8.0;HDR=Yes;IMEX=1' The problem arose, when I started to work in...

Hi Gina, Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm; Extended Properties="Excel 12.0 Macro;HDR=YES"; resulted the same. But Many many thanks Gina, on your continuous help, and am sure, getting close in resolving this. Thanks, Antonio

Hi Gina, ACCDB Thanks, Antonio

Hi Gina, I have removed the multidimension, and it had not given any joy for me, you know what, when I tried to load the xls file, it was successful in loading. the issue it has is loading xlsm files, and just now I tried loading xlsx files, that would not load either. It does seem...

Hi Gina, Will do, can you help me, take a backup, cause I reckon the backup is not equal to copy paste of the access file. Thanks, Antonio

Hi Gina, Tried and the results are the same, do I have to uncheck repair, and then check again to see the errors. I have done both the ways errors are the same. Thanks, Antonio

Hi Gina, Which files are you asking for, please see attached for the libraries checked in. Thanks, Antonio

Hi All, Please see the error image too attached, file name - 1004.PNG, let me know how to show this error as a screenshot, so that I need not have to put in as an attachment, Thanks, Antonio

Hi Gina, Explanation below, please note that this code is working well, in the 32 bit, and yet it was well working for the 64 bit, when the creator was MS office 2013, now I have changed to Ms office 2010 for the 64 BIT, and the code is breaking in the font that I have mentioned in red...

Hi Mark, How can I place a screenshot, am trying to paste the error message. Thanks, Antonio

Option Compare Database Option Explicit Public Sub XlfileImportTestNew() Dim rs As New ADODB.Recordset Dim conn As New ADODB.Connection Dim cmd As New ADODB.Command Dim filename As String Dim rsIn As DAO.Recordset Dim db As Database Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook...