Recent questions tagged EXCEL

0 votes

1.1k views

1 answer

excel - Extracting the inner text from span using vba

I am trying to scrap some data from a webpage into Excel using vba. The html code is <span id="lastPrice">300 ... can I get the desired output ? See Question&Answers more detail:os...

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

0 votes

912 views

1 answer

excel - VBA, goto cell with a certain value (type: date)

I have code as follow: Sub Find_First() Dim FindString As String Dim Rng As Range FindString = Range("A1") If ... cell with date from cell A1. See Question&Answers more detail:os...

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

0 votes

750 views

1 answer

excel - How to open hyperlink from a cell and save/rename downloaded file from new cell value?

I have a table of links. I want to open each link (they are .csv/.xlsx files on a secure server which I ... Can a loop work between two columns? See Question&Answers more detail:os...

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

0 votes

766 views

1 answer

excel - Auto Filter sort in VBA

I'm making a VBA macro. At one point, the macro tells excel to change the current autofilter ... =xlAscending, DataOption:= xlSortTextAsNumbers 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 send text to some HTML elements through Selenium VBA?

I have been having trouble on referring to a search box on a website through Selenium in VBA. The HTML ... Any help is greatly appreciated. See Question&Answers more detail:os...

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

0 votes

742 views

1 answer

excel - how to have unlocked cells on a protected VBA created worksheet

An input file of data is processed using VBA to create an Excel(2003) protected spreadsheet(Invoice). ... AllowUsingPivotTables:=True End Sub See Question&Answers more detail:os...

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

0 votes

822 views

1 answer

excel - PowerQuery use a cell values in a URL

I have the following PowerQuery code. Which collects some data from MSFT in yahoo finance. I have a cell A1 ... q/bs?s=$A$1+Balance+Sheet&annual See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Embedding Image in Outlook with VBA

The below code isn't working. It embeds the photo but doesn't display because "The file may have been moved, ... Set OutApp = Nothing End Sub See Question&Answers more detail:os...

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

0 votes

807 views

1 answer

excel - VBA Range variable gone after cut

424 error. Would anyone be kind enough to tell me why the range variable was gone after cut? with sheets(1) Dim ... msgbox(des.row+5) end with See Question&Answers more detail:os...

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

0 votes

892 views

1 answer

excel - Getting a .xlsm file to not execute code when being opened with VBA

I have a macro in Excel. Part of that macro opens up other workbooks using Workbooks.Open(Filepath). Some of ... for the equivalent VBA method. See Question&Answers more detail:os...

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

0 votes

846 views

1 answer

excel - I am looking to combine multiple sheets into a single consolidated sheet

Would like to create a Macro to loop through all of the sheets in the workbook and select all the data from ... End If Next wkstSrc End Sub See Question&Answers more detail:os...

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

0 votes

855 views

1 answer

excel - Sender, SenderEmailAddress Missing in Folder.Items

I want to download attachments from Outlook emails. Here is the code I am using to retrieve emails. Set ... admins can put restrictions. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

excel - python Search a string in a column, and return another column value from that same row

I am currently trying to write a script that will evaluate a spreadsheet to search column A for a string, and ... search_str, last_r, cell.row,) See Question&Answers more detail:os...

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

0 votes

763 views

1 answer

excel - PivotTable ShowDetail VBA choose only selected columns in SQL style

While showing details of pivottable with VBA method: Range("D10").ShowDetail = True I would like to choose only ... from Range("D10").ShowDetail See Question&Answers more detail:os...

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

0 votes

801 views

1 answer

excel - Trigger Enter field behaviour through class for a control

I raised a query which now works as per David Zemens' instructions and BrakNicku guidance. Problem is one of ... unable to share the workbook. See Question&Answers more detail:os...

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

0 votes

977 views

1 answer

excel - How do I rotate a saved image with VBA?

I currently have a userform in excel with images displayed on it (saved in a temporary folder "C:TempPhotos") What I ... ("") End If End Sub See Question&Answers more detail:os...

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

0 votes

840 views

1 answer

excel - Suddenly several VBA macro errors, mostly 32809

Suddenly my excel file is generating a lot of errors at startup. No changes have been made to the file since before ... ) MSO (15.0.4659.1001) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Tolerant average (ignore #NA, etc.)

I want to calculate the average over a range (B1:B12 or C1:C12 in the figure), excluding: Cells not being numeric, ... formulas, i.e., non-VBA. See Question&Answers more detail:os...

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

0 votes

704 views

1 answer

excel - Remove directory and it's contents (files, subdirectories) without using FileSystemObject

I want to know if it's possible to rewrite this piece of code: Private Sub PrepareDir(ByVal dir As String) Dim ... it can be done without FSO? See Question&Answers more detail:os...

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

0 votes

748 views

1 answer

excel - Type Mismatch in Loop to scan Outlook Messages

I get an intermittent error when looping through the Outlook inbox using VBA. A type mismatch occurs on the Next ... to filter for that now. See Question&Answers more detail:os...

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

0 votes

687 views

1 answer

excel - Refer to QueryTable objects by name

I am developing a MS Excel 2013 tool with VBA, which involves the use of QueryTables. One inconvenience is ... QueryTable("My Query Table") See Question&Answers more detail:os...

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

0 votes

900 views

1 answer

excel - How to replicate a sheet using VBA Macro (not copy) replicate

How would I replicate a sheet using VBA Macro but not use the VBA copy method? So I want Sheet2 to look ... VBA Macros so please guide me. See Question&Answers more detail:os...

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

0 votes

871 views

1 answer

excel - Doing an array formula lookup

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

0 votes

815 views

1 answer

excel - Convert from US to UK format

How do I modify the following to be D/M/YYYY? 8/7/20 6:20 PM 8/17/20 4:24 PM Currently it is M/D/YY ... for any help on this. It's breaking me. See Question&Answers more detail:os...

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

0 votes

810 views

1 answer

excel - Scraping website data with options in combo box VBA

Hi I am trying to scrape the Product name (Cohiba Robusto), Product Size (Single Cigar, Pack of 3, Box ... = .responseText End With End Function See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

excel - Looping a function for multiple lookups

I'm trying to write a formula that search for a part number in a different sheet, and imports all of ... is a different part number completely. See Question&Answers more detail:os...

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

0 votes

844 views

1 answer

excel - VBA Autofilter (Text Filters) With Multiple Criteria of "begin with"

ActiveSheet.Range("F_Item").AutoFilter Field:=1, Criteria1:=Array("ca*", "inc*", "ps*"), Operator:= ... to search for two conditions only. See Question&Answers more detail:os...

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

0 votes

772 views

1 answer

excel - Macro to change the Pivot filter automatically does not work

I have a report with several pivot tables that run off production data, orders and deliveries. I run it ... previously selected the day prior. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags