run time error (ADODB.Connection)

**fairyme** · 09-26-2023, 10:21 PM

I use ADODB.Connection in vba.

Now my code.

Please Login or Register  to view this content.

Please guide me for solve it.
Thank you

but show error as attached.

**6StringJazzer** · 09-26-2023, 10:52 PM

Data Source expects a full path name for a file. You are just providing a folder name. You will have move conn.Open inside the loop and open a new connection for each file.

Please Login or Register  to view this content.

**jindon** · 09-26-2023, 10:56 PM

You can not set the connection to folder for Excel files.

**fairyme** · 09-26-2023, 10:57 PM

Thank you Jeff,
But now I have new error.

Attachment 843965

How to solve it?

Thank you

**fairyme** · 09-26-2023, 11:31 PM

Please Login or Register  to view this content.

I want to select from sheet AP or ap.(lower case = ap)
But show error.

Please guide me for solve it.

**fairyme** · 09-26-2023, 11:36 PM

Please Login or Register  to view this content.

I want to select from sheet AP or ap.(lower case = ap)
But show error.

Please guide me for solve it.

run time error (ADODB.Connection)

LinkBack

Thread Tools

Rate This Thread

Display

run time error (ADODB.Connection)

Re: run time error (ADODB.Connection)

Re: run time error (ADODB.Connection)

Re: run time error (ADODB.Connection)

Re: run time error (ADODB.Connection)

Re: run time error (ADODB.Connection)

Thread Information

Users Browsing this Thread

Similar Threads

Run time error '3706' Provider cannot be found. [ADODB connection]

Run time error -2147467259(80004005) for using ADODB.Connection

SQL0905N error when trying to get data from DB2 using an ADODB connection

[SOLVED] ERROR: ADODB Spreadsheet Connection

System Error in ADODB connection code

Error with using adodb Connection and double quotes

[SOLVED] compile error... ADODB connection

Bookmarks

Bookmarks

Posting Permissions