• Rename Microsoft Access table using VBA

    I'm sorry for the short question but does anyone know how I can rename a Microsoft Access table through VBA from Microsoft Excel? Appreciate the help.

    ITKE828,870 pointsBadges:
  • How to tell if Microsoft Excel cell is within a given range

    How can I tell if a Microsoft Excel cell is within a given range in VBA? What's the best way to do this? Thank you so much.

    ITKE828,870 pointsBadges:
  • How to delete empty Microsoft Excel rows using VBA

    What's the best way to delete empty rows in Microsoft Excel using VBA? I tried several times but I keep getting this error message: Run time error '1004': No cells were found. Thanks!

    ITKE828,870 pointsBadges:
  • Lock data in Microsoft Excel cell using VBA

    In Microsoft Excel, can I stop other users from editing the content in a certain cell using VBA? Basically - I need to lock the data.

    ITKE828,870 pointsBadges:
  • How to round in Microsoft Access and VBA

    By any chance does anyone know how to round in Microsoft Access / VBA? I figured out how to do it in Excel but I don't want to rely on that.

    ITKE828,870 pointsBadges:
  • VBA: Set bold on specific text in Microsoft Excel string

    In Microsoft Excel / VBA, can I bold specific text in my string that would go into my cell? What formula should I use?

    ITKE828,870 pointsBadges:
  • VBA: Call FM SAPWL_STATREC_READ_REMOTE failed

    Hi Experts, We monitor the response time of different SAP and Customer programs before and after any release change. We use the workload statistics in transaction STAD and export the data into Excel manually. We would to automate this process by using Excel VBA Script and download the workload...

    walidde20 pointsBadges:
  • What are the basic parameters needed to assist an automation tool?

    My concern is what are the basic key parameters to be considered for assisting an automation tool. In my company we are automating database (MySQL - Queries) part using 1st approach: Using stored procedures. 2nd approach: Using Excel VBA Macros.  For that we need to assist some basic parameters...

    VijayVardhan5 pointsBadges:
  • 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:
  • Excel has file big size

    Hello, I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns. Each day we create a copy of this file, and in the new copy, change the numeric value of 20 cells. No new columns or rows are added, there are no graphics/charts/etc. There is only one sheet. 10...

    RossHutton15 pointsBadges:
  • Compact Microsoft Access database in VBA

    My apologizes for the brief question but, in Microsoft Access, can I compact my current database using VBA? Thanks!

    ITKE828,870 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...

    ITKE828,870 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!

    ITKE828,870 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.

    ITKE828,870 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...

    ITKE828,870 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...

    ITKE828,870 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.

    ITKE828,870 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:

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