workbook2

I am experiencing a replicable problem with Excel 2016. I've created an application, that will work flawlessly in Excel 2010, but not in Excel 2016. In the app, the user selects a workbook from which they will be asked to select multiple, seperate ranges. There's a form with multiple...

Hi,can anyone help? I have a macro that calls a sub and then copies the data to workbook2. If workbook2 is not open I want to skip a certain part of the code so it doesn't error because workbook2 is closed. does anyone know of a line of code I can add within the macro to skip a certain part...

Hi can anyone help with a line of code to copy data from workbook1 sheet1 range ("A:AS") to workbook2 sheet1 range ("A:AS") Regards pwill

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...

Hi can anyone help with a macro to copy a range of data from one workbook to another? I have rows of data on workbook1 sheet(Data) range A2:H that I want to copy to workbook2 sheet(Data). I need the data to copy to workbook2 in the same columns as workbook1 but continue the data to the next...

hi, I have huge data in 2 Excel workbooks, i have to fetch data from workbook1 to workbook2. Both files are on shared drive. i tried to use vlookup to fetch data from Worbook1 to Workbook2 but due to having huge data(round about 5000 raws, 50 to 60 columns ), Vlookup does not get refresh...

Hi, I am using Workbook1. And from Workbook1 i open Workbook2 in read only mode "workbooks.open("Workbook2"), readonly = true because i am using workbook2 only for read purposes, i dont want to save it. but excel gives me warning to save the workbook. I have tried to put this command in...