Recent questions tagged EXCEL

0 votes

813 views

1 answer

excel - Download pictures from url and save in a folder named by a cell

I have a worksheet with folder names, image names and urls. I want to download each image to the specific folder so ... " End If Next i End Sub See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - vba button - find which was clicked

I have assigned macro to few buttons. How can I find out inside macro which button was clicked? I am doing as user ... (r.Row, r.Column)).Select See Question&Answers more detail:os...

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

0 votes

922 views

1 answer

excel - Difference between DateValue and CDate in VBA

I am new to VBA and I am working on a module to read in data from a spreadsheet and calculate values based on ... one is the better one to use. See Question&Answers more detail:os...

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

0 votes

890 views

1 answer

excel - Create xls file using PL/SQL without going through xml

My system is developed in APEX/Oracle 11g, and I want to create an xls file directly without having to ... within APEX to accomplish this? See Question&Answers more detail:os...

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

0 votes

860 views

1 answer

excel - Creating VB array that is public, within class module

Quick summary - Im working with some legacy code where I need to add a class with string arrays and tripped up ... up by something obvious... See Question&Answers more detail:os...

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

0 votes

964 views

1 answer

excel - Catch event on chart click

I need to catch event in Excel VBA when I click on the chart. I want to bring the chart to the front, when ... the chart is on a certain sheet? See Question&Answers more detail:os...

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

0 votes

848 views

1 answer

excel - Filtering Out Specific Value

I want to filter out a specific value in a column, but the record feature seems to only support selecting specific ... " to filter "apple" out. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Adjusting worksheet zoom level based on screen resolution

I have an Excel 2003 macro to adjust my screen zoom based on the screen resolution. Sub Macro1() Dim ... open in any system screen resolution See Question&Answers more detail:os...

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

0 votes

987 views

1 answer

excel - Opening semicolon delimited CSV file

How does one open a semicolon delimited CSV file with VBA in Excel 2000? Sample data An ID;TEST20090222 A ... language settings do you have? See Question&Answers more detail:os...

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

0 votes

870 views

1 answer

excel - How to open a file from an archive in vba without unzipping the archive

I have a serie of archives : C:/archive1.zip, C:/archive2.zip, etc. I want to extract only one file from ... file Myfile.csv in vba ? Thanks! See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - Pandas: to_excel() float_format

I'm trying to get the float_format parameter working with pandas' to_excel() function, but it doesn't seem to ... format floats in to_excel()? See Question&Answers more detail:os...

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

0 votes

829 views

1 answer

excel - Get dropdown value in VBA and get the name of the dropdown...nowhere to be found?

I created a dropdown by dragging the combo box onto my sheet from the UserForm toolbar. I assigned some values ... nowhere in the properties!)? See Question&Answers more detail:os...

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

0 votes

874 views

1 answer

excel - What is the easiest way to take two columns of data and convert to dictionary?

I have a worksheet with data in columns A and B. I am looking for a convenient way to take these ... am already referencing the scripting dll. See Question&Answers more detail:os...

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

0 votes

862 views

1 answer

excel - Prevent the "Update Values:" dialog box from opening every time a cell with a link is modified

Quick version: I've got broken links in a file I'm working with because they're pointing to ... .Calculation = xlCalculationAutomatic End Sub See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - CopyPicture method of range class failed - sometimes

I have a VBA code which I am using to copy ranges as a picture and paste them into a chart. It ... Application.DisplayAlerts = True End Sub See Question&Answers more detail:os...

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

0 votes

889 views

1 answer

excel - VBA Object doesn't support this property or method

I need to simply count the number of areas on a sheet. The code I have is : Sub areas() Dim i As Long i ... help? I am using Excel 2010. Thanks. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Color Entire Row Based on Cell Value

I'm trying to color an entire row if two cells in that row have the same value. For i = 2 To ... , 1).EntireRow.Interior.ColorIndex = 5296274 See Question&Answers more detail:os...

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

0 votes

948 views

1 answer

excel - VBA method 'range of object' _Worksheet failed suddenly coming up when running code?

This code used to run fine, then all of a sudden it started failing on "method 'range of object' _Worksheet ... CR1)) Thanks in advance guys 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 generate an .xlsx using php

I need to generate an Excel file with extension .xlsx. Here is my simple code: $file = "test.xlsx"; header ... is not valid. Any ideas? See Question&Answers more detail:os...

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

0 votes

776 views

1 answer

excel - Prevent the "Update Values:" dialog box from opening every time a cell with a link is modified

Quick version: I've got broken links in a file I'm working with because they're pointing to ... .Calculation = xlCalculationAutomatic End Sub See Question&Answers more detail:os...

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

0 votes

934 views

1 answer

excel - CopyPicture method of range class failed - sometimes

I have a VBA code which I am using to copy ranges as a picture and paste them into a chart. It ... Application.DisplayAlerts = True End Sub See Question&Answers more detail:os...

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

0 votes

856 views

1 answer

excel - VBA Object doesn't support this property or method

I need to simply count the number of areas on a sheet. The code I have is : Sub areas() Dim i As Long i ... help? I am using Excel 2010. Thanks. See Question&Answers more detail:os...

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

0 votes

915 views

1 answer

excel - Color Entire Row Based on Cell Value

I'm trying to color an entire row if two cells in that row have the same value. For i = 2 To ... , 1).EntireRow.Interior.ColorIndex = 5296274 See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - VBA method 'range of object' _Worksheet failed suddenly coming up when running code?

This code used to run fine, then all of a sudden it started failing on "method 'range of object' _Worksheet ... CR1)) Thanks in advance guys See Question&Answers more detail:os...

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

0 votes

942 views

1 answer

excel - How to generate an .xlsx using php

I need to generate an Excel file with extension .xlsx. Here is my simple code: $file = "test.xlsx"; header ... is not valid. Any ideas? See Question&Answers more detail:os...

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

0 votes

868 views

1 answer

excel - Imitating the "IN" Operator

How can one achieve: if X in (1,2,3) then instead of: if x=1 or x=2 or x=3 then In other words ... imitate the IN operator in VBA for excel? See Question&Answers more detail:os...

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

0 votes

885 views

1 answer

excel - Return a value of '1' a referenced cell is empty

In Excel, I need to return a value of 1 if a referenced cell is empty I can do it if the value is zero but how do I do it if it is empty? See Question&Answers more detail:os...

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

0 votes

857 views

1 answer

excel - Optimizing VBA macro

Macro works as follows: We have a program recording values in intervals of 1-120s, data from it is on Sheet2 ... If Next i All help appreciated See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags