VBA
How to get the template filename which is currently been executed?
I have a word 2003 .Dot template that stands in the STARTUP folder of the user. I have in this template some modules with autoexec procedures.[详细]
2023-04-12 06:54 分类：问答Copy Legend of Chart to Powerpoint with VBA
I work on an excel script that creates powerpoint slides. On a powerpoint slide, I want to show the legend of a chart, but not the rest of the chart.[详细]
2023-04-12 05:49 分类：问答MS Access Serializing Complex SQL Fields?
It\'s not really complex.Basically, some data are stored as normal \"Text\" field but uses the built in Combo Box as Display Control.This is all fine and good except now when I try to export all the d[详细]
2023-04-12 05:16 分类：问答Block if without end if - VBA Error
This is a small snippet of the code I am writing. It seems to throw an "BLOCK IF WITHOUT END IF" error on the last line. I can\'t spot an error here, after consulted with this MSDN link[详细]
2023-04-12 05:12 分类：问答Are there any coding standards for VBA within Excel?
Especially, I\'d like to know when it is appropriate to output one or other of the standard error codes (viz#N/A, #REF!, #NAME?, #DIV/0!, #NULL!, #VALUE! and #NUM!) in response to bad i开发者_如何学Go[详细]
2023-04-12 04:33 分类：问答How can i use a record i found in database to perform other operations
I was searching for a record in my d开发者_如何学JAVAatabase and now that the record is found I want to know how can I use it[详细]
2023-04-12 04:10 分类：问答VBA if condition is true, however actually is false, what's wrong with it?
I wrote code in VBA to extract data from Access database to Excel based on some input parameters. When it comes to If statement, one of the criteria which exam the range of \"Speed\" variable is true,[详细]
2023-04-12 02:28 分类：问答Public array to shuffle values between subroutines?
How do I get a public array whose values are set within a subroutine and do not get cleared at the end of the sub in which they were set?[详细]
2023-04-12 02:18 分类：问答Do parenthesis in array declaration matter?
Does (Excel) VBA dis开发者_开发问答tinguish between: Dim Ghadafi as Variant and Dim Ghadafi() as Variant[详细]
2023-04-12 02:04 分类：问答Is there any way I can speed up this VBA algorithm?
I am looking to implement a VBA trie-building algorithm that is able to process a substantial English lexicon (~50,000 words) in a relatively short amount of time (less than 15-20 seconds). Since I am[详细]
2023-04-12 02:01 分类：问答
加载中,请稍侯......