![]() |
Applying an Excel macro to an Excel file from within HTML
I have a TXT file containing work orders that is being automatically
generated each day to ensure that I have the most up-to-date work order information. The file is generated as a TXT file but is saved with an XLS file so I can open it with an embedded IFRAME tag in an HTML file for easier viewing, sorting, etc. However, because it is originally a TXT file, the column widths are all off in the Excel spreadsheet. Again, this file is overwritten each day. I have recorded an Excel macro and saved it in another worksheet. From within HTML (i.e., when the user selects the page containing the IFRAME that calls the Excel spreadsheet), is there a way to either launch the macro from one worksheet and apply it to the daily regenerated worksheet OR define the column widths in the IFRAME call itself? |
All times are GMT +1. The time now is 07:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com