Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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.

Filter by
Sorted by
Tagged with
0
votes
0answers
7 views

Using selection.find to query database

I'm writing a macro and am not familiar with the intricacies of the selection.find query. Background: I'm trying to check whether a member (sheet 1) holds a first aid qualification (data of which is ...
0
votes
1answer
17 views

Comparing and finding the missing result

I have a program that reads my Excel sheet and downloads an attachment from a website. It is then saved to a specific folder with a specific name that I have name in the Excel sheet. For example, ...
0
votes
0answers
15 views

How to change Office 365 Toolbar Language to English? [on hold]

Whenever i opened Office 365 Word/Excel or power point online the Toolbar language is changed to Urdu. How can i change it back to English(US)?
0
votes
0answers
11 views

How delete blank or “” value in name manager?

How delete blank or "" value in name manager? i have more than 500 column so i block them all and create their defined names, and i cant "Create From Selection" one by one thanks! this is just for ...
0
votes
0answers
11 views

VBA: Consolidation function on array reference (mix of text & number)

I'm trying to consolidate a range of cells from multiple spreadsheets which I know I can handle it with "Consolidate" function in excel. I have a set of cells formulated with texts and number by ...
0
votes
1answer
13 views

Accessing array of floats inside an array of class objects in VBA

I have some probably simple to solve issue with accessing array of floats inside an array of class objects. Inside my Excel document I declare a class TData with some properties like Public weight As ...
0
votes
0answers
6 views

Task Scheduler win32.gencache.EnsureDispatch(Excel)

My script uses Chrome webdriver to log into an online database, query the data, and then downloads the data to put into a pandas data frame. A problem I ran into when writing this script is that when ...
2
votes
0answers
18 views

VBA Macro for use AS400

I want to automate AS400 throug a VBA code. I would make a simple macro that make access to AS400 and insert some text in a fiel. It is possible? I search on internet and i understand that exist ...
0
votes
0answers
15 views

SQL find specific nodes and return their values (json) as excel formatted results

There is a xml column (ArrayOfString) with json string results. I need to find specific nodes and get their value. <ArrayOfstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://...
-2
votes
0answers
13 views

How can i apply multiple filter on different value columns

I have 3 columns A, B & C. A has the store numbers (numbers), B has the Product item codes (numerical codes) and C has its stock levels (numbers). I want to put a first filter on "B" then a second ...
-4
votes
0answers
16 views

User-form to retrieve data in a sql fact-table via a combo box in excel [on hold]

I'm currently trying to build a report whereby reps can utilize a User-form (preferably one with couple combo-boxes) to filter and retrieve data from a fact-table that sits in sql server 2016. I'm ...
-1
votes
2answers
16 views

Word count of a row in excel file using python

I have an excel file with multiple columns. In one column I have different comments. I want to create a column just beside it to find the number of words in the comment columns using python code. Is ...
0
votes
1answer
25 views

Use .Formula to Sum a Changing Range of Cells

I am trying to fill out a table by summing the first "x" number of values then the next "x" number of values. Essentially this: =SUM(Ax:Ay) where x and y are the row numbers Sheets(1).Range("B"+i)....
0
votes
1answer
16 views

Fill a large range of cells with the same formula?

I'm printing formulas to 8000 rows and a set number of columns. I'm using two for loops to print the formulas on the columns. Although the code works, it takes very long to finish. 'N is a value ...
0
votes
0answers
10 views

EPPlus Load CSV and Format All Cells as Text

I am trying to import a CSV and have all cells show exactly how they were sent in via the CSV. Everything actually works great with the converting of the csv to the excel file and I email the ...
1
vote
1answer
22 views

Add chart to excel with data from multiple sheets using python

I have 60+ sheets with same columns (Time,Data1,Data2,Data3)across all the sheets. I would like to plot a xy scatter smooth line plot of time from all sheets vs the other columns with data from all ...
1
vote
0answers
13 views

VBScript that exports a chart as an image

I'd like to export an Excel chart as an image. I have the Excel application, workbook and worksheet objects set up (not sure I need all 3 but it's running smoothly so far). And I am generating the ...
0
votes
0answers
9 views

Paste Excel Range Table below Subheading Textframe then center-align in Powerpoint Slide

