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
287,978
questions
-1
votes
0
answers
11
views
A button triggered dialogue system to input Product Type and Variant Data into predefined and incrementing cell locations
starting out in Excel VBA.
for context of the following problem:
A Product is a type of toy car: Sport, Bus, Pickup, etc
A Product Variant is a colour the toy car is available in: Blue, Green, Yellow,...
0
votes
1
answer
15
views
Python xlwings slow Execution when scanning Excel Sheet
I'm a beginner at Python.
This code is for scanning Excel cells by range using xlwings however the process is very slow.
I strictly need to use xlwings since it can retain my images and shapes unlike ...
0
votes
0
answers
32
views
Excel VBA: Display a "MsgBox" to see the current state of a ribbon checkbox
I'll try to explain this problem as simple as possible. So I have created a checkBox through the Excel.officeUI file located in "C:\Users<your_username>\AppData\Local\Microsoft\Office" ...
-1
votes
0
answers
12
views
Document not saved error after running VBA macros
I am facing an issue with an excel file that contains various macros that do changes to the workbook such as (adding and removing worksheets, creating content based on data available in the file, ...
0
votes
0
answers
15
views
Date Object dont recognize a string using XLSX
I'm using XLSX package to read an excel file and for some reason some Date Objects are Date and others are string.
I'm using this line to define cells as Date type.
const workbook = XLSX.read(buff, {...
0
votes
0
answers
28
views
Linking a text box with a calendar date box
I am trying to create a calendar in Excel. I am trying to link the boxes with the text in up to the ones with the dates so it doesn't become misaligned.
I currently have my date boxes as =WORKDAY(...
-1
votes
2
answers
19
views
Trying to hide rows in excel based on two values
i am trying to hid rows in excel between a row with value "P1" in column B and a row with value "P2" also in column B. i have tried, to my own shame i used Chatgpt for a part but i ...
-4
votes
0
answers
18
views
What can RPA (Uipath & VBA) do with ChatGPT? [closed]
I am an RPA Developer, primarily using UiPath and writing VBA.
I want to know how ChatGPT or any generative AI can assist in this line of work.
How do developers typically use it?
Also, I'd like to ...
0
votes
1
answer
21
views
I have trouble shifting values from one cell to another when data is added to the table. VBA code isn't optimized
I have two tables in excel, one named "Calendar" and the other one is named "PlanTable".
The left table is Calendar, the right is PlanTable.
What I am trying to do is to calculate ...
1
vote
0
answers
22
views
use SQL query via Power query to inquiry a different excel spreadsheet
I have an excel spreaadsheet (ExcelData.xlsx) that contains a table named "tblTransactions".
I would like to understand if it is possible (and if so, how) to use a SQL query (through Power ...
1
vote
2
answers
35
views
Looking for a VBA solution: How to Selectively Copy and Save Worksheets based on Worksheet Titles
My organization publishes a weekly report in Excel format containing over 60 worksheets, each titled with an activity abbreviation. I am interested in specific worksheets only. Currently, I manually ...
0
votes
1
answer
13
views
Click a div class on Selenium VBA, no button
I'm trying to click on a specific place in a web site using Selenium from VBA
This is part of the snipped HTML that I want to click:
<li><a href="" id="sourceResults-nextPage&...
1
vote
1
answer
27
views
Change Output Value range M2:V2 is not as desired
Please help, how to change the destination results to only be in the range M2:V2.
Private Sub CommandButton2_Click()
Dim rng As Range, j As Variant
Dim StartV As Long, EndV As Long, i As Long
...
-2
votes
0
answers
28
views
Creating a new sheet within a workbook every time the script is ran with Openpyxl/Pandas - Python [duplicate]
I'd like my script to be able to add an extra sheet in an existing workbook with Openpyxl, and then Pandas to write data into that new sheet.
Below is what i have
file_name = 'Numbers.xlsx'
wb = ...
0
votes
0
answers
11
views
applescript excel saving range as PDF
i have the following applescript code to save the range of a excel sheet as a PDF document:
tell application "Microsoft Excel"
set pdfMaker to POSIX file "/Users/me/Documents/...