We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Private Sub cmd_OK_Click() 'This will paste the copied data from the Braintree ' Settlement Batch Summary Report '------- 'Declare Variables Dim rBraintree As Range 'First Cell in Braintree tab to paste info. Dim strAddress As String 'Ref Edit address '------- 'Address of paste area from refedit control strAddress = ref_Recon.Value 'Set Paste Range Set rBraintree = Range(strAddress) 'Activate the second workbook to paste the data rBraintree.Parent.Activate 'Select the paste destination cell rBraintree.Select 'Paste the data ActiveSheet.Paste 'Reset the ref_Recon refedit control Unload Me End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Problems moving Excel files from local drive to server||4||28|
|MS Access How can I add a relative path to my VBA PDF output that will work for most Windows computers?||4||28|
|Tricky shapes formula part 2||4||19|
|How to loop thru all queries and find which one's were affected by a table change.||47||36|