I was trusting somebody could offer direction on the accompanying VBA issue. I have code which makes and spares a book document with explicit content while pulling from different cells in an exceed expectations sheet, it works fine. Where I'm having issues is, different individuals should have the option to utilize it, and I'm tired tweaking the document way code for each individual, I've attempted different variable strategies and none are working, I'm an exceptionally awkward novice with code however am learning. Might someone be able to check underneath and offer direction with the Environ string and Shells?
Click Here