Convert Excel to HTM when running Access

T

TerryM

I would like to save an existing Excel file to HTM format while in Access.
Is it possible for this to be done?
 
A

Alex Dybenko

Yes, you can create excel instance with code, open excel file there and then
save it as HTML using saveas method:

..SaveAs Filename:= "C:\xxx.htm", FileFormat:=xlHtml
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Difficulty with compatibility mode and Track Changes 2
Can't save my Office documents (after computer rebuild and reauthorization) 0
Excel does not accept text format! 0
Sharing Access MDB or Accdb with client using older or newer version of Office 1
Merging from an Excel file with graphics 1
Default local file location - folder redirection slowness 0
Found few bugs in my daily routine of work in excel for MAC 0

Top