script

Hi Experts! I am trying to formulate the best way to create conditional formatting rules to be able to highlight the whole row based on the words found in column G. Basically, column G contains all the status of the processing of the macro. It is consist of a sentence or two. I want the rule to...

Hello, I need an EXCEL VBA script which will perform the following operations: 1. Open my Outlook 2. Read mail with a particular subject line (let's say ' TEST MAIL') 3. Download the attachement from that mail to Desktop location. Please help me with the script. Thanks,

Why does this not work? According to the internet I could use Val() to convert a string to a value. Sub GotoColumn() Dim x As String x = InputBox("Goto column...") If IsNumeric(x) = False Then x = Range(x & 1).Column x = Val(x) Cells(1, x).Activate End Sub The script should activate...

Hello. I'm working on a project that requires a button click to launch an Outlook message box with a pre-filled template. I have had success with using the =hyperlink("mailto") function, but the contents of the message exceed 255 characters. I'm very novice at VBA script, and although I have...

Hi All A while ago I used a forum and posted a problem which was solved by using a VBA script. This script works most of the time but not always. The original problem I had was that I get given an excel sheet with 3 columns detailing a description, a part number and a location. I needed...

Hi, I am new in VBA. I'd like to create a VBA script to select the value "associate" from a html dropdown list. Could you help me with writing this script? Here is the html code in the website <h2>Return To Station</h2> <div id="searchUserInputContainer"> <div...

First off, I am an Access newbie. I have a DDL SQL query script that creates many different tables in a database. But, all I can find is a make table query that only works one table at a time. So, my first question is how do a create a database's tables from one DDL SQL script? Second...

Hey, Hope all is fine. I would like to learn from you, how would I remap my Enter key to a Down arrow key? I tried a script but it does not work. Application.OnKey "{Enter}", "{DOWN}" Will appreciate. Thank u.

Hey, The following is a Vba script that would be needing some altering so that if the value in cell B3 is greater than 21 AND it is not equal to Selection.Column then my code. If Worksheets("HSheet").Range("B3") <> Selection.Column Then The above is missing B3 is greater than 21 condition...

I have multiple text files that I am having to open and record dates/times on an Excel sheet print out. I would like to have a script that can parse (read) those text files, finding certain words in a paragraph and return the date listed at the beginning of that paragraph?

I have an issue with the formatting of data. the script I have copies data from "PASTEDAT" tab and paste into "QUASAR Script" tab. So the data from the "Data"tab can be as follows 546882 546883 '092384 Copying the 546XXX numbers are ok. However, the resultant for the last number pastes into...

Hi, I would like to use the week number to decrease the percentage by 2% every week. I have the date in B3,Time in D3, Week Number in F3,and 100% in H3. The date,Time,Week number update and run whenever the computer is switch on. Workbook opening script:Private Sub Workbook_Open()...

I need a dynamic batch file written to create all of Joe's timesheets for the year. Sunday is the end of the pay period. For example the Sunday in January 2019 is the 5th The file name would be 20190105 the folder will be named c:\Timesheet\2019\01-January\ The complete file path would be -->...

Hiya, I'm a newly registered user with newly registered user problems !! VBA is steep learning curve for me, but hopefully with your help I will get there. I have a basic script that opens up three Excel spreadsheets, puts them in three separate tabs. My current issue is that the spreadsheets...

I am using the following VBA code to create about 70 Web pages after some other updates are made to the sheet using another script. This worked flawlessly for several weeks and now all the sudden it is taking up to 20 minutes just to generate the first page. My scheduler only allows 20 minutes...

In my dBase, I have three queries that have a parameter that is coded Like"*TUC*" The dBase is designed to be used by various locations with different location coded. Is there a way to change the query parameter in these three queries via a script?

Hi all – I cannot seems to find anything to fit my situation and everything I’ve tried so far has failed. I'm looking for a macro that will look at the values in column E that have different ID values that should be in minimum quantities of 26 for each unique ID. In the case where there are...

Feel like I've been down this road more than once. Could some fine gentleman or gentlewoman provide some insight as to why when this line does not precede the lower the script errors. Thanks All Range("A10:Z10").AutoFilter Range("A10:Z10").AutoFilter field:=14, Criteria1:="25"...

Hello all! First forum post (hope this is in the right spot): I work for a medical facility that dispenses many medications. We generate an Excel MAR sheet (linked) for each client. As we used multiple medications, it can be tedious to type out each individual order. We've been utilizing a...

Ok, so I have got an Excel Booking system that is designed as a part of a "Rock School" for a school project. I've got all the "bookings" parts done, all the information saves, everything works. But then I'm stuck on the part of "unbooking" the student. I am able to write a script that detects...