rename

Hi, I've been searching for a Macro that enables me to rename various sheets in my workbook based on the initial few Characters and rename them to specific names. for example the sheets have the following names: BBBO000102_abcd017_CancelledTrades2018-04-12-05-18-54...

Hi! In Worksheet1 I have a lot of shapes, some has same name. I want to rename all shapes in Worksheet1 to: Picture1, Picture2, Picture3, Picture4, ..... and so on. Please help. Function ShapeAtActiveCell() As String Dim Sh As Shape For Each Sh In ActiveSheet.Shapes If...

Hello, Is it possible to create a window or box on a sheet within a workbook where I could drop another workbook into and it would rename it and save it to a predetermined location?

Hi Gurus, I have been browsing to find a solution but none have specifically fit the criteria I need and what testing I have done has failed. I am attempting to leave a workbook I created years ago in the hands of those far less familiar with Excel and even less familiar with VBA and I just...

Thank you for your help with my previous query My Workbook is taking shape quite well now but I have come across another stumbling block. The workbook contains a Worksheet called Data and this sheet contains information about sheet names. The list contains 3 columns (A:C) which detail the...

I have a workbook with multiple tabs/worksheets. I need to rename the tabs based on a list in one of the tab. The list has 2 columns - A and B. There are names of tabs in column B but they needs to be renamed by their corresponding cells in column A. e.g. column A Column B abcd rtyu...

I know how to rename a sheet when I already know what the sheet name is going to be. For example I geta weekly file from an external source and I rename it as follows. 'Rename sheet in Study Summary Workbooks.Open Filename:= _ "G:\Database\Database files\Study Summary.xlsx"...

I have the following in formula in a Microsoft query. The formula works fine. I would like to rename the column so it displays as a name rather than the formula. DateDiff(Day,ProdPattern.ProductionMonth,DateAdd(Month,1,ProdPattern.ProductionMonth)) I have tried...

Hi all I am having a 'senior moment' here - in the past I have been able to rename forms in my vb editor, but have totally forgotten how and I can't find a simple way of doing it. Can somenone please remind me how its done? Thanks.

I doubt this is possible but, it is worth asking. If you have a file closed on your computer,... lets call it FILE-X you could copy and paste it and then rename the file outside or you could rename the file outside. Is there any way to check if a file is renamed or duplicated first? (I can log...

Hello, If I were to rename "Sheet 1" to "My Tab", is there a way for me to find out that "My Tab" is actually "Sheet 1"?

I have written below code but its not working as required: My requirement is: Copy Sheet1 of Source.xlsm workbook to another workbook, s.xlsx and then rename the copied worksheet to value of D1 cell of this sheet. If sheet name of same name do not exists then it should rename and if name exits...

Hi Friends, I am using powershell code for splitting a CSV file because it is faster than VBA on CSVs. I am splitting the file based on one specific column. So, if any values are blank in this column , powershell is generating file named .csv. My question is can we rename this .csv file to...

Hello all, I've run into a problem with some code I'm writing. I can't seem to get my code to copy and rename a file consistently. It will do it once, but then it doesn't work after the first name. Essentially, I have a table of employee names in a workbook. I've written macro that will rename...

I have tried some codes I found with no success. What I am trying to do is copy a template sheet and then having it rename the sheet from a cell value. The cell value can be on the template or my cover sheet that I have. If the name already exists I'd like it to not to make another copy and just...

Hi Is it possible to link the name of a named workbook range to a cell on a sheet. I would like to make the name of the range dynamic? When the title of my named ranges change i currently have to rename all the Named Range Names as well. All ideas appreciated Cheers Paul

I have a written macro that works but one little issue. It is setup to create a new excel worksheet (BOOK1) and then rename (BOOK1) to current date. Although, the user of the macro has decided that he/she wants to run it several times while its still open. In doing that the next time it tries to...

I have group number and need to validate the letter "A" at the end and if doesn't exist need to put in. I currently us this code to rename and want to add a validate if the letter A is at the end then rename to B. Dim Addr As String Addr = "A2:A" & Cells(rows.Count, "A").End(xlUp).Row...

Hi, I am trying to rename multiple worksheets with the left 6 characters in cell A3. Can anyone suggest a VBA macro that would rename all worksheets in one run. Thanks in advance!

Hi guys, I want to duplicate a worksheet 10 times, and rename those 10 sheets according to a table of names residing in another spreadsheet. Currently I've written the following code: Dim iSheetNumber As Long Dim rNewSheetNames As Range Dim rName As Range Set rNewSheetNames =...