1. B

    Windows 10 Help with VBA Web Queries Excel

    In Excel, i have a Userform. On this Userform is a Command Button, and a Label. When i click the Command Button, i want excel to perform a web query, and then put the output into the caption of the label. The web query is simply a .txt document on a webserver, containing one line of text...
  2. P

    Windows 10 How to create new context menu entry for macro-enabled workbook by editing the registry?

    I wanted to add Macro-enabled workbook to the New context menu in Windows. I got the idea of creating a "NullFile" string value from this page: HKEY_CLASSES_ROOT\.xlsm\Excel.SheetMacroEnabled.12\ShellNew "NullFile"="" But it doesn't work. Nor does using a string value of...
  3. E

    Windows Server Launching Putty from Excel

    Hi, I have a Excel spreadsheet with hostnames in column A. I have added this macro so that I can doubleclick to launch Putty to log on a given host with ssh: Code: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Range("A" & ActiveCell.Row) <> Empty...
  4. F

    how to repair damage excel file

    dear all, I have an Excel file its size about 19 MB and it was work properly, suddenly we can't open this file, and it shows the message "unable to read file" , and even if after several attempts, it open then it is not open Properly. Note that this file is protected with a password. Is there a...