I for now have my workbook set up this way, in where the workbook is hard coded into the Set command, I am wondering if there is a way of doing this so I can have it where it is fluid? So no matter where this code is place (in another workbook) the code will adapt to it's new surroundings.
Does this make sense?
Below is what I am using now, what I'd like to have it do is for the ActiveWorkbook
or something of the sort be used instead. Since this will be set at the beginning of the code and not the middle.
Set wbOOR = Application.Workbooks("Open Order Report.xlsm")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With