Recent questions tagged Excel

0 votes

1.3k views

1 answer

excel - VBA: How to combine two ranges on different sheets into one, to loop through

Trying to read two ranges of equal width but different lengths, each on different sheets, into another range which ... at the Union command. See Question&Answers more detail:os...

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

0 votes

729 views

1 answer

excel - VBA macro to delete rows quickly

I have several really large excel data files and I need to go through them all and delete all rows where the ... have to make it run faster? See Question&Answers more detail:os...

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

0 votes

703 views

1 answer

excel - How to copy data from closed workbooks (keeping them closed) into master workbook using VBA?

I need to copy data from closed workbooks, without opening them, into a master workbook using VBA. I use Workbooks.Open ... ).Range("M4") = Date See Question&Answers more detail:os...

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

0 votes

965 views

1 answer

excel - Countif With Multiple OR Criteria

I need to count the number of cells in a column which contain a specific value. I am currently using the ... cells contain either SAL, or PRE See Question&Answers more detail:os...

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

0 votes

823 views

1 answer

excel - VBA Subscript out of range - error 9

Can somebody help me with this code, I am getting a subscript out of range error: The line after the ' ... " " & ComboBox_Month.Value Next See Question&Answers more detail:os...

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

0 votes

949 views

1 answer

excel - Leave dates as strings using read_excel function from pandas in python

Python 2.7.10 Tried pandas 0.17.1 -- function read_excel Tried pyexcel 0.1.7 + pyexcel-xlsx 0.0.7 -- function ... (type(record['End Date']))) ) See Question&Answers more detail:os...

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

0 votes

961 views

1 answer

excel - Difference between Thisworkbook.name and Activeworkbook.name in VBA

Is there any difference between Thisworkbook and ActiveWorkbook. Example code : Sub workbook_name() MsgBox Thisworkbook. ... doesn't work See Question&Answers more detail:os...

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

0 votes

852 views

1 answer

excel - EntireRow.Delete performance issue

I am trying to delete all rows with blanks values. I have about 15,000 rows and no more than 25% are blank. ... ? Why can't excel handle this? See Question&Answers more detail:os...

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

0 votes

794 views

1 answer

excel - How to extract groups of numbers from a string in vba

I have a string of the following shape: RRP 90 AVE DE GAULLE 92800 PUTEAUX 0109781431-0149012126 The numbers might ... could help me with that? See Question&Answers more detail:os...

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

0 votes

825 views

1 answer

excel - VBA: Remove duplicates fails when columns array is passed using a variable

When the Columns parameter of the RemoveDuplicates is passed using a variable it fails and throws error. Same code works ... _ :=xlYes End Sub See Question&Answers more detail:os...

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

0 votes

851 views

1 answer

excel - VBA: Else without If Error

I'm trying to run the following code, but I keep getting the Else without If Error in the first sub. The ... Nothing Set FSO = Nothing End Sub See Question&Answers more detail:os...

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

0 votes

840 views

1 answer

excel - return csv file as recordset

I have an external program that exports data into CSV files. My users would like to have access to this data ... and loop through the data? See Question&Answers more detail:os...

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

0 votes

990 views

1 answer

excel - Sorting a dictionary by key in VBA

I have created a dictionary in VBA using CreateObject("Scripting.Dictionary") that maps source words to target words ... the keys this way. See Question&Answers more detail:os...

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

0 votes

919 views

1 answer

excel - VBA recognizing workbook by partial name

Is there a way to specify a workbook for a sheet without having the full name? For example, If the workbook ... would I go about doing that? See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

excel - How to take screenshot of webpage using VBA?

How to take screenshot of webpage using VBA in Excel? The problem is that screenshots can be taken only by pressing ... sendkeys "{F6}" end sub See Question&Answers more detail:os...

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

0 votes

840 views

1 answer

excel - The MacScript function is not working well in Office for Mac 2016! Any ideas?

My macros use MacScript heavily, but it doesn't seem to be working in any of latest Office for Mac 2016 preview builds See Question&Answers more detail:os...

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

0 votes

940 views

1 answer

excel - Get values from union of non-contiguous ranges into array with VBA with a simple command (no loops)

I have the following (on the surface of it, simple) task: Copy the values from a number of columns on ... on the part of Microsoft? See Question&Answers more detail:os...

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

0 votes

705 views

1 answer

excel - Create hyperlink to another sheet

The first sheet of my workbook is like a contents page. Each cell in column A holds an IP address string. ... code without explaining any of it. See Question&Answers more detail:os...

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

0 votes

792 views

1 answer

excel - How to open a workbook specifying its path

Sub openwb() ChDir "E:sarathPTMetrics20131004D8 L538-L550 16MY" Workbooks("D8 L538-L550_16MY_Powertrain Metrics_20131002. ... its path? See Question&Answers more detail:os...

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

0 votes

846 views

1 answer

excel - How to create a separate CSV file from VBA?

I need to output some results as a .csv file, that gets parsed later on by another process. In order to ... textual" approach ? Thank you :) See Question&Answers more detail:os...

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

0 votes

942 views

1 answer

excel - VBA Worksheet change event bypass?

I am fixing a spreadsheet. The programmer made a macro for each sheet to fire when the sheet is changed. ... refer to worksheets or ranges. See Question&Answers more detail:os...

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

0 votes

615 views

1 answer

excel - Open a workbook from VBA and disable Workbook_Open() code?

I am opening spreadsheets using VBA and a couple of the workbooks contain code which starts executing when ... want any code execution. See Question&Answers more detail:os...

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

0 votes

768 views

1 answer

excel - How to Send Email When Computer is Locked?

I want to send Outlook emails using Excel VBA. The code Sendupdate works when run manually. My second macro ... sure the email gets pushed? See Question&Answers more detail:os...

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

0 votes

875 views

1 answer

excel - VBA Dialog box to select range in different workbook

I want to allow a user to select a range that is likely to be in a different workbook. I have attempted to ... allows me to perform this task. See Question&Answers more detail:os...

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

0 votes

732 views

1 answer

excel - How to copy only a single worksheet to another workbook using vba

I have 1 WorkBook("SOURCE") that contains around 20 Sheets. I want to copy only 1 particular sheet to another ... . I want only specific sheet. See Question&Answers more detail:os...

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

0 votes

698 views

1 answer

excel - VBA copy cells value and format

How can I amend the following code in order to copy not only the value but also the fonts style, e.g. bold or not ... = a + 1 End If Next i See Question&Answers more detail:os...

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

0 votes

721 views

1 answer

excel - How to change Format of a Cell to Text using VBA

I have a "duration" column in an Excel sheet. Its cell format always changes - I want convert the duration ... s formatting to text using VBA? See Question&Answers more detail:os...

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

0 votes

756 views

1 answer

excel - Executing Word Mail Merge

I have an excel sheet with data and want to export it to a new word document. Is it possible to start MAIL ... clicking a button on the sheet? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags