Recent questions tagged Excel

0 votes

982 views

1 answer

excel - How to create dynamic variable names VBA

I am trying to create a dynamic number of variables in VBA based on the value in a cell. Essentially what I'd ... To x Dim Team(i) As Integer See Question&Answers more detail:os...

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

0 votes

557 views

1 answer

excel - Assign keyboard shortcut to run procedure

When I press F5 in the VBA editor I would always like to run my "Sub Skynet()" procedure. Is there ... a keyboard shortcut to this procedure. See Question&Answers more detail:os...

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

0 votes

708 views

1 answer

excel - How to add data validation to a cell using VBA

I want to add "data validation" in a cell(which is variable) using VBA and the range which is to come in ... := _ xlBetween, Formula1:="range1" See Question&Answers more detail:os...

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

0 votes

886 views

1 answer

excel - Convert xlsx file to csv using batch

How do you convert multiple xlsx files to csv files with a batch script? See Question&Answers more detail:os...

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

0 votes

543 views

1 answer

excel - "Can't find Project or Library" for standard VBA functions

So I'm having to run someone else's excel app on my PC, and I'm getting "Can't find Project or ... my project properties/references/etc? -Adam See Question&Answers more detail:os...

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

0 votes

520 views

1 answer

excel - Is there an R function to reshape this data from long to wide?

How the data looks now: Coach ID | Student | score | --------------------------------- 1 ... anyway to reshape data from long to wide? Thanks! 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 add data table with legend keys to a MS Chart in C#?

There are 2 lists called listversion & MIN_list. Using values of these list I have created a line chart. Everything is ... I do it ? Thank you. See Question&Answers more detail:os...

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

0 votes

686 views

1 answer

excel - How to use VBA SaveAs without closing calling workbook?

I want to: Do data manipulation using a Template workbook Save a copy of this work book as .xlsx (SaveCopyAs ... has an invalid file format. See Question&Answers more detail:os...

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

0 votes

595 views

1 answer

excel - Concatenate column headers if value in rows below is non-blank

I have table with data in the format below. Data I want the finished table to have the blank column to be ... non-blank cells in each row. See Question&Answers more detail:os...

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

0 votes

584 views

1 answer

excel - VBA Password Input with Cancel Function

I have been using the standard password textbox written by Daniel Klann (http://www.ozgrid.com/forum ... UnhookWindowsHookEx hHook End Function See Question&Answers more detail:os...

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

0 votes

788 views

1 answer

excel - Changing the date format to yyyy-mm-dd

I've got a date column that contains dates in mixed format. For example: A 21.03.1990 03/21/1990 So ... . I would appreciate any advice. See Question&Answers more detail:os...

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

0 votes

534 views

1 answer

excel - What are the benefits of setting objects to "Nothing"

I've noticed that some members of the Stack Overflow community will use Set Object = Nothing in closing procedures. ... ws = Nothing Exit Sub See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Run-time error '1004' : Method 'Range' of object'_Global' failed

I have a problem with excel, with a form that generates a reference no. But when I try to generate the reference ... t know what has gone wrong? See Question&Answers more detail:os...

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

0 votes

825 views

1 answer

excel - How can I run VBA code each time a cell gets its value changed by a formula?

How can I run a VBA function each time a cell gets its value changed by a formula? I've managed to ... to a formula referencing another cell. See Question&Answers more detail:os...

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

0 votes

821 views

1 answer

excel - Translate text using vba

Probably could be a rare petition, but here is the issue. I am adapting an excel of a third-party to my ... any little change. Is that possible? See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

excel - Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

I'm trying to create a chart with a range built dynamically using the INDIRECT function. Excel does recognize the range ... ("sheet!"&E2&":"&E3) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - .xlsx and xls(Latest Versions) to pdf using python

With the help of this .doc to pdf using python Link I am trying for excel (.xlsx and xls formats) ... be FileFormat file format? Please Help See Question&Answers more detail:os...

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

0 votes

663 views

1 answer

excel - Benchmarking VBA Code

What is considered the most accurate way to benchmark VBA code (in my case, I am testing code in Excel)? Are there ... - Start) / 1000) End Sub See Question&Answers more detail:os...

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

0 votes

772 views

1 answer

excel - Convert xlsx to csv in Linux with command line

I'm looking for a way to convert xlsx files to csv files on Linux. I do not want to use PHP/Perl or ... for the newer Excel files. Any ideas? See Question&Answers more detail:os...

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

0 votes

547 views

1 answer

excel - Copy a selected range to another worksheet

I am using code below which I am trying to change so as not to use .select Selection.Select ' from active ... range _ 'in Purch req worksheet See Question&Answers more detail:os...

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

0 votes

655 views

1 answer

excel - How can I reference a cell's value in PowerQuery

I'm having multiple PowerQuery queries that I would like to feed the value of a cell in my Excel file. In ... I can get this into PowerQuery? See Question&Answers more detail:os...

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

0 votes

742 views

1 answer

excel - VBA: How to change the value of another cell via a function?

I'm an Excel VBA newbie. How to change the value of the specified cell via a user-defined function? What's ... display the specified text in E6. See Question&Answers more detail:os...

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

0 votes

671 views

1 answer

excel - Unicode string literals in VBA

I would like to declare (in a VBA class module) some private constant strings that contain Japanese characters. Is ... a matter of taste). See Question&Answers more detail:os...

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

0 votes

711 views

1 answer

excel - Fill non-contiguous blank cells with the value from the cell above the first blank

I have a column like the following: 1 red 2 blue 3 red 4 5 blue 6 7 8 white The blanks refer to the ... fill in the blanks for entire column? See Question&Answers more detail:os...

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

0 votes

493 views

1 answer

excel - How to make safe API Timers in VBA?

I read in various places that API timers are risky in VBA, that if you edit a cell while the timer is running ... 1).Value = index 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 - How to do late binding in VBA?

I have a function that creates an email via VBA. I made this through Excel 2016. When some of my colleagues ... = email_body olMail.Send End Sub See Question&Answers more detail:os...

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

0 votes

834 views

1 answer

excel - VBA: Modify chart data range

My "Chart data range" is ='sheet1'!$A$1:$Z$10. I'd like to make a VBA macro (or if anybody knows a ... ActiveChart or is there a better way? See Question&Answers more detail:os...

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

0 votes

464 views

1 answer

excel - Create a new object using the text name of the class

Is there a way to set an object to the new instance of a class by using the text name of the ... instance of class(strClassName) End Function See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags