copy worksheet vba

Hi all, I have made a macro in excel to copy a worksheet from another workbook without opening that second workbook, but this code only worked the first time. Sub CopySheetFromClosedWB() Application.ScreenUpdating = False Set closedBook = Workbooks.Open("C:\Users\RubenDias\Desktop\Mapas...

Hello Everyone, Need help to save excel sheet data in xml format. For example, i need to save the data from Sheet1 of my workbook in xml format seperate file. From the following range, i can only copy "Column A" data but i need to expand the range of the column. Range("A1:A" &...

Hello, I have about 100 files and i need to extract one specific sheet name "ADDBC" to a Master Workbook. The ideia is to have the master workbook with the the sheetname+fileorigin. So on master workbook i would have sheets: ADDBC File 1 / ADDBC Files 2 / ADDBC Files 2. I have tried...

I hope someone can help me with a bit of VBA I need to customise. I want to copy worksheets into individual workbooks using their tab name. When copying them over, I need to paste the contents of the worksheets as values only. I thought I could change the code to ".PasteSpecial...

Hi All, HELP, I'm confused.... The below code works at home on excel 2016 however in work where we use 2010 it fails on the wb.sheets(arr).copy line any suggestions? is it really a version difference or am i missing something? Thanks in advance for any suggestions :) Sub copysheets()...

I have been using the following code to make 12 copies of a master worksheet in the same workbook and rename the worksheets. The problem is it starts renaming at the beginning of the work workbook. I need it to start renaming the tabs after the master, in this case titled "EOY". Sub...

Hi all, I have a folder which contains like a 100 .xlsx files. I want a Macro which uses the Folder Picker to input the source folder. then, the macro should look for each workbook in the folder and and look for every worksheet in the workbook for C15="5/7/2016". If a specific worksheet has...

Hi all... I have been searching for reasonable solutions to this process. So i have a Folder that is storing data from a test process. This means there are multiple files to copy from.The files have an extension of .tdms or .tdms_index. These each have two worksheets in it. The second one...

Hi All I need some help with VBA code to copy a template tab multiple times and rename each new tab from a list. * My template tab is called StudentA * My list is in a tab Data Input cells A4:A50 What I currently have is: Sub Copy_Sheets() Dim i As Integer Dim wks As Worksheet...

Hi, I am trying to copy worksheets with specific names to a new workbook. I want to copy the worksheet from a master template workbook. My problem is that it creates a correctly named worksheet in a new workbook and then searches that new workbook for the sheet template name (which does not...

I have this code that, in an existing open workbook (let's call it "Template"), looks for any tabs that have a name begining with "CC". For each of these tabs, it copies the tab into a new workbook, deletes any extra tabs, then saves the new workbook to my desktop. Sub Copy_Save_CC()...

I am using the following formula to display the first 7 characters of a worksheet name in a cell. =LEFT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256),7) It works perfectly. However, when I copy the worksheet, move it it a new workbook and save the workbook with a name that is...

I'm creating a worksheet for my wife to manage a roster for her bootcamp clientele. I have successfully created the userform that runs from a macro button for adding new clients to the roster. When running the userform VBA, several data fields are generated for each new client in several columns...

Hi Everyone, I am a real beginner when it comes to VBA so I need your help! I am reading Mr Excel's book on VBA and Macros but I cannot find a solution to the problem below. Any suggestions on how to do the following? The macro will be applied to an open workbook, lets call that...