I've lost my bold key on spread sheet. How do I get it back? thank you

share edit delete

are you sure?

asked 3 days ago John Larkin

0 answers

Post an answer but please log in first

Post Answer

Please log in to post answer

Excel VBA and sqlite : personnal dlls path

Hello, i'm working on a portable app with Excel VBA and sqlite, i would like to specify a personal path for dlls in the connection String. can you help me with that ' Chemins personnalisés vers les DLLs et Base de données

SQLite Excel

0 votes

0 answers

Anonymous user • 3 months ago

Conectar a dos listas de sharepoint on line para consulta SQL con JOIN

Buenas tardes Desde EXCEL VBA Necesito conectarme a dos listas de sharepoint on line para realizar una consulta SQL a las dos listas utilizando JOIN, pero me da error porque no reconoce los nombres dos listas.

Excel 2013 SharePoint Excel

0 votes

0 answers

ALEJANDRO M • 7 months ago

Connecting to Excel DataTables

Hi am currently wrtting a vba subroutine that i want to use in order to query a datatable in a worksheet, and then load the recordset into a different datatable in my current worksheet.

Excel

0 votes

0 answers

Jakob Espinoza • 9 months ago

Dealing with NULL values through OLEDB

I have a Microsoft Access 2019 database and have a process external to the Access database that pulls some data and processes the data to email a summary to end users in my company. The process has been running for years without a problem. A few months back the external process

Access

0 votes

0 answers

Chuck Rizzio • 12 months ago

ADOODB Connection error Excel 16 32, bit OLE DB providers

Connection String for Excel 2016 32 bit. The script work without a problem on Office365 Excel version, When the same file is sent to a different user with excel 2016. It get Connection initiation error. "An Error occurred after the connection was established" .

Excel

0 votes

0 answers

Abin Alex • Dec 13, 2023

Microsoft Access Text Driver - Omit extensions from table names?

Dear Community, I am using Microsoft Access ACEODBC driver v. 16.00.16827.20014 on Windows 11 and connection string: 'Driver={Microsoft Access Text Driver (*.txt, *.csv)};DBQ=path\to\tmp_dir;Extensions="asc,csv,tab,txt";'

Textfile Access

1 vote

0 answers

Marie • Oct 30, 2023

What is the correct connection string for Azure SQL database using a Service Principal?

Hi all, Apologies if this has been answered already, but I'm struggling to find a solution. I'm trying to build a connection string that connects to Azure SQL Database using a Service principal.

Active Directory Azure SQL Database

0 votes

1 answer

Francois • Sep 29, 2023

"Failure creating file." Exception connecting to Excel on Sharepoint.

I need a connection string to connect to an Excel workbook that is stored ona corporate sharepoint site. I get a "Failure creating file" exception. Here is what I have been using:

Excel 2013 SharePoint Excel

0 votes

0 answers

Kevin Miller • May 07, 2023

how to call an Oracle stored procedure from an Excel VBA script?

Using connection string "Provider=OraOLEDB.Oracle; ....", my VBA code is connected to Oracle 19c. Next, how do I call an Oracle stored procedure of having input parameters and IN/OUT Ref cursor from an Excel VBA script?

Excel Oracle

0 votes

0 answers

Sharon • Apr 17, 2023

Access Wait popup form shows blank

Hello. Using vba for Access 365, I want to display a “Wait” pop up form, with some nice and relevant design, that would open at the beginning of a long code execution (takes about 1 or 2 minutes) that takes place on the main/calling form, and then close once that execution is done.

Access

0 votes

0 answers

Jean-Claude Elias • Mar 23, 2023

Load more posts