vba & code

Dear, I have an excel file that have an expiration date, and I would like that when the date is -15 days before expiring it send an email automatically based on some cells information to the outlook email once the system logged in. I have add a code but it is not sending auto email and I have to...

Hello all I have the following VBA code Sub Create() Dim application If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine End If If Not IsObject(Connection) Then Set Connection =...

Hi I need help about vba macro, The thing is if any cell in column "c" has web link, it will be spared all other cells would be deleted (shift cells up) Just this is my required! Now I do know vba, but not that much to be able to write a code by myself so if any friend could help me here...

Hi all, Need an urgent solution to the below please, if possible. It is beyond my VBA capabilities. I have created a new Excel workbook and inserted a macro button name "Import NC Data". What I need the macro VBA code to do it to ask me to select / specify a specific folder (folder and...

Hello Everyone. I will truly appreciate your help. My aim is HTLM text from column A to be copied in column B as normal text, after each word "см" i would like a new line(enter) to be created. That operation should be done via VBA code. Many thanks in advance for your cooperation. AB1Copy...

I would like the following code to create a duplicate window, tile these windows vertically, follow the reference from the originally selected cell, then select this cell's referenced cell in the second window. Everything seems to be working correctly until the last line of code where it will...

Hello all! Hoping that someone could help me or even tell me if this is possible! First time poster but have been looking at posts in the forum for a long time! Column B - I have levels that have a code assigned to them based on column E, and column G are my expected results. If the level...

Hi Guys, I need your help, Please note I am trying to use the value from a Textbox (Have a formula an extract a cell value (number with format as percentage) to convert to integer or number in order to proceed with a condition to determine if the value is X1 < 0 , X1 > 0 or X1 = 0 (This part...

Hey everyone, I have a macro that checks to see if the excel file open is the latest version for my technicians. I am able to successfully check, download have it rename everything. But once I get to the Kill it gives me the good ol' You don't have permission to delete that error. I have posted...

Hi hopefully somebody can help. Using Conditional Formatting I've built a workbook which checks for a number in a series of columns on one worksheet and if it finds a it in a grid (named range 'Grid'), formats the cell to a particular colour. This works great, but I have 150 CFs so the whole...

Hi, I currently have 2 steps of code which work fine but I want it to work off of one button press to take the data from one workbook to multiple other workbooks and save as per the name. The first set of code filters it but puts them into sheets and the second set of code converts those sheets...

I am trying to Copy from 1 workbook (S.xls) and pasting into (PD.xlsm). However I also get the same error 1004- Application-defined or object-defined error at this line "lastCol = sh1.Cells(1, Columns.Count).End(xlToLeft).Column" Sub Rectangle1_Click() Dim sh1 As Worksheet, sh2 As Worksheet...

Hi All, Please note I already have a code that works but I would like to do it faster. Dim X1, X2 as worksheet Set X1 = Sheets("DataBase Hierarchy") Set X2 = Sheets("Tool") X1.Select ActiveCell.Offset(0, -1).Copy X2.Select ActiveCell.Offset(0, 1).PasteSpecial xlPasteValues...

I'm having an issue with getting the MACRO to copy from the correct sheet when it is taking data from another excel work book. The issue is even though I have the sheet search on for the "TOP" it will copy form which ever sheet was last active when the excel was open. I currently have it set up...

I want to filter and split the data based on branch name (Branch List sheet), and also want to save that new excel workbook for each branch as per the same name as mentioned in the Branch List sheet. Please help me with LOOP function to complete my code.

Hello! Thank you in advance for visiting my post. I understand there have been a couple posts here already that ask for help regarding VBA code and moving data from one sheet to another based on a drop-down value, I appreciate your help nonetheless. ---------- We are approaching territory...

Hello everybody, I'm new here and also fairly new to Excel VBA. My problem is that I have two subs 'combined' in one sheet, but only one works. The first part of the code enables me to select more than one worker in column G from a drop down list and is working just fine atm. The goal of the...

Hi All, desperate for help. I have a scenario that I'd really appreciate a piece of VBA code to run. I have a table of information in sheet 1. It runs across the rows. Based on the data in the Score column (Column B) and the Age in the Age column (Column C). I would like the code to select...

Hi VBA Developers, Hope you are fine, Please note I have been trying to create a database but in this case, I only need a column with the data, based on some parameters but during the process I am confused since the code I think should have some loops. Probably my code is a mess, but...

Hi; I have a login form where the password is displayed with * How can I display the password using the checkbox?