• 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,109,215 pointsBadges:
  • Comparing 2 Large Excel Files

    I have 2 large Excel files, one containing yesterday's data, and another containing yesterday's data + today's updates/changes. For registration purposes, I need to find all the differences (ie new rows/entries, a value changed within the row in the new file vs the old file, etc). These excel files...

    Drawde5 pointsBadges:
  • embed .xla into excel

    Hi ,I am newbie to VBA programming.I got two files .XLA and .XLSM files. In .xla file, all the code exists which is called from .xlsm action.To make this work, i have to copy both files in to same folder on any machine. If .xla is missing, nothing works.I want to merge xla file into xlsm so that i...

    GreatVen10 pointsBadges:
  • Embed xla file into xlsm file

    Hi, How can I embed .xla file into xlsm file so that there is no need to have both files together? Regards, Ven

    GreatVen10 pointsBadges:
  • Convert Excel to JSON using VBA

    I need to write an Excel macro which will convert the excel workbook into a JSON file. The excel will have multiple sheets, each sheet will have a tabular form of data (in rows and columns). One of the column will have hyperlinked data and the macro should extract and explicitly list the hyperlink...

    6r2,220 pointsBadges:
  • .DAT file of unknown structure

    I have been given a series of .dat files of which I do not have the file structure. They are produced by a system that tracks elctrical consumption. All I know is the brand "iPT", and that the owner connects to it via HyperTerminal in order to get the data. I work mostly with VB/VBA, but any and...

    NimBiotics50 pointsBadges:
  • Fill in a varB from code into a cell on Excel spreadsheet

    I have a workbook running a macros for multiple "If Then" statements. One of the IF Then statements in the Macros determines a varB, then that varB is used to calculate another value. How do I then ask the new varB to fill into a blank cell on the Excel spreadsheet?

    eripika91515 pointsBadges:
  • Simple routine with If now does not work – help please!

    In Excel sheet I had macro for hiding and showing all rows that had a red cell in Column A.  It was working well but now hangs. Any clues as to why this is happening and how to get round it? This below is the Show routine which unhides any row with a red cell in Column A as well as showing Column...

    Madcap5525 pointsBadges:
  • VBA copying a range from Excel and pasting to a text file

    Do you know how to copy from excel and paste to a text file using VBA?

    TBone555 pointsBadges:
  • 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:
  • 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,109,215 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,109,215 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,109,215 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,109,215 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,109,215 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