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
1answer
18 views

Change part of an excel forumla to include data from another cell

I am looking for an easy way to replace part of a formula in Excel. I have to do this for over 66,000 formulas every year. Currently i use Find & Replace to speed up the job but it still takes ...
0
votes
1answer
15 views

How to get rows having sum equal to given in SQL

**Table A :** **Table B:** ITEMCODE Total QTY ITEMCODE Qty A 100 A 25 B 50 A 75 C 75 B 10 D ...
-2
votes
0answers
13 views

How to import all date from website to excel [closed]

The source:url I did Select Data > From Web, but some content doesn't imported.
0
votes
1answer
18 views

is it possible to incorporate JavaScript or Python code into a previously existing VBA database? if so how? [closed]

So I'm working for a monastery at the moment and they've built their entire database in Excel and through that, Visual Basic. They want to know if it's possible to use JavaScript or Python to make ...
0
votes
0answers
18 views

computing from one sheet and appending that in next sheet using pandas

I have 2 excel sheets. I have constructed 2 data frames out of that. From one sheet, i do sum up based on one column. that is, In that sheet, more than one row of data for a specific site, where rows ...
0
votes
0answers
21 views

VBA More effective way to trim data [closed]

My code consists of split, Mid,Left,Right and replace functions which is used to trim my data into a more neat manner, however it's too long and inefficient, it takes too much time to go through all ...
-1
votes
0answers
13 views

How do I make my excel spreadsheet take an un-organized column and group it into several small lists with a formula?

So I'm trying to find a formula to make my Excel spreadsheet take a very un-ordered list(Column B), and sort of compress it into several ordered lists automatically. Current Example ...
0
votes
1answer
17 views

Excel - array formula - count days in range of weeks

I am trying to get an Excel Array Formula working. There is a list o weeks - each has a start date and an end date. There is a number of GRP in every week. I want to SUM all GRP (proportionally) ...
1
vote
1answer
21 views

An excel book opened from the shell doesn't see that other excel files are open

When I open the file Book1.xlsm with a vbs script, it doesn't see that Book2.xlsm is already open, and this is a problem because the macro1 I want to run in Book1 does something different depending on ...
0
votes
0answers
12 views

Excel - convert ISO8601 date ending in Z into format suitable for entry into Postgres field with type 'timestamp with time zone'

I have a CSV file that I'm opening in Excel. It has dates in this format: 2019-09-15T00:11:57.4030000Z I want this: 2019-09-15 00:11:57.403+00 I think I may be able to use the "format cells > ...
0
votes
1answer
14 views

How do I automate my webdriver to take data from excel sheet and use launch it?

So I have written a script in selenium to launch a webpage and extract information like, title name, fitment, number of reviews, verify if some words are present in the page. For example I used this ...
2
votes
1answer
30 views

Convert string to binary in excel vba

This is my code where I try to convert string to binary but its not working.Can please somebody help me? I have been trying to solve this for past 5 days!! Thank you in advance! Sub ...
-1
votes
0answers
16 views

how do i return a variable from a function in vba [duplicate]

Nice easy question that i cant seem to figure out. When passing a variable through a subroutine or function is it possible to pull the updated value out of the subroutine or function and back into ...
0
votes
0answers
20 views

Notepad ++ or Excel question (sorting text)

here's my issue, Out of excel I have a bunch of text that comes out in paragraphs looking something like this in single cells, 10.1.1.1 (server), 10.1.1.2 (server)10.1.1.3 (server)10.1.1.4 (server)...
0
votes
0answers
36 views

How do you convert datetime into just date using SQL?

I'm running Excel 2010, and I tried converting my code in sql SELECT Repository$`.`Date Archived` to just read the date without the time stamp, because right now it is seen as a mm/dd/yyyy/ hh:mm:...
0
votes
0answers
13 views

How to Click Excel Custom Tab Control using VB Script only, so that i can use it in UFT

There is custom tab in excel file.In which we need to click on specific control using VB script.Tried with commandbars as per microsoft examples.It works fine for inbuild tabs but not custom tab and ...
0
votes
0answers
15 views

Select from dropdown item and return multiple attributes

I'm trying to make a food trace ability list and I am trying to help speed up the process of completing it. I have put all my seed stock into a table under an excel tab called stock. Stock Table I'...
0
votes
0answers
23 views

VBA- Border line a cell based on a different cell's value

How do I write a VBA macro that for every "Carry Over" I input in column E, I want to border the corresponding B cell in Red. And this is across the worksheet. For e.g, in the picture below, ...
0
votes
0answers
15 views

ExportAsFixedFormat as PDF System.Runtime.InteropServices.COMException:

I am trying to send data from my application in Visual Studio vb.net to a template .xls that i would then like to save as a .pdf. Everything works fine except for when it tries to export as pdf and ...
-2
votes
1answer
48 views

How to convert epoch dates across years, including DST

I have a spreadsheet that includes a "Last Modified Date" in epoch format in column C, such as: 1486841495 (earliest date in 2017) 1574478516 (latest date in 2019) Column C has 6,003 rows. What I ...
-2
votes
0answers
30 views

is it possible to cut and paste from within a For Each loop? [closed]

(It seems the For Next loop operates at the entire worksheet level, whereas the For Each loop operates within a defined range of a worksheet and is more targeted). I would like to use a For Each loop ...
-1
votes
0answers
21 views

Looking for advice tackling an interesting ASCII to spreadsheet task [closed]

I am currently working on a way to break down mass ASCII files into a cleaned spreadsheet. The data in the ASCII files is from land titles and delimited with commas, although when getting this in to ...
0
votes
1answer
37 views

Can I write an Excel Macro to place my data into a table? [closed]

I have 0 experience with VBA and am wondering if there's a way to input information on one sheet, and run a macro to move it into a larger data table on a different sheet in the same Excel file. The ...
-1
votes
1answer
14 views

Excel Multiple IF AND range statements with different outcomes

I am struggling with an excel formula with multiple IF AND statements with different outcomes. Can someone please help? Basically, I am trying to achieve the following, if range of cell 1 and 2 is ...
0
votes
1answer
31 views

Find largest payee in a table

I have a finance tracker in excel with some sample data that I'm trying to find stats about. each transaction has fields shown How would I find the largest payee based on the amounts in column D (eg....
1
vote
0answers
36 views

Find all rows with cell matching range values, copy to new worksheet named by value

I have to pull reporting on customer data that includes multiple currencies. Instead of being formatted as a single item per line with multiple currency column, each currency that applies to an item ...
-1
votes
1answer
20 views

How to sum a dynamic range with a moving 'total' cell?

In the screenshot below, I would like to sum the dynamic range in column Y (and Z). The SUM formula is currently in cell Y8. I will not know how many items will be added after items A and B. This ...
-4
votes
0answers
25 views

python script that will pull data from excel and email it out [closed]

I have an excel file showing employees, I want to group the ones who are under the same manager and put them into a new file, then email the manager of those specific employees. Any help would be ...
0
votes
0answers
15 views

Excel measurement calculation (formulas or vba) [closed]

Every box I have has a measurement. PP 19cm x 16.3cm x 7cm P 30cm x 25.3cm x 14.9cmn M 40.6cm x 30.0cm x 25.0cm G 47.8cm x 36.5cm x 32.8cm GG 65cm x 44.0cm x 37cm Example: If I sell 100 units ...
1
vote
0answers
21 views

Single Variable type array giving transcription error?

I declared a single array of size 100 and stored some 6 values in it. I then transferred them to a different Excel workbook. However, when they were transferred they were given extra digits well past ...
0
votes
0answers
20 views

Copying cells from one worksheet onto another if cell in column C = 0 with macro

this is my first post on SO, so please forgive me for any faux pas. I'll try to adhere to the rules of the website. What am I trying to do? I'm trying to copy a cell from column A if cell = 0 on ...
0
votes
0answers
18 views

#FIELD! in cell but when clicking on cell, the correct value is in the formula box

I have an excel sheet with a large amount of data. Originally the data was in 1 column, separated by a comma, so I have used the test to columns option to get the data spread out, however when I do ...
0
votes
2answers
23 views

Highlight cells when its sum reached the value on another cell in Excel

I am new in VBA. I have this column. the first column is the period and the second is the list of payments of principal (see image). If I want to identify the period in which the payment has reached a ...
0
votes
0answers
9 views

excelJS wrapText in Table columns

