• VBA: Find file name when downloading

    I'm currently trying to download a file from Internet Explorer and save it through VBA. But when it's downloading, I need to figure out the file name too. How can I do that?

    ITKE977,180 pointsBadges:
  • Tree view related bug in VBA

    One of my colleage getting this error after upgradation of Office 365: Can't exit design mode because control tree view 1 can't be created in VBA. Please help me on this. Thanks in advance!

    swapnaserudla5 pointsBadges:
  • Using VBA (in Excel) how to find attachment size for an email in Lotus Notes?

    I am creating an Excel macro to automatically send some information including a few zip files. We use Lotus Notes 6.5 as email client. I want to make sure though that the total email size does not exceed the maximum for our server. How can I do this in VBA? Can I find what is the maximum size on...

    Unknown12345 pointsBadges:
  • 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.

    ITKE977,180 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.

    ITKE977,180 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!

    ITKE977,180 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.

    ITKE977,180 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.

    ITKE977,180 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?

    ITKE977,180 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!

    ITKE977,180 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...

    ITKE977,180 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!

    ITKE977,180 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.

    ITKE977,180 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...

    ITKE977,180 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