• VBA Macro to pull data from secure website to excel

    I have code to pull general data from a website into Excel using a macro, e.g. yahoo finance quotes. But, is it a possibility to pull data from a secure website (one that requires login) to automate a report? The link provided was close, but I don't understand how to pass the parameters in. Also,...

    SandeepKommineni70 pointsBadges:
  • Recover password for Excel VBA macro

    About a month ago, I set a password for an Excel VBA macro but now I forgot it. I can't download the Hex Editor. What should I do? How can I get my password?

    ITKE1,051,105 pointsBadges:
  • VBA Do While Loop

    Dim iJob As Integer Dim strJob As String iJob = 5 Do While ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value <> "" And iJob <> 4 If ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value = strJob Then Select Case ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value Case strJob...

    Wolfehound725 pointsBadges:
  • Needs to pass data from Excel to host on demand

    I need to pass data from Excel to Host on demand 3270 mainframe and vice versa using VBA.

    Kavithagowda5 pointsBadges:
  • Microsoft Access menus

    How do you setup menus using MS Access?

    Danljonessr10 pointsBadges:
  • Stop Excel VBA code manually

    For VBA, does there happen to be a way to manually stop/pause an Excel VBA code? I know this is possible in Visual Studio. Thank you.

    ITKE1,051,105 pointsBadges:
  • 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?

    ITKE1,051,105 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.

    ITKE1,051,105 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.

    ITKE1,051,105 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!

    ITKE1,051,105 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.

    ITKE1,051,105 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.

    ITKE1,051,105 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?

    ITKE1,051,105 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!

    ITKE1,051,105 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