Recent questions tagged EXCEL

0 votes

655 views

1 answer

excel - Get values from a listbox on a sheet

I have a listbox named ListBox1 on Sheet1 of an Excel workbook. Every time the user selects one of the items ... any of the previous selection. See Question&Answers more detail:os...

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

0 votes

822 views

1 answer

excel - What is the default value of IMEX in OLEDB?

string strConn = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" + filename + ";Extended Properties="Excel 12.0 ... Anyone can help me? Thanks. See Question&Answers more detail:os...

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

0 votes

661 views

1 answer

excel - Alternatives to Public Variables in VBA

I have a number of public variables that are referenced across several modules. I know if you debug or hit ... variable that never gets cleared? See Question&Answers more detail:os...

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

0 votes

633 views

1 answer

excel - Inserting an Image into a sheet using Base64 in VBA?

I'm trying to insert an image into a sheet with VBA using Base64 but I can't find any examples of how to ... the base64 encoded image to file. See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

excel - Stop VBA Evaluate from calling target function twice

I am having trouble getting VBA's Evaluate() function to only execute once; it seems to always run twice. For ... Debug.Print Rnd() End Function See Question&Answers more detail:os...

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

0 votes

702 views

1 answer

excel - What difference does it make if one runs a VBA code in "Sheets", in "ThisWorkbook", and in "Modules"?

What difference does it make if one runs a VBA code in "Sheets" ("Sheet1", "Sheet2", etc.), in " ... one should be used in which cases? See Question&Answers more detail:os...

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

0 votes

572 views

1 answer

excel - How to improve the speed of VBA macro code?

I do not have much experience with writing macros, and therefore need the help of this community for the ... .ScreenUpdating = True End Sub See Question&Answers more detail:os...

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

0 votes

730 views

1 answer

excel - Copying and pasting data using VBA code

I have a button on a spreadsheet that, when pressed, should allow the user to open a file, then copy ... ActiveSheet.Paste wb.Close End Sub See Question&Answers more detail:os...

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

0 votes

797 views

1 answer

excel - VBA test if cell is in a range

I want to test if a given cell is within a given range in Excel VBA. What is the best way to do this? See Question&Answers more detail:os...

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

0 votes

566 views

1 answer

excel - How to select the contents of a textbox once it is activated?

I have this simple Userform, where I only have TextBox1 and TextBox2. I enter some text in both of them. ... the place where it was clicked. See Question&Answers more detail:os...

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

0 votes

663 views

1 answer

excel - How to define a non continuous range in COUNTIF

A B C 1 Β Β 2 Β Β 3 Α Α 4 Α Α 5 Β Β 6 Α Α 7 Α B 8 Β Β 9 Β Β 10 Α Α 11 Β A 12 ... ? The same formula must be used for every cell in column B. See Question&Answers more detail:os...

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

0 votes

587 views

1 answer

excel - VBA returning error when calling a Sub with multiple parameters

I'm trying to figure out why VBA is returning an error (Compile error: Expected: =)when I call a Sub and ... (row As Long, column As Long) See Question&Answers more detail:os...

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

0 votes

803 views

1 answer

excel - If "0" then leave the cell blank

I am trying to create a simple ledger and on the far right of the "Book" it totals any debit/credit that ... the formula I am currently using. See Question&Answers more detail:os...

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

0 votes

839 views

1 answer

excel - Declaring variable workbook / Worksheet vba

I know this might come off as a trivial question, but I can't seem to declare a workbook or a worksheet ... I receive a type missmatch error. See Question&Answers more detail:os...

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

0 votes

577 views

1 answer

excel - Difference between ADO and DAO

This is not a question about which is better, but rather a question regarding why they differ ... purely for informational purposes. See Question&Answers more detail:os...

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

0 votes

998 views

1 answer

excel - Using VBA to run WinSCP script

I am able to download files from SFTP in CMD window, by using following code: WinSCP.com # Connect to the host ... the lines at one time? Thanks See Question&Answers more detail:os...

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

0 votes

846 views

1 answer

excel - Open Word Document and Bring to Front

Below is a working code snippet that opens a Microsoft Word document, and goes to a specific index from the Table ... ) type "function" in VBA? See Question&Answers more detail:os...

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

0 votes

729 views

1 answer

excel - Handle cancellation of InputBox to select range

I have the following piece of code: dim selectRange as Range Set selectRange = Application.InputBox("Select your range ... I avoid this error? See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

excel - How to select clear table contents without destroying the table?

I have a vba function in excel 2010 that I built using help from people on here. This function copies the ... every time I enter some data. See Question&Answers more detail:os...

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

0 votes

962 views

1 answer

excel - VBA to refresh Bloomberg data not running in proper order

my purpose is to update Bloomberg data and do some calculatations with different tickers. But it seems that VBA will ... know how to fix it? See Question&Answers more detail:os...

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

0 votes

649 views

1 answer

excel - Grouping Rows in VBA

I have the code below that doesn't seem to be working. Essentially, rngList refers to a defined name range ... Selection.End(xlDown).Select Loop See Question&Answers more detail:os...

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

0 votes

651 views

1 answer

excel vba : selected cells loop

Would like to iterate each row in a selection in excel VBA. I have: Dim rng As Range Dim s As String Set ... get the start and end column? See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

excel - Power Query Transform a Column based on Another Column

I keep thinking this should be easy but the answer is evading me. In Excel Power Query, I would ... which requires multiple additional steps. See Question&Answers more detail:os...

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

0 votes

953 views

1 answer

excel - Python Pandas - Read csv file containing multiple tables

I have a single .csv file containing multiple tables. Using Pandas, what would be the best strategy to get two ... more tables than those two. See Question&Answers more detail:os...

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

0 votes

570 views

1 answer

excel - What's the difference between Trim() and Trim$() in VBA?

What is the difference between trim and trim$ in vba? Accidentally today when I used left and trim functions ... differentiate trim and trim$. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Deep Copy or Clone an ADODB recordset in VBA

I have been searching for a way of duplicating or copying a recordset in VBA. And by that I mean, having the ... but is there no other way? See Question&Answers more detail:os...

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

0 votes

619 views

1 answer

excel - What do the hash signs in #if, #else, #end if mean?

I'm writing code to check if a file is available to be checked out of SharePoint and, if it isn't, alert ... to google because it is so vague. See Question&Answers more detail:os...

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

0 votes

615 views

1 answer

excel - Get list of all properties for an object

Is there a way to get a list of all valid properties for a given object? If I wanted to start at ... list = object.enumproperties Any ideas? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags