jet

Hey everyone, I've got xlsm files used by multiple devices to handle supervision at a client of mine, it works fine on older devices (win10 computers and win10 ARM tablets) but a newly installed windows 10 computer runs into an error at one point into the script when the code tries to invoke...

Hello! I am trying to find a way to automate a monthly process where I am downloading sales data from Jet.com/ Sears.com. Ideally, I would paste the data on a "jet" and "sears" tab each month, and then have it pull into the correct columns on a third upload sheet, if it occurred in whatever...

https://imgur.com/Dlb67mk I have a spreadsheet with different companies and how much they charge for gas. I need to make an if formula that will put the company name with the cheapest of each gas type in the "Jet Fuel Vendor" and "AVgas Vendor". The exact wording of what I need to do is Using...

Hi All, I have a linked table in many excel files that pulls in a data range from a master file via a connection string shown below. Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Users\Files\Content.MSO\DD83F92E.xlsm;Mode=Share Deny Write;Extended Properties="HDR=YES;";Jet...

Hello all Running this... Public Sub DBQueryRunExecution() Dim DBFullName As String Dim Cnct As String, Src As String Dim Connection As ADODB.Connection Dim Recordset As ADODB.Recordset Dim Col As Integer Dim LR As Long Dim DB2U As Long Dim FilterStr...