workbook activation

I'm trying to create a macro that will create a new workbook and then copy all sheet(1)'s from all other open workbooks to it except for the workbook where I have all my macros stored. So far, I'm able to create the new workbook and save over it if needed (and it will be). But it's not copying...

Hello, I would like to deny pasting into certain columns (F:G) without disrupting that ability elsewhere. I've searched for this and have come close to a solution, but they haven't been quite right. I used the following but it restricts pasting for the entire sheet Private Sub...

Hi guys, <o:p></o:p> I’m trying to write VB code in workbook A that monitors the next workbook to open (we’ll call it workbook B) and reports back to workbook A whether or not Workbook B is read-only or not. Workbook B could be a VBA enabled or a non-VBA enabled workbook and could be any...

Hello I have a vba routine which was performing well, but somehow stopped working and I can't figure out why. A have a macro in a workbook that is used to break down another workbook called "Report" (xlsx) in several excel sheets. Although there is a workbook activation, it is breaking the...

I have 3 different workbooks that I'm working with. 2 of the workbooks are reports that are automatically saved to a random temporary internet file folder. I was wondering if I can somehow activate the 2 workbooks without knowing the file path since they will saved to a random folder every time...

Hi Excel Ninjas, As i am new to VBA and I have been stuck for hours now, I would really appreciate your help. I am trying to copy paste the first two tabs of a file that can be located anywhere on someones machine. (This is why I am trying to use the application get open file and to assign it...

Hi All, I am trying to write a code which accomplishes the following: 1. Amongst all open workbook activate workbook with 10th sheet named as Run 2. Display message if no such sheet found in any workbook I have written the following code for the first point: Sub IdentifyValidationTool() Dim...

Hi Guys, I am currently trying to write a macro to cop and paste severall sets of data from one workbook to another. There are two parts to my problem: 1) The workbook name will be pasted into a cell which the macro will refference (the refference workbook will already be open so we do not need...

HI All, I am new to VBA. I have 2 workbooks named a.xls and b.xls. I am trying to activate a cell in the workbook b.xls by writing code in a.xls. I used the below code in workbook a.xls and got error msg as "Activate method of range class failed". code...

Hi guys, I am new to the world of VBA and i have just attempted to do a little coding. My task is pretty simple: - 2 Workbooks with multiple sheets each; - find a Question number in column A in the first Workbook and it`s corresponding answer(YES, No or N/A) and then transfer it to the next...