I am struggling with how to write a macro that will;

1. publish a static named range to HTML, AND;
2. let the user set the path and file name to be saved.

Any help would be most appreciated.