All Questions
162,066
questions
0
votes
0
answers
7
views
Excel VBA - Read/Write to text file, keep special charters but don't change the BOM
It looks like the original file has a BOM already but my VBA breaks it.
The text "" or HEX "ef bb bf" is at the start of the file when viewed in Notpad++ with the HEX add-in. ...
0
votes
0
answers
8
views
How can I use vba to insert a row below each row that contains "2024" in a specified column, and in that new row enter "2025" in same column?
I am downloading sales history from ERP system and want to add a row for next year's forecasting.
ERP export image:
..as text:
Employee.Employee Company Product Year Jan Feb Mar Apr May Jun Jul ...
0
votes
0
answers
15
views
excel vba test a value if exist from sheet1(carnet) in sheet2(stock) and return it in sheet3(liste)
i have made this code and when i test the if statement by this condition below it works
`If crnt.Range("E" & i).Value <> stk.Range("A" & i).Value Then`
...but when i ...
0
votes
1
answer
21
views
Preventing Excel Ribbon CustomUI IRibbonUI variable from 'losing state'
We have a custom UI with two added ribbons in our Workspace Environment. This CustomUI has an OnLoad event that loads the Ribbon's pointer variable into memory for access later. Unfortunately, there ...
0
votes
0
answers
23
views
VBA to determine remote desktop user
I would like to use VBA (64bit) to determine if a user is running VBA/Excel from a remote computer. For example, if PC#1 uses Chrome Remote Desktop (CRD) to remote login to PC#2, the VBA code on PC#2 ...
0
votes
0
answers
15
views
Accessing a sheet from a different workbook [duplicate]
I have 2 workbooks, one hidden and one the user can see.
The hidden workbook contains all the code (including the line below)
Note: codeName is the code name of a sheet in the active (non-hidden) ...
0
votes
0
answers
29
views
Average of Conditionally Formatted cells by color
I have a dataset (below) in excel that is conditionally formatted using the excel pre-set GREEN-YELLOW-RED color scale. What I want to do is find the average based by color of cell...and the whole ...
0
votes
0
answers
46
views
Passing an array of objects from C# to VBA Excel
I have a C# console application and Dll. I registered the dll as COM via interop. I used the
COM Visible property, GUID etc
Set Assembly Information, Build information to register it to COM
I ...
0
votes
2
answers
33
views
VBA Hlookup multiple rows
I'am trying to use HLookup with vba, but when i try the vba code i can't apply it to multiple rows, it can only be used for single rows "J2", i need HLookup vba code for many rows "J2&...
0
votes
0
answers
31
views
VBA Different cells accourding to the ComboBox Value
tPrivate Sub CSave_Click()
On Error GoTo ErrorHandler
' Variable Definition
Dim lr1 As Long, lr2 As Long, lr3 As Long, lr4 As Long, lr5 As Long, lr6 As Long
' Last Row ...
0
votes
1
answer
27
views
Excel VBA skip empty cells
I have a code to select a specified range and paste it into an e-mail. I would like it to skip copying blank cells within the range and paste only the cells that contain data. The specified range ...
0
votes
0
answers
63
views
Copy File Names to Destination File
Hope all good with everyone.
I am trying to copy/paste file name to my destination workbook's column A. Below is copying data from all workbooks from a folder and pastes them to my masterfile.
...
0
votes
0
answers
24
views
DoEvents whilst a Time Delay Macro is running
I have a Macro in an excel sheet that selects a value in a slicer, I had a pivot which was converted to OLAP. When selecting a value in the slicer there is a short period of time where all the cells ...
-1
votes
0
answers
18
views
How to save data from SAP in Excel file with VBA code [closed]
Could you please help me with a VBA macro command to save the content of a generated report to my computer with a specified name? Thank you!
This is what I have until now:
Sub RunSAPScript()
'...
0
votes
0
answers
23
views
Export Excel table to ppt
I am editing a macro to export the selected table into a ppt slide. However, I am struggling with the code (it makes my laptop app crashes) and I was wondering if anyone had a better way of proceeding....