excel-2010
How to Ignore wildcards in the range.find function
Is it possible to treat wildcards as normal chars in the range.find function. I 开发者_运维问答am searching through a list for string matches, but am running into issues, as some of the strings conta[详细]
2023-02-18 19:00 分类:问答Why does the modulo function in excel return the divisor?
I have an Excel validation f开发者_JAVA百科ormula which worked fine in Office \'03, \'07, but is failing in 2010.Did they change the definition of MOD recently?[详细]
2023-02-18 15:30 分类:问答How to edit info in cells displayed via macro code in Excel?
I have a macro so that when you highlight a row on sheet1, the macro takes all the info from this row and displays this by itself on sheet2. If you highlight a different row on sheet1, the info on she[详细]
2023-02-17 11:52 分类:问答VBA to import Excel Spreadsheet into Access line-by-line
I\'m debugging some code and need to find out where a DoCmd.TransferSpreadsheet acImport, , \"..... fails so I\'ve decided to import it \'manually\' line-by-line to see where it falls over.[详细]
2023-02-17 09:31 分类:问答How would I display selected row on a new work sheet? [duplicate]
This question already has answers here: Closed 11 years ago. Possible Duplicate: How to edit info in cells displayed via macro code in Excel?[详细]
2023-02-17 09:02 分类:问答Linking cells from 2 different excel files, but then keeping figures if emailing only one file?
I\'m wondering if anybody can help? I have a large number of Excel files. These are commission statements and some are converted from USD to UK Sterling, from UK sterling to Euros etc etc.[详细]
2023-02-16 10:54 分类:问答Excel 2010 VBA: Set the color of a cell reference cell in previous column
I havemacro that populates a sheet, and copies values into a grid. I want to add conditional formatting to the cells, so that when they are updated if they become greater than the previous column they[详细]
2023-02-15 02:53 分类:问答Office 2010 query crashes
Office 2010 causes MSQuery to crash when running a big query like this: SELECT TRANSACTION_DETAIL.ACCT_ID, TRANSACTION_DETAIL.ACCT_DESC,[详细]
2023-02-13 06:40 分类:问答Why does GetWindowThreadProcessId return 0 when called from w3wp.exe
When running the following code, GetWindowThreadProcessId returns 0. I\'ve read about the same problem happening with a service, but this code is being run as an Application Pool in IIS (namely, w3wp.[详细]
2023-02-11 03:59 分类:问答Query Tables (QueryTables) in Excel 2010 with VBA with VBA creating many connections
I\'m following code I found on another site. Here\'s the ba开发者_如何学Gosics of my code: Dim SQL As String[详细]
2023-02-08 22:01 分类:问答