24 questions from the last 7 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 ...
