excel-2010
IE.navigate2 fails with protected mode off
I\'m automating IE8 from Excel VBA (Excel 2010, Windows 7) Set IE = CreateObject(\"InternetExplorer.Application\")[详细]
2023-03-25 18:39 分类:问答Randomly choose a value in one column subset by another column
What is the simplest formula I can use to randomly choose a value in column A that is associated with a given B value.So in the table below, I\'m looking to randomly choose an开发者_如何学Python A whe[详细]
2023-03-24 19:48 分类:问答How do I use Macros to copy select data from one worksheet to another on Excel?
I need to create a Macro on Excel to keep track of changing contracts. There\'s already an existing macro that updates the contract data so I need to create another macro...[详细]
2023-03-23 09:53 分类:问答Copying and pasting data using VBA code
I have a button on a spreadsheet that, when pressed, should allow the user to open a file, then copy columns A-G of the spreadsheet \"Data\", then paste the data from those columns on the current shee[详细]
2023-03-22 13:49 分类:问答In Excel, is there a way to determine the method being called by a password protected 3rd-party ribbon button?
I\'m looking to automate a simple process in VBA and need to \"click\" a ribbon button.It开发者_运维知识库 makes the most sense to just call the button\'s underlying method.Is there a way to figure ou[详细]
2023-03-19 15:49 分类:问答Parsing a string as an array in Excel 2010 (without VBscript)
I\'ve got a whole bunch of cells containi开发者_开发技巧ng arbitrary length arrays stored as semicolon-delimited strings, ranging in length from 1 to 65 entries, like:[详细]
2023-03-17 00:00 分类:问答Drop down in Excel 2010 using jxl Parser
I am jusing jxl API to read and write excel files using Java. I successfully created a drop down box using the jxl parser. The created excel format is .xls. When i opened with Excel 2007 the drop down[详细]
2023-03-16 15:00 分类:问答Deleting a work sheet from excel 2010 file using c# [duplicate]
This question already has answers here: Closed 11 years ago. Possible Duplicate: .Net Excel Interop开发者_高级运维 Deleting a worksheet[详细]
2023-03-15 02:51 分类:问答get all unhidden rows in Excel
Is there a way to get an array of all the rows in VBA and then copy them to a new开发者_开发问答 sheet?[详细]
2023-03-13 11:51 分类:问答Excel VBA function that returns all data to a new sheet
How can开发者_如何学Go I create a function that will apply predefined filters etc, and then generate a new sheet with that data?[详细]
2023-03-13 04:33 分类:问答