Is there a way to get wrapText working for columns in a table? I'm trying the following and it's not registering in excel. const columnsStyle = { font: { name: 'Arial Black', size: 12 } }; const ...
-1
votes
0answers
27 views

Excel calculating

I need to calculate like this qty4*1Euro & qty3*1.5Euro = TOTAL 4*1 & 3*1.5 = TOTAL I wrote in two ways with words and numbers and with numbers so you can understand what I want WHAT I ...
-4
votes
0answers
30 views

Automation script for .xlsx to .csv containing cards information [closed]

I have this excel sheet and I want to have the same format for csv file. Could some one help me with a automation script please (to convert multiple excel sheets to csv files)?? data looks like in the ...
0
votes
0answers
16 views

Why are pyinstaller executable files using xlwings or openpyxl over 30x larger than xlrd

I am using Python 3.7 (Anaconda install) to process an Excel file to create a Word document. I wrote a script file to do this using xlwings and python-docx which works correctly when executing the ...
1
vote
1answer
26 views

Add/Subtract long variable from column reference

I saw a post here earlier which reminded me of a (very basic) problem I have run into every once in a while. I have no idea what a good title would be, I'm pretty sure mine isn't it. Anyway, let's ...
0
votes
0answers
12 views

Excel Conditional calculation

I have an excelsheet with a month in each column. I would like to "lock" the cells when the month has passed, so the calculated values remain the same, if a constant is changed. For example, my value ...
1
vote
1answer
30 views

How to parse a JSON result of an array of object and print in excel?

This is a multi-part question. I am looking to make a request and print the result in excel, with the headers at the top all across and the content data in the row below. When I run the following code,...
1
vote
2answers
38 views

How to reference same user inputted range across multiple sheets

I am trying to delete all the empty rows across all worksheets in a workbook. I've put together the following code but it only seems to work on the active sheet. I'm struggling to determine why it isn'...
1
vote
1answer
27 views

click event not working on programmatically / dynamically created optionbutton

I have the following code that programmatically / dynamically creates a frame and adds an option button: Private Sub ComboBox1_Change() Dim cb1234Frame As MsForms.Frame Dim opbtn1 As MsForms....
-1
votes
0answers
10 views

Opening Excel from Web Server with Microsoft Excel

I am developing a java web application which is supposed to allow users to edit an excel file stored in the server location. Ideally when the user clicks the link, I would like to open the excel ...
1
vote
3answers
36 views

How to check for the same delimiter multiple times?

I have an Excel sheet that contains strings and numbers. All the strings I am searching for have an underscore ("_"), which is my delimiter. However, some strings have the delimiter more than once. ...
0
votes
0answers
33 views

My VB.net Code is working but it's displaying errors afterwards

I've written some code in vb.net that adds, deletes and updates a spreadsheet. The add and the delete button works excellently without bring up any errors. But the update button works but it brings an ...
0
votes
0answers
19 views

Export Excel problem only Exports “Sheet” not “Sheet1”

I'm trying to use this code to Export, but only shows "Sheet", I just wanted to change to "Sheet1", but I do not know how. This is the only code I use: sql.Export_Excel(GridControl1, "Test" & ...
0
votes
0answers
12 views

Move a Data table to clipboard and paste it in excel

I'm trying to move data from a data table to excel. Is it possible to copy-paste the data table using a clipboard? Clipboard.SetDataObject(ds.Tables[0]); Microsoft.Office.Interop....
0
votes
0answers
16 views

Open filter on range from another workbook delete rename tab save as from another workbook x20

I have managed put a code together. It is working, but it's not very sufficient as I would need to create a 20 macros and rename the filtered text for each macro. I have two workbooks Q4 where the ...
1
vote
0answers
37 views

Msg box when cell A not empty cell b mandatory to be filled in - currently msg box always displays

I'm pretty new to VBA and have an XLS template where I'm trying to build in message box for users to fill in a cell in column B as mandatory if cell in column A is not blank before the template will ...
-5
votes
0answers
27 views

VBA code to copy different excel files (Sheets within workbooks) to specific named tabs in a master workbook [closed]

I Need help in coping files using VBA code. Scenario - There are few excel binary files, which needs to be copied to specific tabs of a master workbook. For example - there are 7 files in a folder ...