Thank you this was my attempt after looking at multiple solutions and piecing together parts that I through were relevant which I know isn't the best way to go about it but if I was to set a specific path in the export command how is that formatted? and would it need to be the full path if it was going to be on a network drive?

I am planning to learn more VBA but unsure where/ how to start. I looked up syntax and where i was learning did not mention anything about line continuation characters but it does make sense coming from java where the way you ended a statement was ;

Thank you so much.