Robert Mearns questions

Robert Mearns answers

• How do I use a parameter in an Excel external data request?
• How to obtain the n-th letter of the alphabet
• VBA: Get Excel FileDialogOpen to point to "My Computer" by default
• Create Excel file as html markup
• Prevent cell resize in excel [closed]
• Setting date cell format in excel xml
• Updating data source on multiple pivot tables within Excel
• How to automate converting Excel xls files to Excel xml format?
• Adjusting worksheet zoom level based on screen resolution
• Ctrl-End doesn't bring me to the last cell [closed]