1. CKinTX

    Excel VBA Script to Access Files on an SFTP Site

    Good morning, all - I download files from an SFTP site, but the files don't always have a unique name. Files on the site have a naming convention of File_Name.xls for the first file in the group and File_Name_X for each subsequent file in the set where X is an incrementing value from 1 to the...
  2. U

    VBA Copy, Move and Rename based on Cell Value

    Hi Guys, I have below data on a sheet with tab name "Data" Date NUM NAME TYPE DATE Subject Note 1 Note 2 10/1/2000 1 Ben Student - Math - - 10/1/2000 2 Ann Student - Science - - 10/1/2000 2 Cher Student - Math - - 11/1/2000 2 Joy Student - Science - - 11/1/2000 2 Sam Student -...
  3. S

    Error in code to rename existing folder

    Hello, I have the following code to rename an existing folder but it gives me error in the line: OldFolderName As NewFolderName. Can I please have your help to make it work? Thank you. Private Sub CommandButton1_Click() If Me.ComboBox1.Value = "" Then MsgBox "CAR can Not be Blank!"...
  4. M

    Rename table headings using Names in another column.

    If I import a table in Excel PowerQuery, what functions and syntax do I use to reference another table for the names of the different columns?
  5. S

    A convenient way to batch rename ( not caption ) multiple command buttons on Userform ?

    Hi, I am creating an Userform with several command buttons on it. Is there a way to batch rename them as : cbButton1 cbButton2 cbButton3 cbButton4 cbButton5 … ? Note: I hope to give new names to them. not to change their captions. The way I am using now, is simply click on them 1-by-1, and...
  6. D

    VBA to generate hyperlink to new sheet and assign to shape

    Hi All I'm new here so please bear with me if I make a mistake with this post. I have assembled code (mostly not written myself but altered to suit - I am self taught & not an expert) which copies a sheet "AltPF Master - Rev 1" and allows the user to give the new sheet a name (the sheets are...
  7. R

    rename specific worksheets

    Hi - everyday i always have 3 sheet (sheet1, sheet2 and sheet3) and need to copy to new workbook. but before that, i need to rename it with - sheet1 = backlog approval - sheet2 = backlog release - sheet3 = backlog pr instead using manual effort, can you please help to create vba macro to run...
  8. Y

    Rename an Item In Listbox

    How can i rename an item in a listbox that is already loaded on a userform with a textbox value?
  9. G

    Code to split and rename files

    Hi all, I have a PDF with 20 pages and I want to split it into 20 different pages. I wonder if, appart from the first petition, could it be possible to rename those files that are going to be splitted, based on a list of names that should be in an Excel file. Any ideas? Thanks in advance for...
  10. L

    Rename header rows based on excel workbook names

    Hello I have hundreds of separate excel workbooks saved in a single folder. Each workbook has the same set of 28 variables with the same header row titles and contains monthly data on the cost of drugs. I want to run a loop to merge these workbooks into one. There are two main issues (1) the...
  11. S

    VBA to download images and rename

    Hi i have an excel file with links to images in column L i need to download them and rename them with the list in column M Thanks !:):nya:
  12. I

    Macro to rename numerous files

    Morning. I was wondering if its possible to rename a bunch of pdf files that reside all in the same folder ? Currently the files are just named like, 1.pdf 2.pdf 3.pdf All the files have a date modified next to them for viewing purposes. Can we run a macro that will rename these files & get...
  13. T

    Renaming multiple copied pictures in VBA

    Hi, I am copying charts from one excel workbook (model1), and pasting them in a second excel workbook (TempFile) as a picture. There are roughly 60 of these images. I would like to rename these images. The image names keep changing, which leads to problems for the next steps. Does anyone...
  14. H

    Code to get worksheet name into a cell

    Is it possible to have the worksheet name autopopulate into a cell? Example - I want the sheet name to appear in cell F1. Is that possible? Also, if I rename Sheet 1 to 12345, the info in cell F1 would change from Sheet 1 to 12345.
  15. Y

    Rename pictures in a particular cell

    I have pictures on range F7 in all sheets. unfortunately the names of the picture varies in all the sheets. how do i give it a uniform name like "mypic"
  16. S

    VBA - Renaming identical headers

    I have a spreadsheet with more than 600 columns. Unfortunately several of the headers are identical. I would like to rename these headers so that they become unique. Lets say that part of the headers looks like this: <tbody> a b c d d d d e f f f f </tbody> I would...
  17. J

    Replace Directory name referenced in ALL Macros in a directory?

    We just changed from Dropbox to OneDrive. I have many macros and files that reference c:\dropbox\directoryname and I need to change them ALL to read c:\onedrive\directoryname instead. Can someone help me write a macro that would open each XLSM file in c:\files, then change the word "dropbox" to...
  18. C

    How to rename a newly copied sheet using a userform?

    Looking to have a masterworkbook that when I go to a job, i can add sheets and rename them as I go since all sites name gear different. I have a set of template sheets hidden within the wookbook that I draw from, but I was hoping to have a userform with a simple text box pop up, type in the new...
  19. B

    Rename File from Hyperlink on a Sheet in Excel VBA

    I have a sheet which lists many relative hyperlinks. The 'text to display' is the filename. Using the 'Worksheet_Change' event to monitor, if a user changes the filename in the cell the actual filename should be renamed to the new value, so the user doesn't have to open the folder and manually...
  20. A

    Rename duplicate column header names

    I have a spreadsheet that gets created dynamically..and has x number of columns. It has column header names and sometimes these could contain duplicates. I want to rename one by putting a "2" at the end of the column header so that there are no duplicates. How can i do this with vba? I...

Some videos you may like

This Week's Hot Topics