excelvba

Hello! I am new here and I hope you can help me as I am a noob when in comes to macros. I have a macro that I want to create that can list down all the file name and the file path of each item inside a folder. I also want this macro to list the items inside a subfolder. Note that there is also...

I want the code that allows me to extract the web share link from a file located in google drive.. Currently I use excel 2016 on PC and Mac and I don't know how to know it using VBA, any suggestions?

When the item-list is selected in the range in particular cell, the Shape button should be visible on the side. How it possible to make this hyperlinkbutton in table

Hello everyone! I want to highlight a bar red in a pivot chart based on what value is chosen from a drop down list. The values in the drop down list correspond to the x values in the chart. For example, if I choose Blake, Judith in the drop down list I want her bar in the chart to be red and all...

Hello everyone, Could you please help me with VBA script for deleting an entire row when a cell in range is blank? I have columns A and B. A with IDs and B with specific text in them. However, some of the cells in both columns are empty, so I want to delete the entire row if a cell in A or B...

Hello Friends, I am trying to close the Window pop ups while opening the web pages which is having the any sorts of pop ups window. I have around 10000 URL and trying to get the title in an excel sheet. Code is mentioned below. Help is highly appreciated Option Explicit Sub CheckPageData()...

Hi! I have a problem about my excel file. I want to "ADD ORDER" in the list but after adding the data, the excel hangs and suddenly auto close the file. Then it will automatically open the file again without open it. here's my code Option Explicit Private Comb_Arrow As Boolean Private Sub...

Hi, so I have this problem: I want to be able to download url folders based on the start date (dtReportDateStart) and end date (dtReportDateEnd). So I want start date, what's in between and end date. My code: Sub Get_XY() Dim dtReportDateStart As String Dim dtReportDateEnd As String...

Good day! I need some help, I'm nearly done with my excel sheet but what just happen now was, when I submit the Data Entry, it will added to the list, but after that, I noticed some irregularities, like can't use the combobox, can't type, can't scroll, and after 1 minute, my excel file is...

I keep getting AutoFilter method of Range class failed message. I'm following a tutorial online and I did everything as it's mentioned there but I just can't understand what I wrote wrong in this part. Any help? Sub Show_Sale_Purchase_Data() Dim dsh As Worksheet Dim sh As Worksheet Set dsh =...

I need help with my VBA code. My code autofilters Column D(Department) from row 19 and paste to different sheets by Department Name. However, Row 1 - 18 (Headers & body text) which are currently excluded in the new sheet. I need to include row 1- 18 and paste special to keep source formatting...

Hello ..!! This is my 3rd thread with Mr.Excel and my journey here is making me visualize what all can I automate using VBA and becoming successful with smaller macros for now. Thanks to everyone who is making my journey here fruitful ..!! :) So I am here with a request for macro that I need...

Hello all, Need your help. I am unsure why the below is not working. All I am trying to accomplish is to lookup a value in column A, find that same value in Column A on a different sheet, and copy the data from the first sheet in Column G:O to the same G:O range in the second sheet... When I...

Stuck with my excel macro: to pull subject from email to a new sheet. The macro pulls the information to new sheet but when I tried to add column header it gets added to the sheet 1 where I have added the macro button.

I am receiving a "Run Time Error 1004 - Unable to get the VLookup property if the WorksheetFunction" for the below, but not until the 3rd Vlookup runs. Values are in the lookup table, etc...Help! I don't understand why the first two run but not the third and fourth. The only difference between...

Hi all, Need some guidance... I have a user form that has a grid that represents 7 years worth of text fields...it also has two text fields which are start date and end date. it is laid out like... y1jan, y1feb, y1mar, etc all the way through y7dec y1, y2, y3 etc are all populated with the year...

Hi, basically I have this table range. I want to color the cells that are "0" but have length and serial number. but do nothing if don't have both conditions. i tried but it turns out all cells with "0" is colored even the conditions not met. I'm new with VBA. Still trying. glad if you could...

Hi, I am working on a production schedule file. A company is producing batches of product and each batch goes through three different processes. Each color represents a new process and GP/SP/RP represents a different location of the batch. I am wanting to have excel generate in a column on the...

Hey guys, I hope everyone is keeping well! I was just wondering if anyone might be able to lend a hand or point me into the right direction, please? ? I have been experimenting with a few different ways that I could send excel data using VBA but have been struggling with this for some time now...

Hi All, I'm trying to send email from excel sheet, but before sending im getting a Outlook warning "A program is trying to access outlook email information..." with Allow, Deny and cancel button. im thinking of fully automating it but then this warning keeps on poping up whenever i sent an...