excel-2003_开发者

Excel VBA - How To Insert Plain Value without Formula?

I have skimmed many Excel VBA topics, however, I have not found any information about inserting plain values - the result of SUM() in this case - not formula. There is a method, PasteSpecial xlPasteVa[详细]

2023-03-01 01:15 分类：问答

How can I get Excel to release its lock on another Excel file I've accessed using ADO?

I\'m using a VBA macro in an Excel 2003 document to query another Excel 2003 document via ADO. The code looks something like this:[详细]

2023-02-28 08:39 分类：问答

I would like the dates to appear on the X-axis and the colour category to apear on the Y-axis, Excel

there is probably a fairly straight forward answer out there but I can not seem to find a solution online.[详细]

2023-02-27 07:28 分类：问答

Excel 2003 - assign a custom/user-defined property to an individual cell?

Does the Excel cell object expose \"custom\" properties? I\'d like a cell to have a \"tag\" which will be used in a VBA function, however, I don\'t want this \"tag\" to be visible to a user.[详细]

2023-02-25 11:47 分类：问答

Excel - Macro to compare /match multiple cells in a row between two sheets, and copy the entire row to the second sheet

i\'m looking for macro to match multiple cells in a row between two sheets, and copy the entire matched row from the first sheet to place beside the matched row from the second sheet.[详细]

2023-02-25 03:50 分类：问答

Are there libraries available for processing(reading) Excel 2003 XML documents

We have a situation where Excel\'s XML 2003 format is widely used for file uploads to a third party system. There is a requirement that some information needs to be extracted from these files for othe[详细]

2023-02-25 00:00 分类：问答

Excel VBA: How to Read file names of type PDF and spit them into a column on a sheet

In Excel 2003 is there any way to read pdf file names from a single director开发者_开发问答y and put them inside an Excel spreadsheet?Dim c as Range, tmp[详细]

2023-02-21 02:36 分类：问答

Is Excel Shape.TextFrame.Characters.Insert broken on Excel 2007?

I\'ve got this piece of code I\'ve been using Excel 2003 which mimics a solution given on the Microsoft website from a while back. How to add more than 255 characters to a shape\'s text frame:[详细]

2023-02-20 13:23 分类：问答