Questions tagged [excel]

Only for questions on programming against Excel objects or files, or complex 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. General help regarding MS Excel for single worksheet functions is available at Super User.

0
votes
0answers
7 views

Generate dates between range in Excel

Is it possible to automatically (without user interaction) generate dates between two that specify range? Let's say that we need to insert start and end date in two cells, and that Excel autofill all ...
0
votes
0answers
9 views

Use xlsxwriter to color the content contained in a row, but not lock the color to that row number?

I'm using python with the pandas and xlsxwriter modules to format an excel file that is generated dynamically. I need certain rows to be colored yellow, depending on the content of one column. Here is ...
0
votes
0answers
7 views

How to prevent “Data mismatch” exception when OleDbDataReader reads multiple data types from excel? (General, Date, Time, Percentage etc)

I am working with excel and C#. I am trying to retrieve data using OleDbDataReader and print "something" if the "if" condition is met. The if condition works fine when the values in the excel cells ...
0
votes
0answers
6 views

Is there a way to create the same dropdownlist over multiple excel sheets, selectable from any sheet, affecting all the other

Is there a way to create Drop down lists in multiple sheets referencing the same list (doesn't matter where it is stored). Once the user has selected something from Sheet 1 drop down, when he browse ...
0
votes
1answer
18 views

Excel Count Distinct where other columns match and sum of another column = 0

I need to answer the question of how many parts were successful by counting the distinct Part Labels where PartName matches, and the sum of LabelFailures = 0. PartName | PartLabel | LabelFailure -----...
0
votes
1answer
23 views

How do I compare two columns for matching and non matching values and get it in the format that I want?

How do I find matching and non matching values between two columns and format it in the below manner? Input: | expected | match | forward | backward | actual | |----------|-------|---------|---------...
0
votes
0answers
10 views

Why doesn't the grand total in this power pivot table sum all columns correctly?

For some reason, the grand total here does not sum both columns. Any idea what could be the problem here? This was created via a tabular project / model in Visual Studio. I have no idea how to ...
0
votes
0answers
16 views

Merging and cleaning up csv files in Python

I have been using pandas but am open to all suggestions, I'm not an expert at scripting but am a complete loss. My goal is the following: Merge multiple CSV files. Was able to do this in Pandas and ...
0
votes
0answers
15 views

How to add (sum) items in two columns

I have two columns with a list of Vehicle Types, I want to be add each type of vehicle in both column and display the total number of each vehicle type. I have tried a pivot table but not sure how to ...
-1
votes
0answers
12 views

Excel - SUMIFS + INDEX + MATCH +SUBTOTALED (Filtered) DATA + MULTIPLE CRITERIA

What is the proper function to calculate sales (by month) on subtotaled (filtered) data (shown below) with 2 different criteria in a column and row? Criteria #1 "VV" Criteria #2 "September" Attempt ...
0
votes
0answers
20 views

Which format of the url is correct while using an api with xml

When I try to access common/example api url with vba (excel), there is no problem. The required URL is as follows: "hppts://user:password@www.site.com/events/" When I copy the url in web-browser there ...
1
vote
0answers
14 views

VSTO add-in: Reference in the manifest does not match the identity of the downloaded assembly

I have developed an VSTO add-in for Excel in C# as a Class Library. The add-in takes a third-party .exe as a reference. The sole purpose of the add-in is to exploit the functionality of the referenced ...
0
votes
1answer
25 views

VBA for loop only returning one value when there are more that meet the criteria

I am trying to transfer stock transactions from a transaction workbook to another book that has the formatting i want. I want to be able to change the client name and stock at the top of the code so ...
0
votes
2answers
47 views

Trouble Passing Array Values

I have a sub that fills an array with a list of user defined values from a fixed range in my spreadsheet. I want to call this sub from another, and utilize the values in the array to drive a For Each ...
-1
votes
0answers
24 views

Vba sumif function incorrect value

I am trying to loop through a worksheet, and perform a few calculations one of which dividing the sumif of one range by the sumif of another. One of the sumif's involves me summing up all the ...
-1
votes
0answers
10 views
0
votes
1answer
33 views

Excel VBA - Determine if a Module is included in a project

I am currently working on a project where I am unable to verify that all modules are installed. There is a growing group of modules being used for common functions for programs I work with. I have ...
0
votes
1answer
13 views

Alternating colors for consecutive groups of events in Excel

I have an excel table that looks sort of like this: I need a way to automatically alternate the row colors. As it stands right now, I have a large list of data that looks like that, but with no ...
1
vote
1answer
27 views

How can i left-align a whole row with numbers

I have a listbox full of numbers. I am exporting these values to excel but I Want to left align the the numbers in each cell. Every time I try this my program crashes I tried to add an extra row of ...
0
votes
0answers
7 views

Syntax for Label/Value Filters in Excel Pivot Table

I have a pivot table in excel and one of the columns of that pivot table has blank cells that I want to exclude. I essentially want to figure out a way to exclude them from that column without using ...
2
votes
0answers
26 views

How to get dependent drop-down lists to work in exported workbook?

I'm still reasonably new to VBA and feel I'm punching a little above my weight, so hopefully someone can help. I need to issue a spreadsheet to people in my company which they can fill out and send ...
0
votes
1answer
18 views

Pull text from another cell into an INDIRECT formula

I'm using the INDIRECT formula to extract data from specific cells in hundreds of different sheets. In column B, I've listed all of the cells I need data from, and the worksheet names are in row 6. ...
0
votes
0answers
17 views

MS-Access Automatically updating data based on another table (Email Blacklist)

I'm setting up a brand new database as a lot of the work we do is on multiple spreadsheets and a lot of the data is duplicated. I have a lot of knowledge with Excel, however, I feel that Access would ...
0
votes
3answers
21 views

Need to color five different cells to the right of a cell if a condition is met for a specific range of cells

I am new to VBA so any help is greatly appreciated. For a specific range of cells, I have if statements. So for A25:A31 if cells.value = 1 then I want cells (x,4) (x,7) (x,10) (x,13) in that same ...
0
votes
0answers
12 views

How to clear datagridview in c# for displaying another file?

I am building an application in which i'm displaying an excel file in datagridview. I've given display button for showing data. My problem is once I click button, it works fine but after my second ...
0
votes
2answers
32 views

Exit from a “Find” infinite loop

I have created a Do Loop with Find to replace "Hello" with "Hi" inside column A of Sheet1, but only if the string "XYZ" is not in the same row of column B. When Find does not replace "Hello", because ...
0
votes
0answers
7 views

Azure read Excel Online document in Azure Function

I want to create an Azure Function that connects to Logic Apps that will be used as an Add-in for Excel Online. I want this Azure Function to read the Excel online file as a blob. How can I do this?
0
votes
3answers
32 views

excel vba - returns two value, passing one input parameter

This is the case: I need to have two values back from a function: this function needs an input parameter to works. strTitleName: input parameter sName: output paramter sScope: output paramter ...
0
votes
0answers
28 views

Is there a way to override cursor behavior through winapi in VBA?

I'd like to change the cursor image while my excel macro is running. I managed to change the cursor through these winapi functions : SetCursor and LoadCursorFromFileA. Here is an example : Option ...
0
votes
1answer
38 views

Macro VBA code runs fine when running independently but becomes broken when run in a string with other macros

I have a string of steps I turned into one macro. When run independently they are all fine but something happens on step 18 when it is run collectively that is causing a problem where the "place I am ...
0
votes
0answers
9 views

How to get Header / Footer parts from Excel Document

I'm trying to get the header / footer parts from an excel document so that I can do something with their contents, however I cannot seem to get anything from them. I thought this would be pretty ...
0
votes
0answers
10 views

Can't get my code to work within glob loop?

I have to update 1 particular cell value of the same sheet, from about 600 .xls files. Using xlwings library i have been able to replace values of a cell on a sheet and save 1 workbook. I now need to ...
-1
votes
0answers
21 views

I need to know how to select a specific cell value based on an indexing variable and a column name

I am trying to loop through a column of dates and search through only dates that fall into a user specified range. From there I have a nested loop that I want to select rows that match a certain ID ...
0
votes
0answers
6 views

how to export longblob images to excel from a datatable?

I want to export to excel some images that I have stored in MySQL with longblob format. I already have the export to excel from a datatable and everything, but I can not make the images appear. This ...
0
votes
0answers
17 views

Returning multiple string values using index,match on multiple criteria

I have a google form populating an ever-growing spreadsheet from which I would like to generate an overview sheet as a daily report. Here is an excerpt from "Form Responses 1" I am successfully ...
0
votes
2answers
22 views

Select specific column base on a cell value

enter image description hereenter image description here I'm trying to select column "H1" to "x"(x = 5 or x = 7) columns to the right, but I want for the selection to change based on a number in a ...
0
votes
2answers
15 views

Copy & Paste of code won't copy the data validation formatting from the cell I'm copying

I'm trying to copy & paste data with VBA and to maintain the data validation in the cell, but my code is giving me errors. Here is what I have Sheets("INITIAL").Activate Range("aa8:ah8").Copy ...
0
votes
2answers
21 views

Referencing formula for row number in Excel Macro

I'm attempting to make a macro which will autofill a number of pages based on how many is actually needed. Each item, imported from another workbook, would receive its own 'page'. These pages are on ...
0
votes
1answer
10 views

Dynamic chart in Excel that show user-selected time series

I'm trying to create a chart in Excel (without VBA) where the user can select which time series are shown in the chart. My issue is that I can't figure out how to do this without VBA. For example, I ...
0
votes
1answer
14 views

VBA Shell command with variables and spaces

In a Microsoft Outlook macro, I'm trying to use a Shell() call to open an Excel spreadsheet (whose filepath is referenced by my templatePath variable). I keep getting syntax errors from the editor and ...
0
votes
0answers
11 views

Error in loading DLL during missing reference removing

I need to fix (by vba excel code) error incurring by missing reference. I use this code but the script stop with the error "Error in loading DLL" when find the missing reference and try to remove it. ...
0
votes
1answer
13 views

Define variable to set dynamic location and filename of a pdf to look for an open

I am attempting using excel vba to shortcut a regular process, in which a user will find a specific pdf, and open it to allow some updating using a pdf editor. The filename is specified in an excel ...
0
votes
1answer
23 views

Excel VBA Form control: Opening/creating an Excel file

I'd to create check if a file is exists using the shipNo and FilePath. If not, copy master.xls and rename the file according to shipNo. In all cases open the file afterwards. Private Sub ...
0
votes
0answers
17 views

How to assign a format from a template MS Excel file to a cell in an Apache POI XSSFWorkbook?

In an Apache POI XWPFDocument (Word) I use this code to assign the user defined format MyHeadline to a new paragraph. MyHeadline is contained in template.docx which was created with LibreOffice. ...
0
votes
1answer
33 views

Skipping Do While loop because Dir function doesn't recognise files

I am aiming to split out all the worksheets of my workbook, save them as individual files and then, to each new workbook, add a Guidance worksheet (guidance worksheet is the same for all workbooks). ...
0
votes
1answer
16 views

How to Monitor SheetChange in VBA across a range and not just on a cell with a dropdown

I am after creating a dropdown on cells in a column. When one particular option is selected I would like to do some actions. I can do this on one cell but not on a column of cells. So I wish to change ...
0
votes
0answers
19 views

How to query values only from Azure Blob Storage with Excel Power Query?

I am trying to query some chatbot data from Azure Blob Storage with Excel Power Query. Unfortunately, Excel cells not only contain the value but also the key in each cell. This is some sample content ...
0
votes
2answers
31 views

Excel: Dynamic formula for change unit size in KB, MB, GB, TB, etc… Automatically

How to correct the formula to be dynamic for all units KB, MB, GB, TB, etc ... It works perfectly for MB and GB but does not work for other units. my formula is: {=IF(SUM(IF(ISNUMBER(VALUE(LEFT(A1:...
0
votes
0answers
23 views

Send reminder emails to users by date and time of the day - Automatically

I have a activities checklist of 1000 above - Each line having different time and date as a deadline. multiple Users will perform activities which is responsible for them. Through VBA email to ...
0
votes
0answers
21 views

VBA in Office 16 not allowing 'Object in ObjectCollection' construction: Why?

I was recently migrated from Office 13 (stand-alone, 32-bit) to Office 16 (Office 365, 64-bit) and one of my existing Excel macros—which accesses Outlook and counts the number of active reminders in ...

http://mssss.yulina-kosm.ru