Recent questions tagged Excel

0 votes

744 views

1 answer

excel - Start VBA macro when editing a cell

I simply try to write a search macro in an excel sheet. How can I start a macro dynamically DURING editing ... cell was selected). Thanks. See Question&Answers more detail:os...

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

0 votes

725 views

1 answer

excel - VBA Worksheet Change Event

I am trying to use the Worksheet Change Event in Excel VBA, but it doesn't seem to work. From what I gather, ... don't know much about it yet. See Question&Answers more detail:os...

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

0 votes

764 views

1 answer

excel vba: make part of string bold

I have excel cells which contain entries like this: name/A/date name/B/date name/C/date Cell content is ... entry. Anyone got an idea? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?

I have written a C# code in console application to open two excels and copy and paste data from one excel to ... ) How to solve this one? See Question&Answers more detail:os...

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

0 votes

788 views

1 answer

excel - Remove double quotation from write statement in vba

This code will write log file to LogFilePath, and generate output as below. StarRange and EndRange is a variable ... A1 End position = B100 See Question&Answers more detail:os...

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

0 votes

627 views

1 answer

excel - Performance difference between looping range vs looping array

Will there be any difference in performance (speed) when looping through a range Vs assigning the same range to an Array and looping an Array? See Question&Answers more detail:os...

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

0 votes

655 views

1 answer

excel - Change font color for specific char in a cell range

I would like to change the font color for a specific character within a range of cells. I figured out how to do ... 221) End If Next i End Sub See Question&Answers more detail:os...

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

0 votes

517 views

1 answer

excel - Read .txt from .zip files

I need to open a few .zip files, view a specific .txt and write what's inside of this .txt file to an ... take what's inside of the md5.txt See Question&Answers more detail:os...

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

0 votes

595 views

1 answer

excel - VBA for filtering columns

I have a big database-like sheet, first row contains headers. I would like a subset of rows of this table based on ... ("A1") End With End Sub See Question&Answers more detail:os...

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

0 votes

605 views

1 answer

excel - How can I evaluate a string into an object in VBA?

In my previous question, How do I assign a value to a property where the property name is supplied at ... SomeFunction from the example above? See Question&Answers more detail:os...

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

0 votes

580 views

1 answer

excel - How to distinguish if sumproduct needs to be inserted with CSE or not?

I sometimes use the inherent array functionality of sumproduct to avoid havingt to enter formulas with Control + Shift ... the second does not. See Question&Answers more detail:os...

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

0 votes

659 views

1 answer

excel - Multiply Entire Range By Value?

So The best way I could think of to accomplish this over a large range (about 450k rows) was to use ... better ways of accomplishing this task? See Question&Answers more detail:os...

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

0 votes

645 views

1 answer

excel - Office 2016 -> 2013 "compile error, can't find project or library"

I just upgraded to Office 2016, which most of my users haven't done, and I'm getting a new error when users try ... code Set app = Range("A2") See Question&Answers more detail:os...

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

0 votes

502 views

1 answer

excel - How can I open this VBA workbook faster?

I am currently trying to make a macro that will go to a directory, open a workbook (there are 38 currently with ... + 1 Next Next End Function See Question&Answers more detail:os...

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

0 votes

661 views

1 answer

excel - Changing array values in a VBA dictionary

I have a piece of code that does not seem to do what it is expected to do. VBA Arrays are mutable by all means ... 2, which is not fine End Sub See Question&Answers more detail:os...

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

0 votes

827 views

1 answer

excel - reading entire text file using vba

I'm trying to read a text file using vba. I tried the below code Open "C:ester.txt" For Input As #1 ... more stuff Thanks in advance for help. See Question&Answers more detail:os...

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

0 votes

523 views

1 answer

excel - Get data from multiple sheets in a selected workbook

I'm new to macros in Excel and I need to make a macro that get data from multiple sheets in a ... readable. SummarySheet.Columns.AutoFit End Sub See Question&Answers more detail:os...

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

0 votes

987 views

1 answer

excel vba how to copy the value of multiple non-contiguous ranges into an array

I am trying to copy the value of multiple non-contiguous ranges into an array. I wrote code like this: ... range("A14:D15")).Value See Question&Answers more detail:os...

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

0 votes

572 views

1 answer

excel - Access files with long paths (over 260)

I'm using Microsoft Scripting Runtime (FSO) to parse folders and produce a list of all of its contents, the ... , size created, and modified. See Question&Answers more detail:os...

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

0 votes

776 views

1 answer

excel - Read and write from/to registry in VBA

I saw this line in C# and I am trying to adapt it to VBA: Microsoft.Win32.Registry.SetValue(@" ... myWS.RegWrite i_RegKey, i_Value, i_Type See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

excel - How can I loop through a subset of worksheets?

I know how to loop through all the worksheets in a workbook, and how to exit once I reach an 'end-flag' ... ' code here Next LoopIndex End Sub See Question&Answers more detail:os...

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

0 votes

642 views

1 answer

excel - Split text in cells at line breaks

I am working on an Excel spreadsheet that has data in 39 columns. One of these columns, column AJ, is a ... maybe I have adapted it incorrectly. See Question&Answers more detail:os...

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

0 votes

578 views

1 answer

excel - Record cannot be read; no read permission on 'MSysObjects'

I'm trying to get a list of all tables from an Access 2007 ACCDB format database using Excel VBA. I have ... sure. Does anybody have any idea? See Question&Answers more detail:os...

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

0 votes

594 views

1 answer

excel - How to roundup a number to the closest ten?

Probably the title is not very suggestive. Let me explain you with an example. I have: 12345.6 2345.1 ... rather use formulas instead of VBA. See Question&Answers more detail:os...

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

0 votes

729 views

1 answer

excel - VBA - Range to jpg picture

I'm trying to get a jpg file from a specific range in excel I'm currently getting the 1004 Runtime error on Range ... :="JPG" End With End Sub See Question&Answers more detail:os...

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

0 votes

586 views

1 answer

excel - AutoFilter - Use of SpecialCells

Background: For many times I have applied AutoFilter and never really asked myself why it works the way it does ... = Var .AutoFilter End With See Question&Answers more detail:os...

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

0 votes

883 views

1 answer

excel - Application.WorksheetFunction.Match method

I have seen a lot of Topics to the "unable to get the match property of the Worksheetfunction class" problem. But ... was my error in the code) See Question&Answers more detail:os...

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

0 votes

478 views

1 answer

excel - PyInstaller and python-docx module do not work together

I am trying to make an executable of my program to give to my FTC team. Everything works but when I try to ... .pack() Quit.pack() mainloop() See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags