Re: Cannot saveas HTML in VBA

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 13:23:23 GMT

Can you save using XL's GUI?

If you turn on the XL macro recorder before saving the file, what code
does XL generate?

Does that code work when you execute it using the same logon ID used to
create the code?

Does that code work if you use the automated process (with whatever
logon ID) that you are trying to develop? 

-- 
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <14f1201c41576$b52101e0$a401280a@phx.gbl>, 
chris.fridd.removelastdot@uk.fujitsu.com says...
> I cannot get VBA to save a html file it says that the save 
> location is read only. Which I know for a fact is untrue.
> I have written code inoutlook to save an attachment to a 
> folder as a xls file. I have to open it up then save as a 
> HTM file . I can open it up only by using a read only 
> option as it says it is in use. It will then save as a htm 
> which fails saying it is ready only access. If I then open 
> up excel the file is still there in html format and then I 
> click save as web page it does it. Why does it not do it 
> in VB code.
> the code i use is below with the serve name changed. I use 
> the excel 10 referrence.
> 
> Excel.Workbooks.Open "\\fakeserver\the web\WWWROOT\Daily 
> Demand Report\daily demand.xls"
> Excel.ActiveWorkbook.SaveAs "\\fakesever\the 
> webb\wwwroot\daily demand report\Daily Demand.htm", xlHtml
> 
> any help would be appreicated
> Thanks
> Chris
>

Relevant Pages

  • Cannot saveas HTML in VBA
    ... I cannot get VBA to save a html file it says that the save ... HTM file. ... the excel 10 referrence. ... Demand Report\daily demand.xls" ...
    (microsoft.public.office.developer.vba)
  • Re: Cannot saveas HTML in VBA
    ... >>Does that code work when you execute it using the same ... >>Excel, PowerPoint, and VBA add-ins, tutorials ... >>> I cannot get VBA to save a html file it says that the ...
    (microsoft.public.office.developer.vba)
  • Re: .SeriesCollection(2).Name and .Deselect
    ... Does the code work in Excel 2003? ... You do know that's what a Beta is for, ... The ".Deselect" command is no longer allowed. ...
    (microsoft.public.excel.charting)
  • RE: Manual Autofilter works, but recorded Macro does something els
    ... Maybe I should have told you that I am running a swedish version of Excel ... your's and my code work. ... before this strange autofilter comes from you originally also! ... and recorded a macro without problem, but when I run the macro, no data is ...
    (microsoft.public.excel.programming)
  • When to use ReleaseComReference in Office automation
    ... I'm working on Excel on the server side. ... Should this function only be called after the Quit() ... Will the code work, or will this cause adverse effects (like losing the cell ...
    (microsoft.public.dotnet.framework.interop)