Recent questions tagged Excel

0 votes

826 views

1 answer

excel - Delete an array column, and change position of two columns

So let's say i have and 4x4 array of various numbers. I want to delete the third array column, and switch positions ... Arr, 4)) = Arr End Sub See Question&Answers more detail:os...

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

0 votes

876 views

1 answer

excel - VBA macro save SQL query in a csv file

I am working on a VBA macro which connects to my database on SQL Server and run some queries and ... saved as load_after_cutoff_postGamma.csv" See Question&Answers more detail:os...

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

0 votes

879 views

1 answer

excel - Use Regex to Split Numbered List array into Numbered List Multiline

I am trying to learn Regex to answer a question on SO portuguese. Input (Array or String on a Cell, so ... the separator string was the regex. See Question&Answers more detail:os...

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

0 votes

865 views

1 answer

excel - Log in to secured https website with VBA

I am trying to automate my daily tasks by VBA script automatically login into my bank account and returning ... secured by bank programmers. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - How to find a table using selenium and vba on webpage that uses iframes?

The below code worked up until a few days ago to go to the url, find the table and import the contents of the ... it is imported end sub ```` See Question&Answers more detail:os...

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

0 votes

895 views

1 answer

excel - VBA - show clock time with accuracy of less than a second

Is there a way to use VBA (excel) to generate a clock time with accuracy to a tenth of a second or less? ... this format should be... End Sub See Question&Answers more detail:os...

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

0 votes

953 views

1 answer

excel - Slow process on deleting rows - How to make faster?

I have a several macros within my workbook. This is the only one that seems to be really slow 3-5 ... Calculation = xlAutomatic End Sub Thanks! See Question&Answers more detail:os...

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

0 votes

637 views

1 answer

excel - How to enumerate all programs that can open XML file as plain text?

I'm working on some code that will import some XML in from an SQL database. Sometimes I want to import it into ... files as XML files are, too? See Question&Answers more detail:os...

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

0 votes

921 views

1 answer

excel - How can I include svg / png / vml images directly in an xls sheet?

I want to include (if I even can) include directly an svg image into an xls sheet that is written in xml ... image directly in an excel sheet. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Pivot Table filter out only 1 option

I'm having a problem with removing one option from the filter in my Pivot Table, if I record a macro and try ... the rest ~20 with one command? See Question&Answers more detail:os...

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

0 votes

937 views

1 answer

excel - Can't find the error: VLOOKUP not returning the value

I am working with an excel file and I am trying to "map" some values with the vLookUp function. The first ... 99 1019600 809.99 Thank you ! See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - VBA - array of filtered data to populate listbox

Okay so I am filtering a sheet ("Data") by a criteria: Sub Filter_Offene() Sheets("Data").Range("A:R"). ... this won't work with filtered Data. See Question&Answers more detail:os...

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

0 votes

691 views

1 answer

excel - Need to find a value that matches two columns of criteria. Possible VLOOKUP

Update Below -- 6/4 I have two worksheets in excel. One is a list of donors with their check#/amount/ Donor ... easier to read. Cknum = Check# See Question&Answers more detail:os...

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

0 votes

860 views

1 answer

excel - pastespecial of object shapes failed vba

I have this code to copy charts from an Excel 2010 worksheet into powerpoint. It loops through searches for ... newPowerPoint = Nothing End Sub See Question&Answers more detail:os...

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

0 votes

828 views

1 answer

excel - 1 microsoft second = 0.00001157407407

I was writing a routine to read from an Excel spreadsheet. I have just discovered thro that MS ... value = 0.00000000000000001100001000101110 See Question&Answers more detail:os...

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

0 votes

950 views

1 answer

excel - VBA Double as String with comma and not point

I am searching for a solution to convert a double to a string, but the string should have a comma before the ... ). Thanks for your help!! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - VBA Autofilter Using Multiple Criteria

All, I am trying to filter on multiple criteria within VBA. However I cannot find a simple way of doing ... formula in another column. Thanks See Question&Answers more detail:os...

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

0 votes

821 views

1 answer

excel - Extracting the collection of unique values from a filter in VBA

I have a file which has rows extending to tens of thousands across 8 columns. One particular column contains the ... help. Thanks in advance! See Question&Answers more detail:os...

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

0 votes

767 views

1 answer

excel - VLOOKUP with two criteria?

Is there a formula that returns a value from the first line matching two or more criteria? For example, "return ... A and column B. Thanks. See Question&Answers more detail:os...

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

0 votes

915 views

1 answer

excel - Remove Unicode characters in a String

How do I remove all special characters which don't fall under ASCII category in VBA? These are some of the symbols ... strName, ChrW(376), " ") See Question&Answers more detail:os...

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

0 votes

789 views

1 answer

excel - VB Macros for Office 2016 for Mac require Permissions every time they try to access a file! Is there any way to get around this behavior?

Any VB Macro in Office 2016 shows a dialog box to the user asking for permission, every time the Macro tries to ... there a way to avoid it. See Question&Answers more detail:os...

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

0 votes

705 views

1 answer

excel - Does Range.Formula property translate to other locale

When a user manually enters formula in a sheet in the English version of Excel and sends this document to ... formula insertion language proof? See Question&Answers more detail:os...

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

0 votes

802 views

1 answer

excel - VBA Error "Bubble Up"

I haven't read much about it, but the author at the link below recommends that I don't use "bubble up" to ... the author says not to? Thanks. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - VBA API declarations. Bring window to front , regardless of application

I am trying to bring and Excel window to the front of all applications running regardless. Current code, ... the moment nothing happens. See Question&Answers more detail:os...

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

0 votes

838 views

1 answer

excel - Handling numbers larger than Long in VBA

I am Currently trying to write some code in VBA to solve a problem from Project Euler. I have been trying to ... . Any help will be appreciated. See Question&Answers more detail:os...

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

0 votes

824 views

1 answer

excel - Use of INDEX MATCH to find absolute closest value

I've long sought a method for using INDEX MATCH in Excel to return the absolute closest number in an array ... anyone please explain this part? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - How to determine if a worksheet Cell is Visible/Displayed in VBA?

I need to find if a cell is visible on the screen. By visible, I don't mean hidden. I am specifically ... in advance for your help, Marwan See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - How to convert xls file to xlsx file using C#?

I was developing an application which read data from an excel file, but when I try to open it, an exception ? ... help me to solve this problem. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags