Search results for query: *

I've been trying to find the code for the excel function XIRR but can't find it anywhere. Can anyone help? Thanks.

I am trying to find the median of a single set of values produced in a query in access, the code I am using is as follows: Function FindMedian(rst As Recordset) As Double Dim rst As Recordset Dim intCount As Integer Dim dblValue1 As Double Dim dblValue2 As Double Set rst =...

I am deisgning a VB app that will open and close different XL spreadsheets and copy and paste data between them. I have copied the macros into the app which run fine after defining the object etc. but I cannot seem to minimise one of the sheets in the taskbar - keep geeting errors! Although if a...

I am exporting an Excel Macro into a VB app but keep getting errors. I want the Macro to run in the current open xl workbook. Do I need any code before the macro? Here is some of the macro: Sheets("Model").Select Columns("IV:IV").Select Selection.ClearContents...

I have written a macro in XL and exported it to a VB app I'm working on. I have copied it into a sub proc in VB but getting errors when it hits the first line of the macro. What am I missing? Sorry - newbie! Thanks, Kev.

Thank you, but will this automatically update the links or do I have to use any more code? ...sorry...newbie!

I have a VB app that opens a xl sheet that contains linked fields via DDE so upon opening I have to click YES to update the fields. Is there any code I can use so the sheet automatically updates? Many Thanks, Kev.

Please could someone let me know the code to open and close an XL spreadsheet from within a module in access, and if it is possible to automate this so this happens at a specified time. Many thanks, Kev.

Hi, I am trying to create a sequential list of numbers in a query, i.e. if I put in 3,5,0.5 to a module in a query it would output 3,3.5,4,4.5,5 in 1 column of a query. I have written the following but I don't know how to export the data into a query: Public Function poprange(rlow As Double...