set

Hi Experts, How to get result in Column L (Start) ? GIL1DataEndStart2315415161715891111011121213121415161111718191220122122132312413252627 For Column I ( End) , I use this code : Sub End2() Dim a As Variant, b As Variant Dim i As Long, k As Long a = Range("G2", Range("G" &...

Hi all, I currently have the following VBA code attached to a macro that sends out an email and attaches a word file to it when I click it and sends this out to a list of emails (and also BCC's a list of emails): Now I want to edit this file so I can target a list of emails in the emails...

Hi, Data contain just 2 value which are 1 and 0. AB1DataResult20311405061718139010111121201301411150160170 Thanks advance.

I am using Excel with Selenium to control a web application over a browser. I have automated almost all of my functions except for one. There is a page where I can click a link to print. I am not trying to print the web page. The button will print a document associated with the link on the web...

Hi Everyone, I have query related to set reminders for balance and paid for the amount the customer do payments for the products. kindly assist me in this regard Appreciate your help.

Hi, I want to trigger excel macro TEST12.xlsm when received en email with subject title "Test", it work when the mail arrived in inbox folder, but not in subfolder. Can anyone enlighten me or point me to the correct sub folder path? The subfolder name is "Biz Ops Report" and I am using below...

Hi all it's me again, I'm using some code from Ron De Bruin's site to generate an email using the following code Sub Mail_small_Text_Outlook()'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm 'Working in Office 2000-2016 Dim OutApp As Object Dim OutMail As Object...

As the title suggest, I'm trying to export Undelivered emails in Outlook to Excel (sheet1) I found this code on the web, and I'm having a little difficulty getting it to work Ideally I would like the data to appear in columns, a separate column for Email address etc The Emails are in sub-folder...

Hello everyone, I have a code which starts this: Private Sub CommandButton1_Click() Dim destination As Worksheet Set destination = Worksheets("STATS") Set myIE = CreateObject("InternetExplorer.Application") myIE.Navigate "https://www.internetpage.com/lblabla.html" myIE.Visible = True...

I have the following code: Sub delete_dc_row() Dim wbCurrent As Workbook Dim wsCHINO As Worksheet Dim wsSTOCKTON As Worksheet Dim wsFLM As Worksheet Dim wsDGV As Worksheet Dim wsAURORA As Worksheet Dim nLastRow, i As Integer Set wbCurrent = ActiveWorkbook Set wsCHINO =...

Hi folks, Can anyone edit the snippet below to add a datestamp to the cvs filename in the format "yyyy-mm-dd hh-mm-ss"? Many thanks in advance! Sub saveTableToCSV() Dim tbl As ListObject Dim csvFilePath As String Dim fNum As Integer Dim tblArr Dim rowArr Dim csvVal...

I am wanting to have a outlook email address to be set based on the value of Combobox2. What i have doesn't seem to function, and i am sure it is simple but i am a little stuck. any suggestions would be great. What i have so far is: Dim name As String If ComboBox2.Value = "Bill" Then Set...

I have a table layout as below, it used to work with the code below until I inserted the column under “M” then replaced all 12 with the 13 you see in the code. For i = 2 To 13 And rCell.Offset(, 13).Value = Rnk & GetOrdinalSuffixForRank(Rnk) I was thinking that will fix...

I'm trying to rank a list of values using VBA rather than a formula as the numbers will be continually changing. I'm basically trying to run the code at a set point to rank the lowest 3 numbers on the sheet and leave them set rather than recalculating with a formula. Thanks

Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the previous day's data. To make it more complicated each day's file has two tabs that i need to import but I'm assuming the code below will do this...

I need pivot tables to refresh automatically once a user enters new source data. I have my workbook set up on monthly tabs and the users can enter data below row 12 on each of these tabs. I have set up the workbook with dashboard/display tabs at the front and the monthly data sheets at the...

I have a cell on sheet A that employs VLOOKUP from data from sheet B. The cells on sheet B have a date or is blank. When it is blank the result is 0-Jan-00. How can I set it up so I get a blank like the other page?

Hi I have the below code to copy data from one workbook to another but keep getting a subscript out of range error on the line... Set wb = Workbooks("2019_-_Couriersheet_-_copy.xlsx").Worksheets("Triage2") Both workbooks are open and I've checked the file name is correct etc. What could the...

Hi all, I have the following code and all is working ok, apart from it is no longer adding my set signature in Outlook . If possible could you have a look and amend as required. Sub ScorecardPdfEmail() Dim OutApp As Object, OutMail As Object Dim fname As String, sendto As String...

Hello - Anyone able to assist a newbie on VBA coding, please. I have learned some great stuff reading comments and watching online videos, etc. But, I have patched together some code from various excel experts to: 1. save the file and then email as an excel attachment (.xlsx) The issue...