Robert Mearns questions

Robert Mearns answers

• 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]
• Excel formula to get ranking position
• How do get the index of a table's column by using a structured reference in excel?