Board index MS EXCEL

Export from spreadsheet to HTML using a macro

Export from spreadsheet to HTML using a macro

Post by n.kennedy9 » Sat, 16 May 2009 20:51:35


Hi all

I have a few files set up, and have set up sheets within the files to
export to HTML using the File -> Save As Web Page menu command.

When I set these up, I used the full file path (not a drive letter) as
others also need to be able to export the HTML files. However, I can
run the files, save and have the exports produced, no one else can.

Is it possible, therefore, to have the export written within a macro
so all will be able to export properly.

Cheers muchly in advance

Neil
 
 
 
Top

1. Exporting from an HTML table to a Spreadsheet

2. How do I export a date&time in a macro-Transfer Spreadsheet name

="O:\Folder\Folder\FileName" & (Format(Now(),"yymmdd")) & ".xls"
I'm trying to transfer a spreadsheet but want to add the time to the date
because the spreadsheet may be run several times in a day, so I don't want it
overwritten. I've tried adding time by doing the (Format(Time())
expressions, but I get error messages.

3. Macro to Export Query Data to Excel Spreadsheet

4. Macro to Export Spreadsheet; Keeps Failing

5. Macro Running Qurey with Multiple Criterior for Export to Spreadsheet

6. VBA/Macro export to HTML ~with formatting~

7. Exporting to HTML with formatting -- VBA or macro

8. can I export a spreadsheet into a different spreadsheet with different column headings

9. Import spreadsheet, MATLAB calc, export spreadsheet

10. Exporting Excel Spreadsheet to XML Spreadsheet.

11. Printing report b after report a prints using report a's variables

12. Exporting Word Bookmarks from doc to excel spreadsheet using word

13. Using Export to create a spreadsheet containing formulas

14. Export to Excel Spreadsheet Using Filter

15. Export Media Player Libary to a Accfess Database or Excel Spreadsheet-Using Vista

All times are UTC
Board index