vbscript

  1. Q

    Rows delete formula as per range of cell values with counter to define how many rows to be deleted

    Rows delete formula as per range of cell values with counter to define how many rows to be deleted Hi, I have DB with 50000 rows i have specific cell value A:A MAX cell value countIF of each specific value of A:A = 31. (Let say Abraham name came in 31 rows in column A:A similary...
  2. O

    VBScript to open a Read-only file, execute a macro and save the file with the same name and in the same location

    Hello, I am currently writing a VBScript in order to schedule it to run twice everyday. The goal of the Script is to open a Read-only Excel file, execute a macro and afterwards save the file with the same name. It is extremely important that the file is saved with the same name, so I don't have...
  3. K

    automate website search and extract data to excel sheet

    Hi All, I need help and suggestions: I had a list of contacts and their details its a bulk. I need to verify those names and contact details are matching with my database site or not. In detail my database site user interface have search option if I give name of person with id he have if...
  4. J

    Search for keyword from prompt in Excel then create new tab with summary

    I have an excel file with many sheets (tabs). I wanted to create a script in excel, such that when you hit run, a prompt comes up asking for "Text to search for", then after inputting the text, "failed" for example, the script then searches every sheet. Then a summary sheet is created that...
  5. D

    Error 619 - SAP

    Hello, I included a snippet of a code I use to automate invoice printing one by one, using invoices from Excel. I have problem to make an error handling code that will handle error #619. Basically, the way my sub work is that when an invoice is available, it will open a new window...
  6. G

    Move files to folders based on two criteria in the extension name

    I have a task here that might be possible with VBA or VBScript. I did the first couple of steps with VBA but I am not sure how to proceed. I am downloading annual reports from the SEC which I want to group in folders by their respective year and SIC code. I am doing this with the EDGAR package...
  7. G

    How to run VBScript inside VBA

    <tbody> I want VBScript to read variable value from VBA as the file directory (<code>Wshell.SendKeys "C:\testfile.txt")</code>will change when I run VBA in loop. I would like to have data as list in Excel and tell VBA to read and then VBScript to paste in Import file window (window...
  8. D

    Vbs calendar select change by designated target cell

    :) Hello everyone! I need assistance in adapting the following vbscript: Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'check cells for desired format to trigger the calendarfrm.show routine 'otherwise exit the sub Dim DateFormats, DF...
  9. D

    Excel vbs code for dynamic range referencing

    :) Greetings everyone! The following VBS script has fixed defined ranges. I need the ranges to dynamically change as new rows are added to the worksheets. Sub SATFILTER() ' SATFILTER Macro ' Filters Master Daily Schedule Worksheet for Employees Assigned to Work Saturday. Dim SATFILTER$ Dim...
  10. U

    Help with scheduling

    I have an excel macro named HAHAHA.xlsm and it has a sub named random_info() I want to schedule this macro / sub so that it runs daily at 00:00:00 hours GMT It should run even if Excel is not open at all. I don't know how to do this. I guess I need to use VBScript but am not aware of the...
  11. P

    Compare two xls file and copy matched data in to new row in second sheet

    Hi all, I have a requirement where I have to read two different xls files and compare the data in case found any match I have to populate the matched data on the next column in the second sheet. sheet 1 (xls1) ------------------------ |Text | Replacement | ------------------------ | field1|...
  12. B

    SpecialCells VBscript to get all Formulas fails w/Unable to get the specialCells property of the Range Class

    Trying to put a vbScript together that will go through an Excel Sheet and return all the Forumlas Found in the activeSheet. I am attempting to use SpecialCells to return the data. However, I get an error "Unable to get the SpecialCells property of the Range Class". Am I missing something to...
  13. C

    Starting a Bloomberg excelsheet via VBScript

    Hello, first of all I'm a rookie in programming with Visual Basic. My purpose is to programme the following tool: It should open a particular Excel-workbook (WB1) at 12 o'clock, copy values of a few cells and write them into a further workbook (WB2) with current time and date. Then it should...
  14. R

    VBScript to open a password protected file in order to edit links.

    I have a working program but want to add a password to the external file I'm using to update my active spreadsheet file. I do not want to be prompted for the password when I initiate the "update" command from within code. I would like to automatically pass the password through scripting. Here is...
  15. Technowolf

    VBS to run macro on already open .xlsm (if it's open)

    Trying to figure out how to do this via VBS. First, check if the workbook is open, and if so, run the macro in it. I found this, but this opens a readonly version in the background and runs it, which is no good for my purposes Option Explicit Dim xlApp, xlBook Set xlApp =...
  16. D

    Macro for Essbase data retrieval

    Hi, I am ultimately trying to automate/schedule a data retrieval from Essbase. I started with a macro that works perfectly. Sample code: Sheets("Sheet1").Select range("B1:b1").Select ActiveCell = j application.Run macro:="EssMenuVRetrieve" This macro will run in about 0.5 seconds and...
  17. M

    Exporttofile now prompting for Printer setup

    To all, a search did not turn up an answer for this, so I am hoping someone can shed some light on the problem. I am using the code below to export a workbook to a PDF file: ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, Quality:=xlQualityStandard, _...
  18. A

    VB script does not work when run from windows task scheduler.

    I have a vbscript. The vbscript works perfectly when i use microsoft windows based script host to run it. I used windows task scheduler to run the vbscript, but the script does not run. The following screenshot appears.
  19. D

    Create a input macro in the next available cell

    Hi there, I want to create a macro, that inputs a string into the next available cell, in a defined row. So when the next available cell is found, a inputbox appears, the user types in the data, and then the data goes into the active cell. I currently have this: Sub Find_Blank_Row() Dim...
  20. N

    VBScript For Loop folder variable not working, Trying to move, rename, and delete based on file/folder names

    Hi all, I am new to vbscript, but I have some experience with vba. I am trying to move, rename, and delete files based on their names and where they are stored in the folder structure. But when I run the script I get an error "Invalid 'for' loop control variable" that takes place at the start...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top