289,617 questions
0
votes
0
answers
8
views
Aspose.Cells (.NET) (25.5.0): Error Logging
I was wondering is there a way to configure error logging for Aspose.Cells (.NET). The version I am using is, 25.5.0.
I am facing one issue with an excel workbook that has more than 10 excel sheets ...
- 1
1
vote
2
answers
44
views
Return each unique combination from 2 columns and return other information from the same row
I have a tool I am working on using the latest version of Excel (whatever it is) and I have a table which looks like this:
I want to take each unique combination of values from the Code and POBox ...
- 35
1
vote
2
answers
49
views
How to check if two cells in the same column contain matching text in Excel?
Is there an Excel formula that can detect whether two cells in the same column contain similar or partially matching text?
For example:
F3 contains: "regulation BI, how to stop exploitation"...
1
vote
2
answers
62
views
Problem creating cell output from Date using VBA script in Excel
I'm trying to use VBA to insert a new row and then create a reference using the date in the format yyyymmdd followed by a hyphen and then 1.
So for example, today I would like the output to read ...
- 11
-4
votes
0
answers
46
views
Fetching Data online [closed]
I have a website which is handled by customer and uses that to display customer status about his medical fitness report.
Everyday we have 40-60 clients that we send data to the customer, if I want to ...
Advice
0
votes
5
replies
79
views
Excel conditional formatting: how to format entire RELATIVE columns based on single row value
My question is quite straightforward - or at least, it should be!
I have an Excel sheet with dates and weekdays laid out across the top three rows. I want to highlight all columns in a particular ...
- 1,516
-5
votes
0
answers
74
views
Reading multiple Excel files with multiple worksheets in R [closed]
I have to read around 80 Excel files with multiple worksheets. They are questionnaires that are all formatted the same way and where there is one column for the question, one for the question_id, one ...
- 1
Advice
0
votes
1
replies
102
views
I want to prevent fill and drag in Excel
I want a VBA code to prevent fill and drag in an Excel sheet without hiding the fill and drag cruiser. and without preventing them from advanced settings.
In addition, I want this code to be localized ...
Tooling
1
vote
3
replies
87
views
Convert complex pdf to an excel
I'm currently searching for a solution to read a pdf and convert it to an excel.
For now I found the "tabula-py" library, which seems to be good. But I'm not quite sure because the pdf has ...
-4
votes
0
answers
74
views
Prevent fill, drag and allow single/multiple delete in one sheet of a workbook [closed]
Option Explicit
Private oldAddress As String
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
' Prevent drag fill by breaking the selection extension
If ...
-2
votes
1
answer
136
views
Check if Map Chart drawn successfully or not
1) The following code is able to draw a Map Chart successfully.
Public Sub Macro1()
For i = ActiveSheet.Shapes.Count To 1 Step -1
ActiveSheet.Shapes(i).Delete
Next i
...
4
votes
1
answer
85
views
Export pandas.DataFrame.column.name attribute during pd.to_excel() export
a = np.array(["foo", "foo", "foo", "foo", "bar", "bar",
"bar", "bar", "foo", "foo", &...
- 139
0
votes
1
answer
44
views
How to group time values by hour (not minute) in Excel PivotTable using VBA?
I'm creating a PivotTable in Excel using VBA. One of the fields is a time value (formatted as "hh:mm:ss"), and I want the row labels to show each hour (e.g., 00:00, 01:00, 02:00), not every ...
1
vote
1
answer
120
views
Excel VBA BeforeDoubleClick not working after other code is run
When I first open up the Excel file, as well as after I click on a button to import additional sheets into the file, the BeforeDoubleClick event works (it adds 'ticks' to cells so the user can see how ...
- 159
0
votes
0
answers
98
views
Windows C++ API BackupRead is stuck(?) when trying to fetch all the streams of a file
I am trying to investigate an issue where the Windows C++ API BackupRead, used in our software, appears to get stuck for few files.
I suspected large file streams to be the reason.
I wrote a small ...
- 163
3
votes
1
answer
102
views
Why does an adaptive Image control in a VBA UserForm not render as expected for different diaplay scales?
I have a simple UserForm to prototype the concept of loading different sizes of the same image based on the Windows display scale that the user sets. For this example, I'm just testing with 100% scale ...
- 3,049
1
vote
2
answers
123
views
VBA Excel trying to get a variable defined as Range into Cells format
I'm probably missing something very simple here but, I have cobbled together the following code VBA code in Excel,, mainly from answers I've seen here and this runs OK. However what I would like to do,...
- 31
1
vote
1
answer
72
views
"File not found" copying worksheets into a new workbook
I'm working with a macro designed to copy selected sheets into a new workbook, replace their formulae with values, then resave the file in the same folder as the macro workbook. For the most part, the ...
- 1,244
2
votes
1
answer
57
views
Exporting a VBA module from a SharePoint file
I am trying to export a VBA module from one workbook and import it into another:
Dim ProofName As Variant
Dim sDate As String
Dim CashShN As Variant
Dim wbkSource As Workbook
Dim wbkTarget As Workbook
...
-3
votes
2
answers
159
views
Move Labor Cost Formula from Sheets to Excel
Problem
I have created quite a convoluted formula in Google Sheets that Sheets doesn't seem powerful enough to handle for more than ~80 rows of data, so I wanted to try moving it over to Excel. Seems ...
- 27
3
votes
1
answer
76
views
Change the font color of data labels in a Sunburst chart in Excel
I’m trying to change the font color of the data labels in a Sunburst chart in Excel using VBA.
So far, I’ve tried several approaches over the past two days, but I can’t seem to access or modify the ...
-6
votes
0
answers
105
views
How do I solve a VBA macro problem - automation error? [closed]
I have used ChatGPT to create a macro for moving data from some Excel workbooks to some others. the macro has worked flawlessly until recently. I was suspecting that some update or change in trust ...
- 11
1
vote
1
answer
88
views
How can I Kill Child Excel Process [duplicate]
I am using Microsoft.Office.Interop.Excel.Application
My MyMainFunction() function is executed.
If an unexpected forced termination (a crash) occurs immediately after excelApp = new Microsoft.Office....
- 13
Advice
0
votes
7
replies
110
views
VBA- getting data using partial names
I am working with two different workbooks. WB1=Destination data, WB2=Source. I am trying to do a lookup and match between the wb, using wb2 to find the match in WB1. Once the match is found, copy ...
- 9
1
vote
2
answers
91
views
Excel adding unicode symbol from r csv output
Excel is adding a unicode character to a summary file I save from r as a .csv, where it adds "¬" in front of "±". Is there a way to edit the r script to prevent this?
cola <- c(&...
- 97
1
vote
1
answer
58
views
Excel VBA, is it possible to select column/row range within a table to paste information into, and use torow for it?
I am trying to get data from my data imput sheet into my record keeping table, so I am trying to do VBA code to
1. create new row
2. paste the data in there as value and not formula
I created ...
- 13
Advice
0
votes
4
replies
94
views
How to mark two largest values?
I need advice on how to mark the two largest values among a set of values.
1
3
2
4
FALSE
TRUE
FALSE
TRUE
- 5,611
-6
votes
0
answers
62
views
Strategy for migrating financial controlling analysis from slow Excel files to a SQL database optimized for Power BI [closed]
I'm an accountant working in the financial controlling department. Currently, all our data for month-end closing and financial statements are in Excel spreadsheets, many of which have hundreds of ...
1
vote
1
answer
101
views
Value automatically filled in an Excel Workbook based off of data being entered into another Workbook
I'm looking for a way to have a value automatically filled into an Excel Workbook based off of data entered into another Workbook. I currently have a spreadsheet which serves as a Daily Attendance ...
- 19
1
vote
1
answer
35
views
Excel formula for Sumif and query generation
In my Excel file, I have two sheets. One is named Airjet and contains detailed data with numerous columns:
Column I lists all the months
column Z lists the yarn counts
I want to extract data into ...
0
votes
1
answer
83
views
Prevent a path being added a UDF from a XLAM used in an Excel Template
I have a XLAM file that I installed through the Options -> AddIn Manager and activated in Excel. I also have a template (xslt). In this template I reference a UDF from the AddIn. This works fine.
...
- 665
2
votes
0
answers
179
views
VBA Excel sending email has been "reduced" in abilities
For years I have had code similar to the following, and it has always worked fine.
But now we recently updated to Win 11, perhaps it is related or there is some other update or policy change that ...
- 24k
1
vote
2
answers
77
views
How to store number as a text while exporting from pandas to excel
I have a DataFrame that contains an A/C number column, where some values are longer than 15 digits. When I export the DataFrame to Excel using .to_excel(), Excel automatically converts these long ...
- 21
Advice
0
votes
2
replies
116
views
Excel VBA SQL Insert or Update Data in closed workbook
I use SQL to read data from a closed workbook. Is it possible to write new records or updates to a record in a closed workbook using SQL?
- 27
0
votes
2
answers
92
views
Excel Macro Loop. Looking for code to loop through entire workbook
I am new to making macros and have basically no experience with VBA. However, I have managed to cobble together the code below.
The code is supposed to load data from a worksheet (the name of which I ...
4
votes
3
answers
136
views
Connecting to Excel from PHP using PDO
I am connecting to an Excel file from PHP via PDO. When executing a query, Excel returns data, but it defines the first row of results as column names. How do I make Excel return all rows, including ...
Advice
1
vote
3
replies
117
views
COUNTIFS - Excel Date Matching
Simply, I have two values to lookup
1st is a name as "A"
1st is a date that I should look for its month given as "9/1/2025"
Apparently, I used these values as conditions in a ...
- 17
0
votes
0
answers
71
views
Excel XLTM template stopped showing all data after reopening — is it possible to recover entries typed into a template? [closed]
I created an automated weekly MOT log for my workshop using Excel.
Originally, my data was stored in a normal workbook called Data Sheets MOT.xlsx.
Later, I added VBA code to automatically create ...
- 11
-1
votes
1
answer
46
views
Pivot Chart Showing Only 'Left' for card vs. no card [closed]
I'm making a chart in Excel. I have a pivot table and I want to create a column chart, but on the chart I only want columns for Card and No Card for Left, because right now it also shows data for ...
- 21
0
votes
4
answers
135
views
Using PowerQuery to extract particular record from a column to another column
I'm trying to extract particular record from a body column and update into separate columns using PowerQuery.
Scenario: I'm fetching records from Microsoft Exchange into an Excel file, separated into ...
- 149
1
vote
2
answers
145
views
Trouble with VBA Class Instantiation [closed]
I've created a VBA Class module and written all the necessary code within it. When I go to use it, in Excel, I instantiate it in a global module as follows.
Public gblFrequencyList As New clsLists
...
- 153
-2
votes
1
answer
95
views
How can I move rows or columns through merged cell ranges without splitting the merged cells? [closed]
I have procedures that automate moving entire rows and columns across the worksheet using buttons on the Quick Access Toolbar.
However, when trying to move rows or columns through rows or columns ...
1
vote
2
answers
86
views
How do I save a file as a specified cell value, then clear content of all unlocked cells, then close the file, then open another specific file?
I tried the below, but it is not doing exactly what I need it to. Instead of unprotecting the sheet and clearing the contents of grey cells (191, 191, 191) I'd like to change the approach and clear ...
- 11
2
votes
1
answer
57
views
How can I get the width/height of a shape? [closed]
I'm trying to do something very simple.
I have a basic Excel Spreadsheet and I've drawn and formatted a simple shape (rectangle).
I want to let the user move/resize this shape as they wish, and when ...
- 21
1
vote
0
answers
114
views
Transferring data from one Excel workbook to another with ADODB.Connection reformats dates
I set up an event listener in Outlook that, when a certain item drops into a mailbox, will take the attachment from the email, unzip the file and save it into a directory.
I use ADODB.Connection to ...
- 279
4
votes
2
answers
160
views
Excel VBA Type Mismatch on Row Delete
I have a "simple" comparison that is generating a "Type mismatch" error when I delete a row in the worksheet (worksheet change event fires).
If Target.Column = gblScheduled And ...
- 153
2
votes
0
answers
113
views
#NAME? error when opening an Excel sheet via Powershell
I am trying to export Excel files to PDF. Since there are a lot of Excel files to be exported I'm trying to automate this via PowerShell. In principle this works fine, but some Excel files contain ...
- 71
2
votes
1
answer
71
views
Assign the value of a Level to all its Sub-Levels
I have an ordered list in Excel, as shown below.
The list consists of a bill of materials organized by levels. There is a Level 1, the equipment itself. Within Level 1, there are several Levels 2, ...
- 33
0
votes
0
answers
48
views
Office Scripts manual filter on pivot tables failing in browser excel version
I've used the below Office Script code successfully in the past to apply a manual filter against a filter hierarchy in a pivot table using office scripts. The below works in the app version, but it is ...
- 3
2
votes
3
answers
100
views
Skip invalid inputs when finding Min and Max values
I'm working on a VBA problem to find the maximum and minimum values in a sequence while skipping invalid inputs.
The issue I'm facing is that when the first value in the sequence is invalid, the ...
- 21