Recent questions tagged Excel

0 votes

781 views

1 answer

How to use SUMIF formula in Excel cell that must sum over a given range and instead of finding for a single value ... not able to use VBA here. See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

excel - How to unzip a zip file using scala?

Basically I need to unzip a .zip file which contains a folder called modeled which in turn contains a ... - Output.zip", tempDirectoryDir) See Question&Answers more detail:os...

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

0 votes

769 views

1 answer

excel - How to copy the conditional formatting without copying the rules from a Conditional Formatted cell?

I have a row of data with conditional formatting in it. I need to copy this row to another row. This new ... CF rule vanishes. Is it possible? See Question&Answers more detail:os...

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

0 votes

902 views

1 answer

excel - Powershell script cannot access a file when run as a Scheduled Task

My Powershell (2.0) script has the following code snippet: $fileName = "c: eports1.xlsx" $xl = new-object -comobject ... m at a loss. Any ideas? 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 call macro after Refresh or Refresh All button pressed?

Ultimately, I would like to run a macro after anyone refreshes the workbook, specifically using the Refresh button ... in the Worksheet module? See Question&Answers more detail:os...

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

0 votes

979 views

1 answer

excel - File name without extension name VBA

I need to get file name without extension name by VBA. I know ActiveWorkbook.Name property , but if user ... can't customize this property. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - python xlwt set custom background colour of a cell

I am using python 2.7 and xlwt module for excel export I would like to set backgroung colour of a cell i know ... is not working :) thank you See Question&Answers more detail:os...

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

0 votes

689 views

1 answer

excel - Get values from other sheet using VBA

I want to get values from other sheets. I have some values in Excel (sheet2) for example: A B C D - - - ... I set sheet2 as the active sheet? See Question&Answers more detail:os...

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

0 votes

666 views

1 answer

excel - How to Remove Line Break in String

I want to Remove the Line Break from the string if my string Ends with Line Break. Sub linebreak(myString) If Len( ... - 1) End If End Sub See Question&Answers more detail:os...

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

0 votes

753 views

1 answer

excel - Use Python to Write VBA Script?

This might be a bit of a stretch, but is there a possibility that a python script can be used to create VBA ... thought I'd ask. Cheers, Mike See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

excel - string encryption/decryption

I am interested if it's possible to do string encryption/decryption using Excel Visual Basic and some cryptographic ... for Excel Visual Basic? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - How to automate a power query in VBA?

I have data in sheet 1. Normally I go to power query and do my transformations, then close, and load to an ... to load to new sheet manually. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Python pandas to_excel 'utf8' codec can't decode byte

I'm trying to do some data work in Python pandas and having trouble writing out my results. I read my data ... and encode my dataframe to utf8? See Question&Answers more detail:os...

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

0 votes

564 views

1 answer

excel - Reducing WithEvent declarations and subs with VBA and ActiveX

On a worksheet I have 3 ActiveX objects being TextBox1, TextBox2, ListBox1 Leaving other code out I have a class ... objControl As ????? See Question&Answers more detail:os...

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

0 votes

944 views

1 answer

excel - VBA check if array is one dimensional

I have an array (that comes from SQL) and can potentially have one or more rows. I want to be able ... without using the error handler)? See Question&Answers more detail:os...

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

0 votes

759 views

1 answer

excel - Create folder path if does not exist (saving from VBA)

I have a list of items in a sheet like so: My code goes through each row and groups the ... Next AlphaNumericOnly = strResult End Function See Question&Answers more detail:os...

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

0 votes

703 views

1 answer

excel - How to stop VBA code running?

Say I have a button embedded into my spreadsheet that launches some VBA function. Private Sub CommandButton1_Click() ... , any ideas? Thanks. See Question&Answers more detail:os...

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

0 votes

598 views

1 answer

excel - In VBA get rid of the case sensitivity when comparing words?

I am working on an VBA program which would allow the user to type an address and find the location by ... possible! Thanks in advance ! See Question&Answers more detail:os...

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

0 votes

663 views

1 answer

excel - Working with time DURATION, not time of day

I'm doing some benchmarking, and I want to use Excel to produce graphs of the results. I've got a simple but ... to a specific time of day? See Question&Answers more detail:os...

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

0 votes

747 views

1 answer

excel - VBA Count cells in column containing specified value

I need to write a macro that searches a specified column and counts all the cells that contain a specified ... Does anyone have any ideas? See Question&Answers more detail:os...

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

0 votes

684 views

1 answer

excel - How can I use a for each loop on an array?

I have an array of Strings: Dim sArray(4) as String I am going through each String in the array: for each ... element to a String or something? See Question&Answers more detail:os...

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

0 votes

747 views

1 answer

excel - Convert cells(1,1) into "A1" and vice versa

I am working on an worksheet generator in Excel 2007. I have a certain layout I have to follow and I often have ... 1,1) into A1 and vice versa See Question&Answers more detail:os...

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

0 votes

744 views

1 answer

excel - When should the xlsm or xlsb formats be used?

Since Excel 2007, Microsoft has split the classical .xls format to several formats (in particular, .xlsx, .xlsm, ... using any of these formats? See Question&Answers more detail:os...

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

0 votes

745 views

1 answer

excel 2010 - Conditional formatting, entire row based

I've searched and read through answers related to conditional formatting, but I can't seem to get mine to work, ... nothing. What am I missing? See Question&Answers more detail:os...

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

0 votes

651 views

1 answer

excel - Need help to fill number into Chrome input box with Selenium

Hi I've been trying to fill a number in an input box in Chrome (v 75.0.3770.142) using Selenium Basic ... class="ng-hide">100000</p> See Question&Answers more detail:os...

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

0 votes

605 views

1 answer

excel - Loop Through Sub-Dir

Sub CheckandSend() Dim strfile As String Dim ws As Worksheet 'make sure to define a sheet Set ws = ThisWorkbook.Worksheets ... OP30.....ETC..., See Question&Answers more detail:os...

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

0 votes

595 views

1 answer

excel - How to use 3 cells to actually complete the test

Ok, so I did have a quick search but did not find an answer that does what I would like... I have a ... with no success and &, ie =A1&B1&C1 See Question&Answers more detail:os...

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

0 votes

861 views

1 answer

excel - How to update slicer cache with VBA

I'm using Excel VBA to hide/show elements on slicer depending upon user selection. I have the following code ... selected state. Any pointers ? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags