Hi all,
I've recently written some code, the crux of which (there's a lot omitted here) looks like this...
Basically, a button is pressed on a sheet>range B2:M2 is then copied over to the next empty row in "Incident Log - Database.xlsm". That part works a wonderfully, but being very new to this, I was a bit disappointed when I realized the destination workbook needs to be open for this bit of code to function correctly.
Is there a way to make it work without the destination workbook being open? I cannot allow users to open the Database file for GDPR reasons.
Thanks everyone
I've recently written some code, the crux of which (there's a lot omitted here) looks like this...
VBA Code:
Sub CopySend()
'Main: Copy and paste to database code'
Range("B2:M2").Copy Workbooks("Incident Log - Database.xlsm").Worksheets("All Incidents").Range("B" & Rows.Count).End(xlUp).Offset(1, 0)
End Sub
Basically, a button is pressed on a sheet>range B2:M2 is then copied over to the next empty row in "Incident Log - Database.xlsm". That part works a wonderfully, but being very new to this, I was a bit disappointed when I realized the destination workbook needs to be open for this bit of code to function correctly.
Is there a way to make it work without the destination workbook being open? I cannot allow users to open the Database file for GDPR reasons.
Thanks everyone