105 questions from the last 30 days
Best practices
0
votes
0
replies
46
views
What is standard practice for handling VBA fixed-length string data in binary files?
I'm quite frustrated trying to write to a binary file in Excel VBA. The issue is with fixed-length string data in a Type structure. (Note that my binary file requirements are that fixed-length string ...
- 153
-3
votes
0
answers
35
views
MS Excel Web Add-in - Rollout via MS 365 Admin Center
We have developed a ReactJS based Excel Web Add-in, which we are rolling out using the Microsoft 365 Admin Center. The steps that have worked for our Admin Center, as per our IT department (Office 365 ...
- 107
3
votes
1
answer
67
views
Trying to populate a list from another sheet by a single reference number
I am working on a handy reference sheet for my DnD Games, that includes 10 pre-planned encounters of varying difficulty that I want to reference on an Initiative Sheet by referencing the Encounter ...
2
votes
3
answers
143
views
Excel VBA Code doesn't insert and Paste Values to a protected sheet
Sub ShopeEntry()
Sheets("Entry").Select
Range("D5").Select
If IsEmpty(Selection.Value) = False Then
Sheets("Entry").Select
Dim ...
- 39
Best practices
3
votes
12
replies
177
views
SpellNumber Simplified Using LAMBDA() function
Here is the custom function to spell number to words using LAMBDA(). I would appreciate any improvement of the function or simplification if possible. Also suggest best practice for the function.
=...
- 38k
0
votes
0
answers
51
views
I need to stop a tab from being exported. Is there a Workbook BeforeExport similar to BeforePrint?
I have managed to stop a tab from being printed using the BeforePrint... I now need to prevent the File|Export from firing for the same tab. Is there something like the code below to stop FILE | ...
0
votes
1
answer
90
views
Excel INDEX MATCH with single row and multiple columns reference
I need to find openings in a group of people's schedules because I can't merge them easily with any native web program we use the calendars in. I will be looking at each person's calendar at a time ...
-1
votes
0
answers
126
views
VBA to send email to a range of addresses, changing subject and body [closed]
I am looking to create a macro that will email a range of addresses as per the following criteria:
Column A contains email subject
Column B contains email addresses
Column C contains email body
...
- 1
1
vote
2
answers
80
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
1
answer
77
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
-5
votes
0
answers
83
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
Tooling
1
vote
3
replies
92
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 ...
-3
votes
1
answer
168
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
...
0
votes
1
answer
45
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 ...
0
votes
0
answers
126
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 ...
- 173
1
vote
2
answers
147
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,...
- 33
2
votes
1
answer
60
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
1
answer
81
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 ...
Advice
0
votes
7
replies
112
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
1
answer
61
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
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
0
votes
1
answer
87
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
1
vote
2
answers
78
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
0
votes
2
answers
95
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 ...
Advice
1
vote
3
replies
123
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 ...
- 39