216,500 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
87
views
Cannot set up multiple worksheet events that all target the same column
I found a great video for VBA to work with timestamps for a poker spreadsheet I'm creating.
The VBA works great. But I need to track mixed games. We may play several out of our 20+ games.
I want just ...
0
votes
0
answers
72
views
Tracking elapsed time for a task in Excel — resume timing after status changes (formula or VBA)
I have an Excel sheet used to measure the time spent on individual tasks. The sheet has these columns:
Task
Start Date (timestamp when the task was first started)
Status (data validation with three ...
2
votes
1
answer
159
views
How do we remake program. The program return error overflow error 6
How do we remake this program?
File input.xlsm result.xlsm is larger than 600 000 records.
Sub Insertdata()
' Define constants.
Const SRC_FILE_PATH As String = _
"\\s-fa\...
1
vote
2
answers
102
views
Row only updates when I change a cell in that row?
I have a macro that works well. Depending on the number of X's and N/A's in certain columns changes the color of that row, telling me that it is either ready or still waiting on something. And some ...
-5
votes
0
answers
82
views
How to get XML node values in VBA? [closed]
For example Xml file, with some data in the following format:
<document>
<data id="maxdates">
<row>....</row>
<row>....</row>
....
-1
votes
0
answers
85
views
Sheet referencing macros return 'subscript out of range error' [closed]
The following series of macros, generally, keep returning a'subscript out of range' error.
The first two (101 and 102) perform as intended, but the others do not and give the error.
Sub ...
0
votes
2
answers
93
views
Worksheet_SelectionChange Causes Clip Board to Clear
I have the code below - Essentially, if the user inputs a 1, 2, or 3 in cell N16, different sheets will show and hide themselves. This all works fine except that the clipboard gets cleared when any ...
-2
votes
0
answers
118
views
Send email when a value exceeds cell value
I want my VBA to send a email when I open a sheet.
I have created this vba code but it doesn't send a mail when I open the sheet.
This is the code I have made so far.
Can you pls provide me with a ...
0
votes
2
answers
82
views
VBA Runtime Error 9 When Copying Sheets From One Workbook to Another [closed]
I'm trying to run some relatively simple code to copy sheets from one workbook to another
ref_sheet = "111"
temp_path = "K:....xlsx"
main_book = "K:....xlsm"
Set ...
-1
votes
2
answers
67
views
Compare two Excel sheets by SKU, Price, and Date Ranges — highlight mismatches
Sheet 1: sell_in
Column
Name
Example
A
SKU
12345
B
Price
59990
C
Start Date
01-09-2024
D
End Date
30-09-2024
Sheet 2: oficial_prices
Column
Name
Example
A
SKU
12345
B
Price
59990
C
Start Date
01-09-...
2
votes
4
answers
141
views
How can I embed a text file in a VBA macro and make the VBA macro create a file with the content embedded?
Is it possible to embed a text file in a VBA macro and make the VBA macro create a file with the content embedded ?
To illustrate:
Sub procedure1()
...
End Sub
Sub procedure2()
' some VBA ...
-5
votes
0
answers
57
views
VBA opening 365 Workbook, need Editable, only can get ReadOnly [closed]
Sub OpenFile()
Dim Open_file As String
Dim sh As Workbook
mSEPriceEngine = "https://mycompany-my.sharepoint.com/:x:/r/personal/<MyAccount>/Documents/test/Pricing%20Model%...
1
vote
3
answers
103
views
How can I check (activate, select) an OptionButton with VBA?
In my excel sheet I put 2 OptionButton objects:
in my VBA macro I added:
Sub OptionButtonDebugOff_Click()
debugmode = False
End Sub
Sub OptionButtonDebugOn_Click()
debugmode = True
End Sub
...
-5
votes
0
answers
112
views
Run time error 70 Permission Denied - Assistance needed
I have the following code which renames, uses and then deletes a file and loops onto the next file in the folder. I keep receiving the above error message. When I step through the issue, there is no ...
1
vote
2
answers
124
views
How to show true string in Access VBA Listbox
I have here a listbox showing data from tbl2026Test table (with ID as its own autonumber) by a simple listbox rowsource code:
Dim statInProg, statPClarif As String
statInProg = "In Progress"
...