vbscript

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...

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...

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...

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...

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

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

<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...

:) 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...