vba

  1. K

    Error Handling Exit Sub

    Hello, I have an OnError GoTo statement. If there is an error with the MkDir (aka, the file already exists), then I want it to go to the ErrMsg that asks if the user wants to continue or not. If they continue, the files will overwrite. If they don't, the macro ends. This is working perfectly...
  2. S

    Run-time error '1004

    Hello Experts: I have a rather irritating problem that does not make sense to me and I am hoping that someone can help please. I have some code that: Creates a list of files to be opened Opens each file in the list and scrapes some specific data from each file opened if present Places the...
  3. R

    Finding the last row that contains a value, of a column

    Hello, I am trying to select a cell in the last row that does not contain a 0. It is taking me to Row 54 but I want it to go to Row 37. The method I know is to go to a cell at the bottom of the sheet and "xlUp" so it will find the first value it finds. I want to do this but want to ignore all of...
  4. A

    copy and paste a excel file

    vba is placed in a seperate file and the file which we have to copy is located in C:\Users\WolfieeeStyle\Desktop\Files and the file name is 1.xlsx so we have to copy that file and paste it to C:\Users\WolfieeeStyle\Desktop\save it this location so plz help me in solving this problem sir
  5. D

    Why does it offset the Listbox position `? is there a fix

    I try to use this code to get the Listbox to line up with some cell , but for some reason it does not hit the target, and then I need to make an currection (See last linie of the Code. when I add the currection it sames to work and stay the with the topleft corner of the ListeBox in the...
  6. Emanuele

    Multiple Column and string extract

    Hi guys, I would like to know if there is a way to add more than 1 adjacent column for the presented code that I found on Internet and that Fluff helped me to modify in this Post Furthermore it's possible to apply a string extract (for example, extract the first 4 and the last 4 characters and...
  7. B

    Copy Paste Between Workbooks VBA

    Hi Everyone, How do I copy and paste work between workbooks (I have a total of five open workbooks)? My Range will be unlimited such as : Rows.Count).End(xlUp)) I see people do two typically but I don't know how to write when there's more than two. I have one main workbook that I will be using...
  8. D

    Add every file inside a folder

    Hello, I'm trying to do a macro that let's the user select a folder with more folders inside, this folders could have images .jpg or .png. What I want is that the macro adds only the image files in the excel, any image file. What it does right now is that adds the images but only if they have...
  9. G

    Looping Solver VBA Question

    Greetings! Im trying to run a solver loop that will loop through and optimize for the highest return possible on a yearly basis. See image. What I want to do is use the previous years returns across the 7 asset classes shown to optimize the weights invested the following year in the hopes that...
  10. L

    VBA to gather data

    Hi, I have a folder of CSV files downloaded from yahoo finance and I have written code to get data from each of them. It took a long time and is a lengthy process if I want to add another 5-10 files. The code is below. The first block is some preliminary set up then the 2nd, 3rd and 4th are...
  11. S

    VBA: Msgbox to alert that there are no negative values in the final col for validation

    Hi, I am relatively new to VBA so still struggling to fully understand the syntax. I have been working on an automation macro & I am quite close to completion I just have a step that is appearing more difficult than I would've thought. I am trying to provide a pop-up that alerts the user...
  12. T

    Input Box to Delete Columns

    Goal: Need an input box where the user enters in numbers. if this is not possible, maybe loop the input box until the value is blank? This is where I am stuck on how to go about this. The numbers entered are searched through each worksheet in the workbook Row 12 is where the numbers are...
  13. G

    DateAdd to Filtered Data

    Trying to make this simple and easy to understand. I have spreadsheet with transaction types in the “C” column. There are due dates in the “L” column. I need to filter the “C” column by certain values and increase the dates in the “L” column by one day. My problem is that I seem to get turned...
  14. D

    Tick a checkbox online from Excel VBA

    Hi, I have a website with different different checkboxes, all with their own ID. I also have a list in Excel, each with their corresponding ID of the checkbox that is currently online. Example: Text 1 | Checkbox ID 1 Text 2 | Checkbox ID 2 Text 3 | Checkbox ID 3 What I would like (if someone...
  15. U

    VBA - Shortcut Name

    Hi Gurus, Do you have any VBA codes that I can use to shortcut the name name. Example: Tab 1 ABC Management ABC Mgmt. ABC Retirement Company ABC Ret. Co. ABC Corporate System ABC Corp. System In Tab 1, I have the raw name (column 1 above) while in Tab 2 I have list of of name and its...
  16. F

    How to make Macro read the current folder and change tabulation ?

    Hi All I have a macro in which I have to change the folder adress everytime I want to convert CSV to XLSX. how do I make it read the folder that I copy the excel file in it ? and how do I convert the tabulation of those CSV file that have semicolon ; to xlsx with separate columns ? this is my...
  17. J

    Xml to Excel with VBA

    Hello, I've got a little problem with my project. I have to create a workbook with a table with a button to import a folder full of xml files(columns are all the same). My problem is that every xml file got a single table, so i cant work with them in a pivot chart or something else. This is the...
  18. T

    To protect and lock cells after entry of weight in col. A, time of data entry will be recorded, comapare value, and set counter?

    Private Sub Worksheet_Change(ByVal Target As Range) Dim tasksheet As Worksheet Dim i As Integer Dim T2 As Integer Dim Lr As Integer ActiveSheet.Unprotect Password:="123" Target.Locked = False Set tasksheet = ThisWorkbook.Sheets("Sheet1") Lr = tasksheet.Cells(Rows.Count, 1).End(xlUp).Row For...
  19. L

    VBA exit Loop Until statement early

    Hi All! Happy Monday! I have a unique situation that I can't seem to find a thread for (or a YouTube video ;)). I have a macro that completes several pieces of coding... and based on what happens, the user might end up having to copy/paste information from another program into the Excel file...
  20. M

    VBA Help to get a cell value from formulas

    Hi All, I guess this is a basic question but I just can't find the answer... I'm trying to have a macro where X and Y will be used to define the address of a cell in a table. Here I have a basic example that works: Sub Macro1() Dim X As Integer Dim Y As Integer X = "4" Y = "4"...

Some videos you may like

This Week's Hot Topics

Top