Questions tagged [excel]
Only for questions on programming against Excel objects or files, or formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable. Do NOT use with other spreadsheet software like [google-sheets].
excel
76
questions
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&...
- 13
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 ...
- 1
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 ...
- 3
0
votes
2
answers
29
views
Sum values based on XLOOKUP
the table below shows a list of employees and number of hours they have worked in that week. I am trying to come up with formula that would return the total number of hours worked per employee per ...
- 49
0
votes
0
answers
24
views
excelWB.write(fileOut); gives IllegalArgumentException
I am trying to use an excel to write the into new file using Apache POI. This is the method code,
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import ...
- 1,988
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.
...
- 11
0
votes
1
answer
13
views
PHPSpreadsheet, how do I set different layout for each series in a composite graph?
I am trying to create charts in excel using the PHP library PHPSpreadSheet. But when I generate a composite graph with multiple types of graphs together, I get overlapping data labels.
Stacked bar + ...
0
votes
0
answers
45
views
Why data that are being written to excel are not starting from the 'A' column?
I'm using pandas to copy data from one excel to another and the data are being copied just not at the right place.
I have this function that reads the data:
def updated_file(self, progress_bar):
...
- 474
0
votes
0
answers
18
views
excel found a problem with one or more formula references in this worksheet in a new workbook after only inserting one table
I created a new excel workbook and inserted one table. When I fill in a cell in the row below the table then due to autoexpansion the table is expanded with one row. Exacty how it supposed toe work.
...
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 ...
- 235
-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
1
answer
25
views
EXCEL Sumproduct COUNT 2 AND condition every nth COLUMN, counting blank and not blank
Good Day to all! as my title suggest I am having a problem with the sumproduct formula to get the result that for the following condition
Check and Count every 4th column range for NOT blank ...
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....
- 1
0
votes
0
answers
23
views
Compile Error when opening an Excel spreadsheet from Access
I have various routines within an Access database system that open Excel, open a workbook, make changes before saving it, closing it and quitting. Basically, I use this code:
Dim objExcel As Excel....
0
votes
2
answers
33
views
Progress bar in vba
I'm working with a macro that takes a long time to execute (>1 min) and I want to improve it by adding a progressbar.
I've followed multiple tutorials that all say to create a userform, add an ...
