I have the following UDF in excel which uses ADO to connect to my MSSQL server. There it should execute the scalar udf \"D100601RVDATABearingAllow\".
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\'.
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
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
I am using `VBscript.RegExp`` to find and replace using a regular expression. I\'开发者_StackOverflow中文版m trying to do something like this:
In a worksheet I can attach code to an event like so: Private Sub Worksheet_Calculate() \' .. code here
I have below data EmpidEmpnamesalaryCompanylocationstatus xxJhon100IBMus x1Phil50IBMus x2Karl30IBMus x3Stev开发者_JAVA百科e20IBMus
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
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.
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.
加载中,请稍侯......