excel-2003

相关标签：javascript jquery android 多少钱 iPhone

Getting data from a complex query to excel

I\'ve got a query which I want to depend on certain parameters from an excel sheet, but I get the error \'parameters are not allowed in queries that can\'t be displayed graphically\'. The only way to[详细]

2023-01-27 02:19 分类：问答
Excel 2007, one instance working causes others to hang? I'm sure this wasn't the case in 2003

I\'m working on some VBA heavy sheets in Excel 2007.At my previous work we had a lot of sheets which were calc-ing for a long period ( valuing trades etc ) and if you opened another 2003 session compl[详细]

2023-01-26 10:05 分类：问答
play sound triggered by click on form control

I\'m trying to trigger a sound by clicking on a form control in Excel 11.The handler for the click event t开发者_JS百科ries to play a sound using sndPlaySound32 if it finds certain text on the clipboa[详细]

2023-01-25 17:11 分类：问答
C# code to Hide toolbars in an excel document

I have a C# Winforms program that opens an excel document with 开发者_运维问答the code below. It works great but what I can not figure out how to do, is to turn off ALL menu\'s and toolbars.[详细]

2023-01-25 16:08 分类：问答
Pulling Column Names into Excel from SQL query

I\'m using Excel to pull data from an SQL db. I used the code from another SO question and it works fine. Now I want to pull in the column names from a table in addition to the actual table. I figured[详细]

2023-01-25 10:46 分类：问答
Querying XML doc with Excel VBA

I\'m building a list of nodes I need to load from XML document using SelectNodes(xpath): Set oNodeList = xmldoc.selectNodes(\"//Object/Property[@Name=\'Group\' and Value=\'True\']\")[详细]

2023-01-25 04:25 分类：问答
Using an Excel macro to query a spreadsheet

So I have开发者_运维知识库 some data in some spreadsheets and I\'ve found that for all the macros and filtering and forumlas I\'ve written to simplify it and narrow it down to what I want, it would ha[详细]

2023-01-23 06:46 分类：问答
C# - Excel - how to get the criterias available for the autofilter() method

I want to use the autoFilter() method to filter some rows. I\'ve managed to activate the autoFilter() method on a selected range (the whole sheet) with no problem.[详细]

2023-01-22 03:27 分类：问答
How to copy the rows filtered by the AutoFilter() method

I\'ve been using the AutoFilter() method with no problem so far. but I wasn\'t able to mark or get the range of the filtered rows, to count/copy/delete them.[详细]

2023-01-21 07:03 分类：问答
Excel merge columns

Hi all I want to merge to columns in excel 2003. For example: Col1Col2 ------------ 15 3开发者_Go百科4[详细]

2023-01-21 03:07 分类：问答