Recent questions tagged excel

0 votes

1.4k views

1 answer

excel - Comparison of Dictionary, Collections and Arrays

I am trying to work out the relative benefits and features of dictionaries compared with collections and arrays. I ... Does anyone know of one? See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

excel - Check if Cell value exists in Column, and then get the value of the NEXT Cell

After checking if a cell value exists in a column, I need to get the value of the cell next to the ... returned to achieve the desired result? 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 suppress Update Links warning?

I'm trying to write a script that opens many Excel files. I keep getting the prompt: This workbook contains links to ... , I'm using Excel 2010. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

excel - Bad data selection using VBScript , on date field values

I have a sheet which contains data as below: Now the Excel is having 36 total tasks,Each tasks has 4 columns ... marked the bad columns in RED See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

excel to pdf ignores print area and calls printer

This loops through a list of students, but fails on the print area, which is set and coded in the export line ... Next rCell End With End Sub See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

excel - Using a variable for row in (row,column) for a range in VBA

I have a global variable called processRowBegin that contains the row number for the beginning of a process. I also ... , please let me know. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

excel - If string contains word from list, return value adjacent to list value

Currently I have a set of cells, and each has, among useless information, a unique identifier. I also ... practice with my specific example? See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004

I am trying to create a Sub that places a SUMIF formula in a cell. I have reduced the problem to a ... suspect the semicolons in my formula. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

excel - Email a single attachment from folder of files each to a different person

I have a folder with 50 files and I have a list of 50 email addresses. Each file goes to a different ... ScreenUpdating = True End With End Sub See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

excel - Workbooks.Open Method in VBA

My vba script in myMacro.xls Workbooks.Open Method work well as below, Workbooks.Open Filename:="D: ... your read and reply. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

excel - VBA - How the colon `:` works in VBA code with condition

The colon operator : is a statement delimiter in VBA. However, does anyone has a clue why the first three examples ... Debug.Print "8c" End Sub See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

excel - Change font color for a part of text in cell

I have cells which will contain the below value "Image not allowed|png" I want to change the color of |png ... text color(|png) using VBA? See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - How can I kill task manager processes through VBA code?

I'm trying to kill certain processes through VBA. I have a proprietary object that connects to a market data ... a process through VBA? Thanks See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

excel - Using VBA to detect which decimal sign the computer is using

Is it possible to use VBA to detect which decimal sign is being used on the computer? I have a macro script ... ).Font.ColorIndex = 3 End With See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

excel - Combine Multiple Tables Rows Into Master Table

Happy Monday Everyone! Have a question and hope you can help. I have a budget spreadsheet that has a budget ... an addon called power query. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

excel - Fully reference a worksheet by codename

When I reference Excel worksheets using the CodeName property, how do I fully qualify them including the workbook ... the sheet's codename. See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

excel - Sending mail using Outlook where the Send method fails

I use this code to send email from Excel: Sub Mail_workbook_Outlook_1() 'Working in Excel 2000-2013 'This example ... it is not working ether. See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - VBA WinHTTP to download file from password proteced https website

I'm trying to save a file from https password protected site using WinHTTP. Here's the code: Sub SaveFileFromURL( ... cannot save it? Any clues? See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - How to convert 32 bit VBA code into 64 bit VBA code

Im trying to run a macro code but since I'm using a 64 bit Excel 2016 this code is not working. Please ... _ ByRef ppvObject As Object) As Long See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

excel - How to create a range from two ranges in VBA?

I have two ranges, each containing a single cell (for example "A1" and "C3"). How do I get a new range ... R1C2") instead of Range("A2"). See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

excel - Copy sheet and get resulting sheet object?

Is there any easy/short way to get the worksheet object of the new sheet you get when you copy a worksheet ... a more elegant, shorter solution. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

excel - Detect if range is empty

I want to check if a range in Excel is empty. How do I write in VBA code: If Range("A38":"P38") is empty See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

excel - Select method of Range class failed via VBA

This is the code that I'm currently working with, and I'm getting this problem. I'm novice at Excel and ... '_Worksheet' failed, error 1004. See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

excel - Passing variable from Form to Module in VBA

I have the following button on a Form: Private Sub CommandButton1_Click() Dim pass As String pass = UserForm1. ... be much appreciated. Thanks. See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

excel - How to add a button programmatically in VBA next to some sheet cell data?

I have a function that generates data for say 100 rows (and 2 columns). For each row (in the 3rd column) I ... from. Any idea how to do this? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

excel - PowerQuery: How can I concatenate grouped values?

If I have the following table (shown in the image below), how can I write a grouped query that would ... So the desired results would be: See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

excel - What indicates an Office Open XML Cell contains a Date/Time value?

I'm reading an .xlsx file using the Office Open XML SDK and am confused about reading Date/Time values. One ... place to find this information? See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

excel - Difference between 'on error goto 0' and 'on error goto -1' -- VBA

Can anyone find the difference between 'On error goto -1' and 'on error goto 0' in VBA? I've tried google and msdn, but I've had no luck. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags