VBA
ADODB open recordset fails / "Operation is not allowed when object is closed"
I have the following UDF in excel which uses ADO to connect to my MSSQL server. There it should execute the scalar udf \"D100601RVDATABearingAllow\".[详细]
2023-04-11 12:46 分类：问答Change "Item.To" value in outlook when sending a message using VBA
I\'m trying to change the email address in Send To field in Outlook when the user press send button. for example , if the current Item.To value = \'aaa@example.com\' it becomes \'bbb@example.com\'.[详细]
2023-04-11 10:24 分类：问答Pulling a value from the same location on new sheets created from an Excel template.
I am currently creating a set of templates to be used in a quality assurance excel sheet. The aim is to have the scores from each sheet displayed on the top sheet of the excel 2007 book. Currently I c[详细]
2023-04-11 09:48 分类：问答Table updating - but report is empty. Reopening report shows correct data
Should be an easy one for the experienced? I collect data from multiple other tables and do calculations in VBA with which I add rows with DoCmd.RunSQL to a printout table. (Before this, I delete pre[详细]
2023-04-11 07:33 分类：问答Using regexp in Excel can I perform some arithmetic on the matched pattern before replacing the matched string?
I am using `VBscript.RegExp`` to find and replace using a regular expression. I\'开发者_StackOverflow中文版m trying to do something like this:[详细]
2023-04-11 05:13 分类：问答How can I get a reference to the worksheet an event was generated in?
In a worksheet I can attach code to an event like so: Private Sub Worksheet_Calculate() \' .. code here[详细]
2023-04-11 05:06 分类：问答Excel VBA making different sets based on unique records and salary
I have below data EmpidEmpnamesalaryCompanylocationstatus xxJhon100IBMus x1Phil50IBMus x2Karl30IBMus x3Stev开发者_JAVA百科e20IBMus[详细]
2023-04-11 04:51 分类：问答How to delete rows in Excel based on criteria using VBA?
I am currently building a macro to format a sheet of data as well as to remove inapplicable rows of data. Specifically, I am looking to delete rows where Column L = \"ABC\" as well as delete rows wher[详细]
2023-04-11 04:29 分类：问答Looking for changes in cells - Excel files
I have 2 excel files with a lot of data in each. The data is structured exactly the same in both files but the values might have changed as the data is from two different times.[详细]
2023-04-11 04:09 分类：问答Invoking a SQL Procedure in the database via VBA code
I have an SQL query which takes u开发者_如何学运维p a parameter stored in the db. I want to invoke the same from VBA code which is running on the same db. I am using MS Access for my work.[详细]
2023-04-11 04:03 分类：问答
加载中,请稍侯......