alert

Hi folks... I have been reading other threads and other locations online, but they are all assuming I know a lot about VBA, and I do not. I would appreciate step by step help... I want to use outlook, and I do not want excel to have to be open to send alerts, but should work when open as well...

HI there fellow Excel hackers. I have an interesting issue that i have run across while trying to write a script that do a replace and find of text in excel spreadsheets. I am writing my script in VBS because of the complexity of this script. This script is to do the following - search a...

Hey All, This is my first question on this site. I use it all of the time by searching through the forums. So I thought I would finally join in the fun. :) Anyhow, time for business. I am running into a problem with the "File in Use" alert. I am attempting to write a code to automatically...

Hi I'm running a macro that gets a file from the internet. My code is like this: (i got it recording the macro) With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;https:// here my url..." _ , Destination:=Sheets("mysheet").Range("$A$1")) .Name = "the name here"...

So I have a computer that runs production spreadsheets continually. Excel always open. Different spreadsheets continually but personal.xlsm stays open all the time. We have a production schedule we need to adhere to and it requires an action every so many hours. The number of hours between...

hi, everyone; i am working hours of hours days after days and cant come up with it, maybe someone can help me here, i am having an excel sheet in column "A" it has an item number like sku 9098, column "B" has the quantity, the quantity is being managed by formulas like vlookup and web-query as...

Hello All, I'm looking for vba for the following situation. On tab labeled "Orders" Sheet4 (Orders) Event trigger = When data is entered into the first empty cell(s) of Column F Then check to see if the following three conditions are true 1st - Column C - a cell has the phrase 2)...

Hi, Just been asked to help and VBA is new to me, can you help? I'm running this sub as a tally which works ok :) Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$T$10" Then Range("S10").Value = Range("S10").Value + _ Range("T10").Value End If End Sub I need help...

I need some help. Everyone who has posted in these Forums has been incredibly helpful so far. I wasn't able to find any information on this one however. I have a sheet that alerts me with a message box when a set time has passed. This works fine as long as I have this sheet active. I...