newname

Hi Any idea why this not working? :D Sub ChangeInFolder() Dim OldName As String Dim NewName As String Dim LastRow As Long Dim i As Long LastRow = Range("A65536").End(xlUp).Row For i = 1 To LastRow OldName = Range("A" & i).Value NewName = Range("C" & i).Value Name OldName As...

Hi Guys I am hoping someone can help me with this..So I am trying to create a copy of one worksheet and paste special values. I'd like to be able to choose a name for the worksheet and keep the worksheet within the existing workbook, moving the worksheet to the front. Apoligies if the format is...

Using the Below CODE: Sub Copy_Unprotect_SCHEDULE()Dim NewName As String NewName = InputBox("ENTER THE DAY OF MONTH THE NEW BID STARTS?") MsgBox "Importing data will take a few moments we will notify you once completed", vbOKOnly Sheets("SCHEDULE").Select Sheets("SCHEDULE").Copy...

hi, i am out of my depth here. I cold really use some help. I have cobbled together a macro that (should) look through a column, create new sheets based on the values in that column, copy the sheets to a new workbook with a name chosen by the user, then delete the new sheets on the original...

The code i have is to copy a template, ask the user for the sheet name and some data. All this works fine however the next part of the code is to hide some rows and this always happens on the template rather than the new sheet. Does anyone see what the issue is with the code as to why this...

I am adapting an old workbook for a new training program. I would like to rename each sheet by employee name but the way it is structured that format is not working. The cover sheet has a drop down to navigate to the employee page but it will not display the name unless i name the sheets 1,2,3...

Trying to do something that should be simple, I'm just not familiar with VBA syntax. I'm decent with C++, Python, and LUA, but I don't know about VBA. I have a command button that prompts the user for a name, then creates a sheet based on a template sheet with that name. That works fine...

Thanks in advance for any suggestions which I will provide feedback. I am making an Excel file where I place the directory path (Cell B3) of where files that I may want to rename are located. It first obtains the file names and places them in Column A starting with Row 5. I then place the new...

Hello all, I've been working on a Table of Contents (TOC) sheet with hyperlinks that can be copy and pasted into any workbook and will automatically populate with the sheet names of that workbook. It can also duplicate any sheet named "Master Template" with a button that references a macro...

So the current error I get is an End With without With I've tried to add something that has "with" and then I get the error "For without Next" and if I add a Next, then I get the error "Next without For" What the heck am I doing wrong? I'm trying to do the following tasks: 1. Create a folder...

I'm using the following code but get a runtime 424 error. Also, I would like to the sheet name in c17 to last cell Private Sub CommandButton1_Click() lastcell = ThisWorkbook.Worksheets("Master").Cells(Rows.Count, 1).End(xlUp).Row For i = 17 To lastcell With YhisWorkbook newname =...

Hello, I'm trying to duplicate and save my active workbook but for some reasons, the following error is popping up during the macro execution; "Permission denied - Run time error 70". I tried to browse around but i still cannot find where I made the mistake in the coding. Any help would be...

I'm trying to do something that I thought was straight forward. I'm trying to move and rename a file from one folder to another. After doing the Google search I found: Sub Move_Rename_One_File() 'You can change the path and file name Name "C:\Users\Ron\SourceFolder\Test.xls" As...

Hi, I have a piece of code below that works a treat when exporting tabs to a new file as values only. However I ran into some trouble today when i changed one of the columns to have indirect formulas and now for some reason this code does not like it, it just copies them all across as blank...

Hi, I am trying to create a VBA which will search a numeric number as given in excel in PDF and extract the pages. Code is working fine but rather is very slow. It seems on below line it loops many time. How to limit this? As my search limit on 14 count only where it finds the value. For...

Hello everyone, I would like to create a macro that copy my "worker" tab and pop a message box that will change the name of the new tab for example: "worker" >> "XXX" Also I want the macro to clear the contents of the cells I would allocate for my needs for example: A1 A2 A3 >>> Those are...

Hi to everybody.. I'm renaming my pdf files in one folder from the excel sheet list which my PDF filename are drawing number only but I want to add in my pdf filename the drawing title which is in the excel sheet. So I made this vba code but now its not wor What is the wrong in my vba code, i'm...

Hi I am using the below script for copying specific worksheets from a workbook. I want to add for copy multiple Charts and Shapes as picture. Charts as Chart No. 71, 24 & 35 and Shape as Rectangle 53, 54 & 54. Option ExplicitSub RunMacro1_Click() Application.Calculation = xlCalculationManual...

I'm trying to copy 4 worksheets to a new workbook and remove any and all formulas in the process. the code that I am seems to work If I am exporting the cover page only, but becomes unresponsive if I add the rest of the sheets to the code. any tips on how to improve this so that it runs...

Hi, I am using the below script for copy two worksheet to a new workbook but i do have two issue with this: With the available script: 1) As my original worksheet alternate rows are filled with specific color, which is getting change after copying the data to new worksheet. 2) When the pop up...