vbs

  1. F

    Compare two Workbook to display full name column

    Hello Friends, I was able before to Copy Column base on Condition from "absent11d7.xlsx" file to display the result in "NewAbsentData.xlsx" using the Code below. Currently i want to move One Step Above: The final file "NewAbsentData.xlsx" have two columns "Last name" & "First name" So As...
  2. B

    workbook wide VBA conditional formatting help

    Please can one of you geniuses excel guys or ladies help me with a bit of code to format an entire spreadsheet. I have a excel workbook with our entire hospitals directory. Each section of the hospital has a different colour code and I need to conditionally format the entire workbook based on...
  3. M

    Compare two columns in different workbook

    I would appreciate if I can get help in creating this macro. I have two workbooks, and want to compare the specific column from 1st workbook, Ex: Column H with next work book, Ex: column A. After comparison highlight the matching cells in 1st workbook.
  4. A

    Automatically ran macro

    Hello, I am looking to have a macro ran periodically on a spreadsheet. In order to achieve such a goal, I based myself on a post I saw from The Spreadsheet Guru (link below)...
  5. A

    Applications blocks Subroutine from continuing

    I want to automatize the following procedure: I want to attach an email after sending it to a document in SAP, but as soon as the "select Files:" windows appear my code is blocked from continuing bc this window belongs not to the SAP application itself (I don't know if these are the correct...
  6. E

    Setting beginarrow head style type in excel using VbScript

    Good Morning, I am writing a script in VbScript that interacts with excel and I am trying to set the hiLoLines property to create the BeginArrowHeadStyle, but I am unsuccessful. Noted below I have place my code of what I have so far and this is within a graph. Please help...
  7. P

    Problem saving VBScript Script Files

    Hello all, I'm used to Macro program writing but I'm new to VBScript Script Files and I cant seem to find what can be wrong no matter where I look. I have a problem with running this vbs file, getting this error: Line: 7 Char: 1 Error: "Object required: 'application' Code: 800A01A8 Dim...
  8. K

    vbs script suddenly started "unknown runtime error" on running macro in excel - any ideas??

    My script was running just fine up until about a week ago. Now it throws an error on the macro run statement. The macro runs fine in the spreadsheet when run manually. We did run windows updates, and an antivirus update; but that should not have changed anything in this - right? I'm running...
  9. E

    vba and vbs file name import

    Dear All, I have an issue with the following I have a code that saves a file under a name from one of the cells: Sub zapisintemp() ' ' zapisintemp Macro ' Dim Path As String Dim filename As String ' Range("A1:H1").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy...
  10. S

    Question on Password input

    Hello, I am using the following .vbs script to open, run, save and quit excel: Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open _ ("my_excel_workbook") objExcel.ActiveWorkbook.Save objExcel.Quit What happens in the excel sheet is a macro is...
  11. B

    Retrieve Value from SAP Field

    Guys im having trouble getting the value from an SAP field into my excel Column. I need to get the following value to copy into cell C5. I cant get SAP To copy the value or insert it into cell c5. all help appreciated. Set sapguiauto = GetObject("SAPGUI") Set app =...
  12. T

    VBS newbies...

    We are trying to write a script that opens Internet Explorer into a webpage that acts like a DOS screen. We then need to begin typing into said webpage. Below is the beginning code we have managed to make but it does not make the IE screen the current active screen to begin typing into and we...
  13. V

    Run macro only after file exist

    How do I ensure macro only can be executed upon the Book2 is open? The VBS code below will help to auto open the file upon data extraction but it will be delay a bit to open hence resulted error at 100. On Error function seems doesnt work. Im thinking is there any loop function to wait until the...
  14. D

    Error 800A9C68 running VBS using task scheduler

    Gentlemen, I am running this code via task scheduler, and the workbook is closed when it runs. At the end of the process, it gives me the following error; however, all the expected processes are perfect. I have also run the macro manually, and it works as expected. I suspect the VBS code has...
  15. D

    VBA Script emails but reboots excel

    Hey guys, I've worked hard to build a spreadsheet for ordering print job. It calculates cost, allows a file to be attached, and emails to our shop however, once it sends the email it reboots excel. Not sure why it does it but it always does. This is my VBS code that is attached to a button. It...
  16. J

    Formula on 3rd sheet that maps to 1st two sheets corresponding cells

    A simple explanation of what I am trying to accomplish is this: We have a .csv file that has a bit of post processing done on it. We take these 2 files and put them in 2 separate sheets within the same workbook in excel (done through VBScript). I then create a 3rd sheet and my goal is to...
  17. S

    VBS script for checking Microsoft Excel Versions?

    Hey Everyone! I'm new to the group and looking for some help on coming up with a VBS script that can check a users Excel version and perform an action depending on the version. We have 100s of users and it's either going to be Excel 2010 (14) or Excel 2013 (15). I've got the action part of...
  18. S

    Proper way tp close VBA, VBS, and BAT file to prevent, "<filename>.xlsm is locked for editing" issue?

    Hey gang, So I've noticed that I am evidently doing something incorrectly when I am invoking a particular bit of VBA code within a source.XLSM file. Here's my program file flow. script.BAT calls script.VBS which calls "ProcessCVS" subroutine within script.XLSM. Here are the pertinent...
  19. M

    Constraints - Need help returning a value due to multiple level of constraints

    HELLO, Looking for some help! I am attempting to set up an excell spread sheet to calculate my team members work loads. I am runniing into some issues. what i need to do is if a cell is given a value of an interger to return the full load value and if it is a "S" (shared value, 50% of the full...
  20. D

    Vbs autofilter copy and paste subroutine

    :) Hello everyone! I need another dose of Mr. Excel brilliance. I am trying to develop a subroutine that will autofilter, copy, and paste columns of data from one worksheet to another. Below is an example of a table (sht: "Master Daily Sched") I want to autofilter with the string...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top