I am looping through an Excel Range and pasting the ranges as Tables onto Slides duplicated from a template presentation Slide. The minimal code is as shown below: ... With oPres Set oSlide = ....
0
votes
0answers
21 views

Break For loop and enter results into different table in Excel VBA

Taking results from API and sorting into different fileds, problem is that i have 20 columns returned from API and i want 2 columns with 10 results each. j = 3 For Each result In JSON.Item("results") ...
0
votes
0answers
26 views

Google Sheet to Excel conversion - Treating “” as zero

I need to convert several (hundreds) Google Sheets to Excel. For the sake of tidiness, many cells in the original sheets have "" in them as a result of formulas like =IF(condition is true;calculation;"...
-1
votes
1answer
23 views

What is the correct element ID for this vba code?

I got the below vba code from this site. The code will automatically open the site in IE(will be using different url) and will import files as well. When I ran this code,it did not work due to ...
0
votes
0answers
43 views

Excel - Index-Match with duplicate ids, need row with min date greater than date

I am trying to get the ID associated with a user ID, but the reference table I am pulling from is historical and effective dated. However, I need to pull the MINIMUM End Eff. Date that is GREATER THAN ...
0
votes
0answers
10 views

Apache-poi: Auto set size with merged cells and make the font bold

I'm new to this and just playing around with apache-poi to generate an excel sheet with some mock data, here is my class and I'm struck with few things, any best practices ?? Auto set size with ...
0
votes
0answers
5 views

Python / Excel Sorting binary Matrix columns to identify relationship

In advance, please provide me the link if this question was asked in this form earlier, I could not find the link. I could not provide a code, since I did not know where to start in the first place. ...
-4
votes
0answers
25 views

Loop Function into a Macro [on hold]

I have a spreadsheet, where my data is stored in Columns "A, B & C" for the next 500 rows and from Rows "D - R" just in 1 row Now I have to use that Data and use it in a model which is on the ...
1
vote
0answers
39 views

VBA using Index/Match to find and replace specific values on target spreadsheet

Updating information on an already populated target sheet which contains a particular numerical string in a source sheet. Using INDEX/MATCH I've successfully done this using Excel-VLOOKUP in Vba but ...
0
votes
0answers
24 views

error 91 when counting rows on userForm event activate

I have a UserForm with some inputs, witch some of them are to be populated automatically (like the ID number) when the user enters the excel or to be re-populated when user adds news items, however it'...
-1
votes
0answers
18 views

Excel file-while enabling editing or content, the columns where the formulas are go blank!! What am i doing wrong?

I have tried disabling protected view, trusted locations. I thought it had something to do with circular reference, but does not look like it. The only way it works right now, if I disable everything, ...
0
votes
0answers
9 views

Charting data only if cells in the same row contain specific criteria

So I've been trying to build a couple control charts, but seem to keep running into the issue of "phantom values" that are within the data set, but outside of the criteria set when I use the Index(...
-1
votes
0answers
9 views

Create a website which can show data using the output values of excel VBA form

I have created an excel vba form which I will be using for a blood donation camp functioning as collecting data about registration, donation and rejection of blood. I want a website which can display ...
0
votes
0answers
14 views

Consolidate data from multiple sheets with multiple rows of headers VBA

In advance, thank you for all your help. The task that I have is I need to copy data from two sheets in to "Consolidation" sheet. Both sheets have similar headers, but I only need to keep one set of ...
0
votes
1answer
28 views

Convert Excel Sheet (nested) to JSON

I am giving a spreedsheet and I need to convert into JSON. I have the following spreadsheet as so: In essence, I'd need to convert into like this: { "CompanyA": { "Products": ["Beds", "Knifes",...
-1
votes
1answer
22 views

R Date conversion for multiple data types

It's easy enough to convert Excel dates to R dates with the as.Date() function: as.Date(12345, origin = "1899-12-30") #> [1] "1933-10-18" How do I convert the following to R date class? as.Date(...
0
votes
1answer
26 views

What is the technique to color code a bar chart in Microsoft Excel based on a binary value?

Here is my data set: JAMES 3.32 M JOHN 3.27 M ROBERT 3.14 M MICHAEL 2.63 M MARY 2.63 F WILLIAM 2.45 M DAVID 2.36 M RICHARD 1.70 M ...
0
votes
0answers
24 views

Inserting Image in html body excel vba

I have the following code in my excel vba Open "C:\Templates\en-route_template.htm" For Input As #1 Do Until EOF(1) Line Input #1, strLine strHTML = strHTML & strLine Loop ...
0
votes
0answers
21 views

Parsing JSON in Excel 365 without referencing MSScript control 32 bit

We are upgrading a legacy spreadsheet application to run in Excel 365 64 bit, win 10. The spreadsheet application interacts with a RESTful API through HTTP post, the response JSON is parsed leveraging ...
0
votes
0answers
13 views

SXSSFWorkbook Streaming API: Write rows (createRow)

I'm a bit lost, how do you write rows in the Streaming SXSSF Apache POI API? SXSSFWorkbook workbook = new SXSSFWorkbook(new XSSFWorkbook(in), 100); SXSSFSheet sheet = workbook.createSheet("...
-1
votes
0answers
28 views

VBA loop with refresh [on hold]

I am fairly new to the channel, so please be patient with me if I go again some rules. So what I would need to do is the following: Problem: - range (C1) is the cell where a result of a ...
-1
votes
0answers
30 views

Is there a way to convert a string content into a function? [on hold]

I have a cell in my sheet with the following text: x ^ 2 I wanted to know if is there a way to convert the string into this cell into a formula in module code such: y = x ^ 2 Basically, I wanted to ...
0
votes
1answer
24 views

Populate rows based on calendar-like data

In Excel, I have a table of employees/dates in which employees are at the vertical axis and dates at the horizontal. The table has data about the employees' day offs and vacations shown as "+". I ...
0
votes
1answer
16 views

COUNTIF with variable columns

I have a table that consists of workstations and the software installed on them. It looks something like... <table><tbody><tr><th>endpoint</th><th>software1 v3&...
3
votes
0answers
25 views

Add a Hyperlink to a SmartArt Node

In the Excel (also PowerPoint and Word) user interface it's possible to assign a hyperlink to a SmartArt node, or text in a node: Recording these steps in a macro yields an empty procedure. Trying ...
0
votes
0answers
26 views

Copy paste from multiple sheet to one sheet ( only required multiple columns and set auto filter on consolidated sheet and seprate)

I have three sheets ( Sheet1,sheet2 and sheet5) Need to copy from sheet1 column "A" , "B", "E" paste to " Sheet5 "c","G","H" and copy from sheet2 column "J" , "K", "N" paste to " Sheet5 "c","G","H" ( ...
1
vote
3answers
35 views

R: Is there a way to get a a(b-c) notation when I have the values a,b,c in separated columns?

I have calculated intraclass correlations for certain variables. There are three important values I want to display in a table: Variable name ICC value Lower bound Upper bound I now ...
0
votes
0answers
40 views

Rnd returning 9,49788684981651E-02. Why? [on hold]

Why Rnd returning this value 9,49788684981651E-02 if i set up to random betwen 0 and 1 as double? . . . ...
0
votes
1answer
29 views

Excel count based on multiple columns

How to lookup matching values on multiple columns on excel and return its count? I've already tried pivot table but it does not satisfy my requirement. The data returned by pivot table is in a ...
0
votes
0answers
13 views

Copying Certain Rows to an Email Based on Criteria While Leaving the Original Worksheet Unmodified

I have a spreadsheet used for ordering materials with multiple suppliers. When I have rows expressing a quantity needed, I would like to have a button to run a macro that copies only the rows with ...
-2
votes
0answers
34 views

How Can I create a progress bar in VBA if I am running many macros?

The macros do updates to pivot tables, add some formulas to the sheet, but these ones I don't know how to make an update to the progress bar. If you can collaborate me with an idea to make a goal I ...
-2
votes
0answers
59 views

Creating 0 entries for missing values in a date sequence for a unique set of columns in Excel [on hold]

Description of data: I have a worksheet containing the market size of certain products per month for multiple countries. Example(Row 2): In January 2018(Column B) the market size of Albania for apples ...
-2
votes
0answers
24 views

Formula for difference in time

I have this problem, here. Now in a column A I have the End time and in column C in have the start time. Am bit confused with the non working hours From Sun to Thu it is 13:00:00 hrs -- Non working ...