VBA
Error 3021, no current record has been found, Query data from Access to Excel
I\'m writing a function in Excel VBA which will be called to extract data from an Access database, I\'m using ADO connection. The function Get_g_gtop has parameters defined as bellow. Now, I try to us[详细]
2023-04-11 03:56 分类：问答how to reset form (which is bound to joining query)
In my Access 2010 database I have two tables: clients (with columns: client_id, name) and orders (with columns: order_id, client_id, description). I have a query called orders_with_clients which joins[详细]
2023-04-11 03:29 分类：问答User Input of Date as a Query
I have a query which goes like this: StockAnalytics.uDIX - StockAnalytics.dDIX > 0.5 AND (To开发者_StackOverflow中文版day1.uDIX - Today1.dDix) > 0.5[详细]
2023-04-11 02:30 分类：问答How to decode %C3%B8 in vba
How do i decode %C3%B8 in VBA? it is the danish letter ø - I开发者_运维问答t is encoded in UTF-8. I have tried to decode it in vba for use in a excel sppreadsheet with the following function:[详细]
2023-04-11 02:25 分类：问答Click RefreshWorkbook on Bloomberg Ribbon [duplicate]
This question already has answers here: Closed 10 years ago. Possible Duplicate: How to refresh/load RTD Bloomberg function (BDH) in excel in vba[详细]
2023-04-11 02:23 分类：问答How to split a string with multiple delimiters in vba excel?
I want to split a string with multiple delimiters using Excel VBA.One of the strings is: d1-d2 d3 d4 We have a dash and a space as two delimiters. I tried the split function but it only do开发者_如[详细]
2023-04-11 01:54 分类：问答Clear Contents of a Column
How would I clear the contents of a column from cell A3 to cell __ where __ represents the last entry i开发者_如何学JAVAn the column (assuming there are no empty spaces between entries).[详细]
2023-04-10 23:32 分类：问答Offset and end function
I am trying to paste data from Q3 Sheet 1 to Q3 Sheet 2. Each piece of data should be pasted one row below the last piece of data on Q3 Sheet 2 (starting in cell A4). Unfortunately, the line[详细]
2023-04-10 23:29 分类：问答Attach Existing UserForm Button to Excel Workbook Sheet
I have an Excel workbook that has a macro (the only macro in the workbook) attached to a button on a sheet.[详细]
2023-04-10 23:27 分类：问答How do I call a Word Macro with parameters from JScript
I have a Word template with a macro defined in the ThisDocument section: Sub Go(pID As Integer, pPassword As String)[详细]
2023-04-10 22:26 分类：问答
加载中,请稍侯......