R
Ray
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?
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?