My Excel does not recognize LongLong data type needed to run the ActiveX version of Interactive Brokers Trader Workstation Excel dde spreadsheet. It appears that I need to be running a 64 bit version of Microsoft Office. What is the best way to do this and could this cause any problems with existing Office applications that I run.  Thank yo very much!

Hi,

I want to find highest values' Row and Column in an array in Excel.
The file is attached for the reference.Get-Highest-Value-in-Array.xlsx

Thanks,

San.

Hi Experts

I have a daily report that shows what our warehouse team has put into stock for the previous day - on Sheet 1 is :-

Column A has the date of the transactions
Column B as the hourly bracket
Column C has the actual posting time of the transaction
Column D has the location with which they have mad the transaction
Column E has the quantity that was posted to inventory

On Sheet 2 I have put some labels in the cells such as :
Quantity replenished before 2pm
Quantity replenished after 2pm
Number of locations replenished before 2pm
Number of locations replenished after 2pm

For the above on Sheet 2 Ive tried using the data on Sheet 1 and various Count If / Sum if combinations to get the results for the four summaries above on Sheet 2, however Im having difficulty in using the time as part of the formula

I've also tried to use SUMPRODUCT / FRREQUENCY as Column D has duplicates that need to be counted as 1 fulfilled location and not counted per entry

Is there a way using the time in Column C on Sheet 1 to a) sum the quantities put away before and after 2pm and b) count the number of locations that were used before and after 2pm

Any assistance would be greatly appreciated

J
Pickface-Replenishment--3-.xlsx

I have a large number of excel files I need to open and run a macro to count columns and count non-blank and blank values on a row.  The first 8 columns are the same and then after ~ the columns per file various.  It could be 1 column to 45 columns.  Also a file could have only 1 record or it could have over 300 records.  I am trying to figure out a way to open all of the files at once apply the macros to remove a few columns and add 3 columns to hold the "total count", "blanks", and "completed" values, along with having  the output from each file combined into one larger file.  Any help would be greatly appreciated.

Excel calendar from "MicrosoftMonthView" creating double calendar.
I HAVE ALSO TRIED MICROSOFT DATE AND TIME PICKER, IT DOES THE SAME THING, CREATES A DOUBLE.
I want only one single calendar, not two.
If you maximize then restore the second calendar window disappears, but I don't want to have the use do that everytime when they open.
Book1.xlsm

Our FE.mdb front end database runs in "user mode" which means: special keys off; navigation off; full menus off; etc
But Joe needs a "tester mode" with special keys ON.

Currently, we accomplish this manually: v
Joe opens FE.mdb then clicks File > Privacy Options > Current Database > Use Access Special Keys > OK
After closing and reopening FE he is in "tester mode".

But he needs to do this every day because our network signon script always recreates c:\front end\fe.mdb from the server's FrontEndMaster folder.

I am planning on modifying the signon script so that Joe's refresh comes from a FrontEndSpecial folder which I must carefully maintain. Is there a cleaner  approach?

When I create an invoice for my customers, alot of my customers decide to pay me over time. Those that opt in to pay over time make a monthly payment to me. As I run some reports, I am trying to figure out two things: 1. How many months does it take for each invoice to get paid in full? 2. In how many months is 1/2 the invoice amount paid. I want to know this because when 1/2 the invoice is paid, I offer them other discounts. I attached a sample of my report I export. I added two columns (B and C). I put the answers in those columns that I am hoping you can help me with the formula. So, can you please help me with the formulas in columns B and C? Thank you in advance!!!
Data-Sample.xlsx

The variables lRow and lCol will only show the correct information on the first loop, the following loops is a report on the first loop. A similar thing happens if I use LastRow variable.


Public Function ExportToExcel(ReportFilterType)
' Tools > References > Microsoft Excel Object Library

On Error GoTo Error_Message
'Requires Reference to Microsoft Excel Object Library
 Dim rsMainList As DAO.Recordset
 Dim rsExport01 As DAO.Recordset
 Dim rsExport02 As DAO.Recordset
 Dim rsExport03 As DAO.Recordset
 Dim sqlExport01 As String, iCol01
 Dim sqlExport02 As String, iCol02
 Dim sqlExport03 As String, iCol03
 Dim xlObj As Object
 Dim xSheet01 As Object 'Upload File
 Dim xSheet02 As Object 'Batch Summary
 Dim xSheet03 As Object 'Batch Detail
 Dim strFolder As String
 Dim LastRow As Long
 
 On Error Resume Next
 DoCmd.Hourglass True
 Set rsMainList = CurrentDb.OpenRecordset("SELECT DISTINCT UPLOAD_ID, VISUAL_BATCH_ID, VISUAL_BATCH_TYPE, VISUAL_DATABASE  FROM VMTBL_NI_VM_ORCL_GL_UPLOAD_STAGING")
 If rsMainList.EOF Then Exit Function
 rsMainList.MoveFirst
 
 strFolder = CurrentProject.Path & "\"
 
 Do Until rsMainList.EOF
   
    Set xlObj = CreateObject("Excel.Application")
    xlObj.Workbooks.Add

    sqlExport01 = "SELECT Database, [Posting Date], [Account Combination], Co, Div, Fun, Rig, Job, AFE, Maj, Min, [I/C], [Debit Amount], " + _
    "[Credit Amount], [Total Amount],[GL Description], [Upload ID], [Batch ID], [Currency ID] " + _
    …

Hello, so I have this Excel table (facsimile):


I've been asked to make it so that the table can be printed using the second column as a way to split it into more tables. So, the data should be grouped depending on the second column value.

So this table should be printed on 3 pages, and we'd get these 3 tables, one on each page:


Does Excel have some quick way to do this which I don't know of? Do you have any suggestions?

Thanks.

Hello experts,

The following procedure allows me to add string on multiple columns.

Sub Add_Specific_String_Multiple_Columns()
    
    Dim strSpecificChar As Variant    'New declaration in order to add numeric and non numeric values
    Dim strCol As Variant
    Dim strColList As String
    Dim lngLastRow As Long, lngRow As Long
    Dim intWhich As Integer
    Dim intWhich_temp As String
    Dim strToAdd As String
    
    On Error GoTo Error_Routine

    intWhich = 0
    intWhich_temp = InputBox("Please report value related to the action that you want to perform: 1 for adding string at the beginning 2 at the end")

    If intWhich_temp = vbNullString Then
        MsgBox ("No input!")
        Exit Sub
    End If

    If IsNumeric(intWhich_temp) Then intWhich = intWhich_temp

    Select Case intWhich
        Case 1, 2
        Case Else
            MsgBox "Please enter '1' or '2'"
            Exit Sub
    End Select

    strColList = InputBox("Please report column letter(s) following by ; in which you want to apply procedure," _
        & ": A for single column A;C;D for multiple columns", "Choose Column Letter(s)")
    If strColList = vbNullString Then
        MsgBox ("No input!")
        Exit Sub
    End If
    
    
    strToAdd = InputBox("Input the value that you want to add.", "String To Add!")
    
    If strToAdd = "" Then
        MsgBox "No input!", vbExclamation
        Exit Sub
    End If
    
    For Each strCol In Split(strColList, ";")
        

Select all Open in new window

…