• Filtering a Record Selector (Microsoft Access)

    I need help figuring out how to filter a combobox that serves as a record selector. I set up a box that provides clients name & need it to filter them by agents assigned to each customer once the filter is set but, i cant get it to filter out customers under other agents. I would prefer a...

    mmorrison35 pointsBadges:
  • How to IBM Genius iSeries application connect to Excel VBA

    How to IBM iSeries Access for Windows connect to Excel VBA or can enter data using VBA code?

    Vijay19915 pointsBadges:
  • Copying Outlook messages into Microsoft Excel using VBA

    I'm fairly new to Macros and VBA. So, on a daily basis, I receive roughly 50 emails with one specific subject - Task Completed. Now, I made a rule that moves them directly into a Task Completed folder. But now reading all these emails has pretty much consumed my day. Is there a way I can copy these...

    ITKE409,400 pointsBadges:
  • VBA Exporting to text file

    I am trying to make a VBA to copy multiple cells from excel to notepad in this sort of format: Interface GigabitEthernet1/0/1 Switchport access vlan 990 shut But all I seem to be doing is copying the top line over and over again. Here's the code I've been using: Sub exprtToText() Dim ff As Long,...

    Dozii35 pointsBadges:
  • Break through password on Microsoft Excel VBA

    The project I'm currently working on is to update some macros in in Microsoft Excel. But here's my issue - a bunch of the VBA projects are protected by a password that I don't know. Can I remove / break through those passwords? Thanks!

    ITKE409,400 pointsBadges:
  • Sort implementation for arrays in VBA

    How can I create a sort implementation for several arrays in VBA? Can I use some sort of algorithm or is there something else? Thanks for the help.

    ITKE409,400 pointsBadges:
  • How can I find the last used cell in VBA?

    I'm using VBA and I'm trying to find the last used cell value. Here's what I have so far: Dim last_row As Integer Dim LastRow As Long LastRow = Range("E4:E48").End(xlDown).Row Debug.Print LastRow But my issue is that when I put a single element into a cell, I'm getting the wrong output. When it's...

    ITKE409,400 pointsBadges:
  • Copying data from Excel workbook with VBA

    I'm currently working in Microsoft Excel and I have one workbook that I need to collect data from different files. Here's what I have so far: Do While THAT_DIFFERENT_FILE_SOMEWHERE_ON_MY_HDD.Cells(Rand, 1).Value <> "" And Rand < 65536 then 'I will search if the last row in my main...

    ITKE409,400 pointsBadges:
  • VBA: Wrap function for running time

    I'm using VBA and I'm wondering if there's some form of code that I can wrap a function with so it would let me know how long it took to run. I have to compare several different running times of functions.

    ITKE409,400 pointsBadges:
  • How include a prefix in VBA

    How do I add a prefix when I post a value from a user input form?

    ZFrostyone5 pointsBadges:
  • How to delete specific files in a folder with Access VBA

    I'm looking to delete all files in a folder, except 3 specific ones. All files in this folder are .csv files, and all of the file names are different. Let's call the 3 files I do not want to delete "Jim.csv", "Chuck.csv", and "Matt.csv". Is there a way to delete all files EXCEPT the ones you...

    JimmyJames10 pointsBadges:
  • Microsoft Access. Passing an ID/value to a subform. or between forms

    Hello Everyone. I am using MS Access 2000 I have a form (frm_cboclient)that has a combobox on it that I populate by querying a client table for clientID and client name. What I would like to do then is have a subform that will display all my order infomration from my order table, where the clientID...

    Gryphon0 pointsBadges:
  • AS/400 display X SYSTEM in column 9 and cannot press or reset

    When I input a mass of data to AS/400 through VBA. The AS/400 status will lock in column 9 will display X SYSTEM randomly, VBA will timeout and requiring restart. It will always appear when I send the "ENTER" key to go another pages.

    zaker3235 pointsBadges:
  • VBA: Working with mixed text and var to create dynamic letters

    I would like to store something like this in a table -> WHERE [StartDate] = [Enter the start date:] and then call it into VBA - but every time I try this VBA will put quotes around it.

    concoders5 pointsBadges:
  • VBA Help Needed: How to Unprotect sheet, Update Stocks on Excel sheet, Reprotect sheet

    I was trying to update some stocks and commodities links on a protected sheet by creating a button to update but before the update occurs the sheet becomes protected. If I disable the re-protection of the sheet it will updated the stocks and commodity prices but the columns width doesn’t adjust...

    abcmustafa10 pointsBadges:
  • How to get STAAD output (Member End Forces) to Excel by using VBA

    How do I get STAAD output (Member End Forces) to Excel by using VBA? I want to get all member end forces from staad -- .ANL file to Excel. Can anyone tell me the coding for that?

    harshabec5 pointsBadges:
  • Retrieve details of active email using Outlook VBA

    I'm trying to retrieve details of an Outlook email that is either currently selected or opened through VBA. I can't find any details on how to do it. Thank you very much!

    ITKE409,400 pointsBadges:
  • Outlook email doesn’t send when computer is locked

    I've recently been having issues with sending Outlook emails using Excel VBA. I already have my code to do it, Sendupdate, and it's working fine when it's manually run. I also have an automatic timer that's intended to execute the same email at a specific time. But when the computer is locked, it...

    ITKE409,400 pointsBadges:
  • How to I check if sent messages were replied to yet in Outlook?

    For the most part, I send out a ton of emails and I often forget which ones get replied too. Would there be a way to use a VBA script to look at all the sent messages from the past week and check to see if they were replied? I know a bit about Excel VBA but I'm not sure if this is possible. Thanks!

    ITKE409,400 pointsBadges:
  • Why does recordset field lose decimals?

    I am reading a defined query as a recordset in a VBA module. I calculate a result such as 0.323 but when I set the recordset field (!ROR = tempROR) where tempROR has the decimals, the !ROR field acts like an integer. In the query the ROR field is defined as number with 3 decimals.

    itkegbs20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following