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
288,129
questions
0
votes
0
answers
15
views
Best practice approach for dynamically loading and referencing large datasets
I have an analysis framework which operates on large datasets loaded from other workbooks. The sets comprise headered columns each containing a single metric, with multiple columns on each sheet and ...
-2
votes
0
answers
20
views
Create Pivot CHART in excel VBA [closed]
Im learning VBA. Not for a class, just something to spice up my excel skills. I want to make a pivot chart. Not a table, just a chart that will produce a total and then add slicers. Ive googled and ...
2
votes
4
answers
56
views
Using Excel O365, How to use unique on two columns, sort, and copy over related data?
I have a 4 column, dynamic row array with names, process, order #, and dates. The array is dynamic and being collected using FILTER() function and grabbing the 4 columns I want from a table on a ...
-1
votes
2
answers
43
views
Function as variant in for loop return "Object required" Error
I try to make cell A1, A2, A3 = aa
using code below but getting error "Object required".
Public Function cellv(ByVal row As Variant, col As Integer) As Variant
cellv = ThisWorkbook....
2
votes
1
answer
32
views
Content is out of order when using excel VBA to create a word document
The aim is to copy data from an excel table into multiple different tables on a word document.
The code should take the title from the 1st column, then use the other columns to generate a table. The ...
0
votes
1
answer
30
views
Excel Button for a par sheet
I am struggling with my excel spreadsheet. I take a weekly inventory of items and subtract it from a needs list to create orders for the week. My coworker does it manually, but I decided to assist by ...
0
votes
1
answer
41
views
Confusion with Application.InputBox types
I've read over the Microsoft explanation of Application.InputBox as well as some other websites, and from what I understand, type:=8 should return a range value, but only if you select multiple cells. ...
0
votes
1
answer
33
views
python copy excel conserving exactly the same parameters in the doc (style, cells size and fusion, borders...)
I am looking for a method to copy and excel in an other file. I have a 'file_1.xlsx', and I would like a 'file_1_copy.xlsx' that is not existing. The copy has to be exactly the same that the original ...
0
votes
0
answers
27
views
Copy certain cells from one sheet to the next based on criteria, then delete source
I have 2 sheets - "Current" and "Archive" on the same workbook.
My intention is to
shift certain cells from "Current" to the next available row in "Archive" ...
0
votes
2
answers
48
views
VBA in excel stops executing automatically when sheets are switched
I created a simple countdown timer in Excel
and below is the code
Public interval As Date
Sub timer()
interval = Now + TimeValue("00:00:01")
If Range("I3").Value = 0 Then ...
0
votes
0
answers
22
views
VBA Wait to confirm logging in the web page
I wrote a code to direct a user to a login web page and now want to identify if he/she logged in successfully just by page's own login form after clicking "Enter" button, then when a new ...
0
votes
2
answers
53
views
How to count the number of cells in a range that has been named with the Dim statement in VBA [duplicate]
I am trying to figure out how to use things like .count with a range that I have stored as a variable in VBA
I have made the following function which works
Function test2() As Variant
test2 = ...
0
votes
0
answers
35
views
Unable to Locate "Sheet1" in Excel File When Using pyodbc to Insert Data into MS Access
I'm trying to insert data from an Excel file into an MS Access database using pyodbc, but I keep encountering an error stating that "Sheet1" cannot be found in the Excel file. Here's my code:...
0
votes
0
answers
28
views
Python Error : [42S02] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine could not find the object 'Sheet1$'
For some reason with what I am trying I cannot get to find the excel Sheet1. Here is my code:
filename = 'ALC_2022068_06282024-testing copy.xlsx'
sql = r"""INSERT INTO tblALC_test ([...
2
votes
1
answer
45
views
Algorithm for adjusting formula excel from original cell to destination cell
I am trying to parse formula in excel with 3 params: Formula, original cell address, destination cell address.
Example, with some rules:
Formula
Original Address
Destination Address
Result ...