| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number Format on Excel File saved from .html file | Excel Discussion (Misc queries) | |||
| Applying a macro to a command button, Excel 2002 | Excel Discussion (Misc queries) | |||
| How can I open an Excel 2003 HTML file in Excel 2007 | Setting up and Configuration of Excel | |||
| swf flash file embedded in html file which is edited in excel.. he | Excel Discussion (Misc queries) | |||
| Ftp an html file generated by an excel macro | Excel Programming | |||
Linear Mode
