workbook activation

I recorded a Macro, to get this, but the record can't actually work with returning the value and going to the next row on it's own. I'd really appreciate any help. If this can be done with a Formula or VBA macro, i'd greatly appreciate, thanks. Sub MacroTest () ' ' MacroTest Macro ' 'fileX...

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...