288,829 questions
0
votes
1
answer
45
views
Run-time error after switching Redshfit ODBC-Driver 1.0 to ODBC-Driver 2.0
So far I have been using this VBA to extract data from Redshift - via ODBC Driver 1.0 - into my Excel-File
Sub Query_Data_driver_1.0 ()
Dim conn As New ADODB.Connection
Dim rs As New ADODB....
- 5,577
0
votes
2
answers
73
views
SQL query in VBA with Redshift ODBC driver 2.0 runs much slower compared to ODBC driver v1.0
I have been using this VBA to extract data from Redshift - via ODBC Driver v1.0 - into my Excel file:
Sub Query_Data_driver_1.0 ()
Dim conn As New ADODB.Connection
Dim rs As New ADODB....
- 5,577
Advice
0
votes
8
replies
147
views
Is there a faster/better way to add a string to all the cells in a table column in VBA?
at the moment I am using this code snippet to add "20" to the beginning of each cell in a table column:
For Each r In Range(TabellNamn & "[Date/Time]")
r.Value = "20&...
- 1
Best practices
0
votes
5
replies
94
views
Saving data within a sheet
I am Creating a logging app to track jobs. After entering a dozen aspects about a job on sheet1 it calculates the overhead and profit of job. There is a checkbox to acknowledge acceptance of the job. ...
- 1
0
votes
4
answers
102
views
Worksheet_Change event fires but Form Control Checkboxes do not update visually
I’m trying to automatically check/uncheck Form Control checkboxes on a specific sheet based on a value change in a trigger cell (e.g., F19).
The Logic:
User changes the trigger cell.
VBA searches ...
Best practices
0
votes
2
replies
73
views
Does Power Query's Table.Profile Treat emty strings (" ") as null/missing values?
Details
I am using Excel Power Query for data profiling and data cleaning. My dataset cntains texts columns where missing values are represented in two different ways:
null
empty strings (" &...
Advice
0
votes
1
replies
65
views
Focus Cell Setting in Web Based Excel Getting Disabled after refreshing
Whenever I refresh my web-based Excel workbook, the Focus Cell setting automatically gets disabled and I have to enable it again manually. Please advise how to permanently keep the Focus Cell feature ...
Advice
0
votes
1
replies
56
views
Open Hyperlink in Front of Excel Tab in Node.js Excel Export
I wrote code in Node.js ( version 10 ) for Excel. The Excel file has a URL column. When I click the link, it opens in the browser, but the browser opens behind the Excel tab, so the user doesn't know ...
Advice
0
votes
0
replies
59
views
How to format fill color of a cell with RGB value stored in the cell?
I need to choose the best match between a target color, and a list of RGB values that are available to me. In order to give the user a visual impression of the remaining color difference, I want to ...
- 71
Tooling
0
votes
2
replies
79
views
I want to find an excel template or formula or script to be able to assign unique id numbers with text letters and consolidate these
would like to assign unique id numbers containing contents of other columns in an excel file. id number would contain text too. automatic id assignment everytime a new entry is typed in the excel ...
Best practices
0
votes
4
replies
115
views
Exporting ~500,000 rows from MySQL into an XLSX file using batch processing
I am exporting ~500,000 rows from MySQL into an XLSX file using batch processing.
Current implementation:
Fetch 10,000 rows per batch
Write each batch sequentially into the XLSX file
3–4 table joins
...
Advice
1
vote
11
replies
231
views
How to load Excel date cell
I'm using OfficeXML4D library for Delphi and when I do something like this:
Sheet.Cell['F2'].AsDateTime := Now;
What happens is that the date will show 2096-05-20, instead of 2026-05-20.
I checked ....
- 29
1
vote
1
answer
93
views
Get Excel Pivot Table to show true if row value exists in column [closed]
I have a Pivot Table that lists account numbers as rows and columns for the dates that the accounts were serviced. I want it to show '1' if the account was serviced on that date and '0' if not. I ...
- 11
3
votes
3
answers
163
views
Match multiple keywords from cell A then return all matches in cell B
So I am trying to create a formula that will automatically match all of the keywords from a source cell with their corresponding ID codes, then return all of the matched ID codes in another cell. How ...
- 201
1
vote
1
answer
81
views
AbstractMethodError on XSSFColor.getStoredRGB() when using custom fill color with Poiji 4.1.1 on classpath
Problem
I'm trying to set a custom hex color (#00458D) on Excel header cells using Apache POI in a Spring Boot project. The only approach that works without throwing an error is using an indexed color:...
- 11
