wb1

HI, I am trying to copy Range W3 from sheets "Pay10" to "Pay26" in one workbook to a sheet called "Data" Range C17:C33 in another workbook. Any help would be appreciated. Sub VacationPayTransfer() Dim wb1 As Workbook, wb2 As Workbook, i As Long Set wb1 =...

Hi again everyone, Q: what's the most efficient way to search for partial matches and populate results? I'm fairly beginner at vba but learning quickly. I have two very disorganized workbooks. Wb2 is where I will make all my edits. each workbook when exported has varying lines of code...

I'm looking to open an excel file in a folder, where i know the folder path and the first part of the file name. The partial file name is in cell b3 of sheet "Control" on WB1 (it is generated using a formula so isnt text). I then what to open the file and copy all worksheets over to WB1.

I want to open the file starting with "Sales Records", and used the below code, But I get the error message that Excel can't find ...Sales Records*.xlsx Seems like Excel doesn't see * as wildcard in the below code but as part of the filename. Thank you. -------------- Dim Fname As String...

hi Everyone, I have two different Excel Workbook i.e. WB1 and WB2. I need to update particular column in WB1 from WB2. For example:- there are some common columns in both WBs (Sr no and Lifds Date). if I update Lifds date with same Sr No in WB2, then that date should be getting updated...

Hi, I have a setup of two workbooks (WB1 & WB2) where WB1 contains my UserForm and WB2 contains the master data. As it stands, when you open WB1 it automatically loads the UserForm using the below code, however, I would like to option of using a command button in WB2 to change the UserForm...

I have two workbooks, one is WB1 and second is WB2.With VBA I want to copy specific cells based on a IF condition from WB2 and double paste to WB1. Also I want to add some defined numbers into WB1. It should look like this: WB2...

Hi,. I have this and it fails at the paste for "Subscript out of range". It would seem I am not properly selecting my destination. Is it my method? Sub Macro2() ' ' Macro2 Macro Dim wb1 As Excel.Workbook 'Open PSSLA workbook first Set wb1 = ThisWorkbook Dim wb2 As String 'Open Raw Data...

I have two workbooks within the same instance of Excel, wb1 and wb2. wb1 has this code in ThisWorkbook: Private Sub Workbook_Activate() Application.IgnoreRemoteRequests = True End Sub If I go to wb2 and copy the contents of a cell and try to paste it into wb1, nothing gets pasted...