vbscript

  1. G

    Need to Upload a PDF into the Web page

    Hi , I m New to VB and I was struggling to the code for upload a PDF into the web page. I need to upload a PDF in (https://draftable.com/compare) in this website please help here and provide any code to upload a PDF using VBA. I have tried to upload PDF but getting error when "Choose File...
  2. 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...
  3. J

    Change query parameter with vbscript

    I've searched the wonderful world of Google for a simple answer and wasn't able to find one. Is there a simple way to have a standalone (manually executed) vbscript to change an Access query parameters? I have the same parameter in three queries, which is Like"XXX" I need to replace the XXX...
  4. S

    Currency Converter to Different excel

    I have two excel first excel output file and second excel Exchange rate excel, first check in second excel date column and pick every month 1 date exchange rate and convert in Main file currency in (INR,USD,EUR) convert in GBP format. 1: Main Output file : Empno Ename...
  5. S

    Currency Converter to Different excel

    I have two excel first excel output file and second excel Exchange rate excel, first check in second excel date column and pick every month 1 date exchange rate and convert in Main file currency in (INR,USD,EUR) convert in GBP format. 1: Main Output file : Empno Ename...
  6. B

    VBA Macro to change the value of the cell based on the text box font color. ( -ve for Red font)

    Hello, I am a total VBA novice and I really need some help with this problem. I have 10 excel files that contain 5 worksheets in each of them. The values of 3rd worksheet (of all excel files) of Cell C24 change regularly to Red or Green font values. I'd like to change the red color values...
  7. R

    adodb performance EXCEL VBA vs vbscript

    I have a rather large query, containing a table join that returns approximately 80k rows; executing this query via excel VBA seems to result in a minute or longer of processing. I don’t have the same speed issues when returning 5-10000 rows in excel; just the one that’s returning 80k rows. I...
  8. S

    Creating lists of numbers

    I have a list of no’s and I want to be able to create a list for each line in my table E.g Branch, sub dept, start no, end no 1234, 1, 5, 9 4567, 3, 45, 55 8734, 7, 23, 35 Etc So I need an output of 1234.1.5...
  9. J

    Stop vbscript

    Is there a simple IF string that can be put into a vbscript/macro, to stop the routine when it encounters a specific variable? I am looking to stop the routine when it encounters a ="" variable in column A on my workbook
  10. W

    VBScript - Show only Userform - Userfrom does not apear "In Front"

    I am using a VBScript to launch an excel file with the application hidden so that only the userform appears and the application never shows (not even a flash as is typically seen with Application.Visible = False use). Everything works fine, the script opens open and hides the application then...
  11. D

    XML-mapping not compliant with Excel RefreshAll

    Hi! Running an Excel 2016 workbook with a few data connections to SQL server and they refresh fine with "Refresh all" command. I added a XML-mapped table just for exporting (i.e. no real refreshing needed - data in XML-mapped table is filled manually and via formulae & exported on-demand). Did...
  12. D

    Running a VBA macro from VBS file

    Hi! I have a working VBScript file and VBA macro in Excel worksheet that does this: 1) refresh all data connections 2) write a timestamp in a specific cell 3) save & close the Excel worksheet VBS file: Set objExcel = CreateObject("Excel.Application") objExcel.Application.Run...
  13. J

    VB Macro SUM IF

    All, I have a sumifs that I want to convert to VB and i have been struggling for a few days. The SUMIFS is causing issues for my excel document as it integrates with an ERP package. I have identified that the formula, not in VB, is the issue even though it calculates the correct amounts...
  14. N

    Send different activity to pc to keep it busy

    In my office there is an application that count my active hours and idle hours on my desktop. I want a code that send different key strokes, open files, mouse clicks so that my desktop remain busy all day long. Could someone please help me.
  15. R

    Task scheduler + VB script to auto open protected excel workbook

    Hi everyone, I am trying to use VBscript and Cscript to put in windows task scheduler to auto run a sub at a certain time every business day. So for my windows batch file, I have ------------ Cscript UMSscript.vbs "\\SHAREDrive\path\Controlfile.xlsm" ------------ and in my VBscript file, I...
  16. H

    Follow up, Excel VBscript to search an entire workbook and display all the searched criterias along with the sheet title

    Courtesy to wideboydixon for the below code, and as he's busy with other projects and until he can be able to further assist, I'll appreciate the entire community help. As you can imagine, I'm working on a self-motivated project and greatly need your help. The code is able to search multiple...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

Top