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. Do NOT use with other spreadsheet software like [google-sheets]. General help regarding Excel for single worksheet functions is available at Super User (http://superuser.com/).

0 votes
0 answers
12 views

Run-Time Error 1004: Text To Columns Method of Range Class Failed

I have been working on this since yesterday. I am trying to create a macro, I have tried numerous methods, however I keep getting the error message 'Run-time error '1004': TextToColumns method of ...
user avatar
0 votes
0 answers
9 views

Is there a way to map a json object for the below example?

I need to read an excel file, map the fields and update them in salesforce. Below is the payload which I am getting while I read the excel. I need to convert this into the requested Output Payload. ...
user avatar
0 votes
0 answers
20 views

Reading a .xls file into a DataFrame using read_html creating a list, not a df

At first I tried reading the .xls file like this: df = pd.read_excel('/Users/KLG/regionlist1.xls') Which led to this error: ValueError: Excel file format cannot be determined, you must specify an ...
user avatar
  • 121
0 votes
0 answers
17 views

Excel Index formula with "selected" range within data

Hello everyone I am trying to do the following: I have a set of data which looks like: I would need to index the column N and find the corresponding TB (time Band) according to a specific DepDte (...
user avatar
  • 55
-2 votes
0 answers
12 views

Excel VBA macro for converting text to numbers [duplicate]

I'm new to VBA and so this might be an easy one. I notice that Excel "sometimes" shows a little green triangle in the top left corner as seen in the picture below to indicate numbers stored ...
user avatar
0 votes
0 answers
13 views

How to use text to column to separate currency symbol from amount? Trying to delimit properly to create two separate columns for each

so when I try to delimit the two the amount integer value populates in the cell to the right but the currency symbol gets deleted from the initial cell to the left. **Can anyone please help so that ...
user avatar
  • 67
0 votes
2 answers
24 views

Making a function with mutually exclusive pre defined argument list

I know what an optional argument list is and how to set default vales. Public Function argTest(arg1 As String, Optional arg2 As String = "TEST", Optional arg3 As String = "TEST") ...
user avatar
0 votes
0 answers
17 views

VBA code to hide Menu, Scrollbar and etc... running in every workbook i open

I have a VBA code to hide Menu, Toolbars, Scrollbars and etc, its currently aplied on "ThisWokbook" not a Module, so that code run everytime i open the Workbook ( HAHA1.xlsm ) My Code ...
user avatar
  • 55
-2 votes
0 answers
46 views

Perform over 1M calculations in excel [closed]

What is the best way to over a million averageifs operation in less than 5 mins. I have data in 3 tables and I've tried VBA but the speed is much slower. Please suggest a tool for this calculation ...
user avatar
0 votes
0 answers
21 views

Retrieve a URL from an open webpage

I am running an Excel worksheet alongside an open webpage. I navigate to the webpages independently from Excel. Once I get to a page I am interested in, I want to run a macro in Excel to retrieve ...
user avatar
0 votes
1 answer
21 views

Issues with replacing bookmarked data

I recently asked a similar question but thanks to a comment I have made some updates. However, I am running into some issues. I am attempting to use Word bookmarks in a "template" to auto-...
user avatar
  • 115
1 vote
1 answer
25 views

Table Filter greater than and blanks at the same time

I currently have an excel table which I want to filter with 2 Criteria simultaneously. I want the table to be presented with a ">=" Criteria and with a "<>" Criteria in ...
user avatar
0 votes
1 answer
20 views

Finding Sum of Excel Column in Windows Forms Application

I'm new to working with Excel within Windows Forms Application using C#, but I trying to get the sum of column a from a CSV file chosen by the user with a button click and then put it within a textbox....
user avatar
1 vote
1 answer
24 views

Copying over certain cells from multiple columns

my goal is to copy cells in a dynamic range from Column B to S to another sheet if they are non zero. Additionally, would like to move the cells up to the top of the next sheet (Without having to ...
user avatar
  • 31
-1 votes
0 answers
15 views

Link a lot of cells in excel to some table in a word document

Can anyone help? :( I have to link a lot of cells in excel to some tables in a word document using (special paste, link, unformatted text) The task required by the boss is to enable a report in word ...
user avatar
  • 1

15 30 50 per page
1
2 3 4 5
17862