Recent questions tagged excel

0 votes

894 views

1 answer

excel - Why is 0 divided by 0 throwing an overflow error in VBA?

Why is 0/0 throwing Overflow error in VBA, while in .Net languages it is simply a Division by 0 error? E ... Description On Error GoTo 0 End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

621 views

1 answer

excel - How to search and extract certain values in cells - VBA

I have the following data, which can be seen by using the link below: Example of Input and desired Output Data ... (Sheet1) Output data (Sheet2) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

711 views

1 answer

excel - For Each loop won't delete all rows with specific values

I want to delete all rows that do not contain the value "Total" in Range("B11:B25"). Below is my ... multiple times which is not practical. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

607 views

1 answer

excel - VBA href Crawl on Browser's Source Code

I did update on my question since i know more clearly on the technicality i am trying to address. A. If ... thank you for watching my question See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

629 views

1 answer

excel - Calculate Avg Price, Realized gain & Unrealized gain via UDF using FIFO method

This post is in continuation of my earlier post where I have already got assistance from Tom Sharpe on how to ... -150 9950 -1492500 150 10100 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

963 views

1 answer

excel vba http request download data from yahoo finance

I am in the process of making a program I wrote using excel vba faster. The program downloads stock market ... .ax%22%29 Many Thanks, Josh. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

543 views

1 answer

excel - How to get a particular part of a String

I am writing a macro in Excel where I need to get a substring from a String. It's like this. ~/tester/test ... it's not useful. Can anyone help? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

713 views

1 answer

excel - Remove cell from Range (object)

Background My code does some loops over ranges, however, each interaction should be performed in the range ... Next CounterRange End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

973 views

1 answer

excel 2010 - Internet Explorer VBA Automation Error: The object Invoked has disconnected from its clients

I'm trying to write code that will read a value from Excel, look it up in an internal web based system and ... xOpen = False End If Exit Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

724 views

1 answer

excel - VBA Function argument list select

I am looking to do something like the following: Public Function myFunc(vArg1 as string, vArg2 as string, ... for the function. Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

718 views

1 answer

excel - Python, OpenOffice: Programmatically Manipulating spreadsheets

I have an spreadsheet-based automated report that needs to be created daily, with some charts, aggregating functions ( ... file and deliver it. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

875 views

1 answer

excel - CountIf With Filtered Data

I was researching a way to count the number of zeroes in a column of data, even if the data gets filtered. I ... a simpler way of doing this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - Worksheet.UsedRange.Rows.Count returns wrong result

In VB.NET I want to get the used rows so I wrote that: Dim objWorksheet As Excel.Worksheet = workbook.Sheets(2) ... .Count to get the last row. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

698 views

1 answer

excel - How to browse for save directory?

By clicking a button in Excel, the user exports a specific sheet to a csv with a dynamic filename and the csv ... .Close False End With End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

798 views

1 answer

excel - Get existing IE via VBA

My goal is to scrape data off multiple webpages on the same site into Excel. I have these pages open in ... company to upgrade), Excel 2010 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

907 views

1 answer

excel - Getting "method saveas of object _workbook failed" error while trying to save an XLSM as CSV

I'm trying to save a macro-enabled Excel workbook as a csv file, overwriting the old one (below I ... .AlertBeforeOverwriting = True End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

776 views

1 answer

excel - How to make a reference to a cell of another sheet, when the sheet name is the value of a cell?

In excel 2007, I have a formula in a cell like the following: =COUNTIFS('2008-10-31'!$C:$C;">="&'$A7) Now ... have to write a VBA-Macro for it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

647 views

1 answer

excel - find a row index of a number that occurred first

I have A column that has values in random order like A column 2 3 4 2 5 6 4 3 4 I want the row ... them in order.please help me with these See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

674 views

1 answer

excel - Learning Apache POI for Java

I'm trying to learn Apache POI for Java quickly (for manipulating Excel). I've been googling for tutorials, but ... to find any on their site. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

902 views

1 answer

excel - Adding a newline character within a cell (CSV)

I would like to import product descriptions that need to be logically broken according by things like description, ... they will show up? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

671 views

1 answer

excel - Workbook_Open sub won't run when I open the workbook?

This program is supposed to create a button that the user can press to activate a different sub. From my searches ... End With End With End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

682 views

1 answer

excel - Format a time span as a number of days, hours and minutes

This is purely an Excel sheet question. I have a time span that is basically a difference between two ... number format available for that? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

715 views

1 answer

excel - Add attachment with varying date in file name to Outlook mail

I have an Excel file named "Home Audio for Planning (28-3-2013). The date will change every day but the ... EnableEvents = True End With End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

631 views

1 answer

excel - Exported file opens after macro completes - unwanted

I have some VBA code that exports SAP data to a .XLSX file, then imports this file into excel. After the ... Thanks in advance for any feedback, See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

846 views

1 answer

excel - Last row in column VBA

I wrote a short VBA code to automate stuff. A short snippet is as follows: Sub TEST() Rows("1:2").Select ... ("$A$1:$O$148") Thanks in advance! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

590 views

1 answer

excel - return values from multiple matching rows

First off, I'd like to do this without VB if possible, so I don't have to go through the hassle of ... the finish line is greatly appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

excel - VBScript and multilevel OLE?

I have made a vbscript to target some computers and do wmi queries on them, and my boss wants this data to be ... me if it is even possible? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

873 views

1 answer

excel - VBA: How To Reference ComboBox Object

I have created a lone ComboBox on the first worksheet in Excel. However, I can't find a way to reference ... ComboBox in my worksheet? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags