Re: Cannot saveas HTML in VBA

From: as above (anonymous_at_discussions.microsoft.com)
Date: 03/30/04 

Date: Mon, 29 Mar 2004 23:17:35 -0800

THanks for the reply . But sorry your wrong the path was
split over 2 lines due to the forum. Any way i can save it
from excel. It is also only for internal use (intranet)
and I work with the people who design the web pages that
link to the file once it is created.
also the xls file is saved to same location which means it
is not a permissions thing either.

oh well i better get back to the drawing board.

chris
>-----Original Message-----
>Hi Chris,
>Just a guess. NOT!
>"webb\wwwroot" is a dead give-away.
>Your trying to write a file to a web server.
>Most files are stored on web servers in folders set to
read only mode.
>This is a web server permissions/security setting to
prevent people from
>doing exactly what your trying to do.
>
>The best way to solve your problem is to call your host
and have them create
>a new folder for your file and set the folders
permissions to read/write.
>Most likley they will insist on you using (passing) a
password in the
>process.
>
>Not to mention you may need to upload it in FTP mode.
>
>
>--
>John
>johnf 202 at hotmail dot com
>
>
>"Chris" <chris.fridd.removelastdot@uk.fujitsu.com> wrote
in message
>news:14f1201c41576$b52101e0$a401280a@phx.gbl...
>| 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

  • Re: Hacker "scanned" my webserver
    ... I suspect the folders were made undeletable using the Posix subsystem, ... change the permissions so that the anonymous user does not have ... If this was an IIS web server vulnerability, check the web server logs, ...
    (microsoft.public.win2000.security)
  • Re: File Server Migration
    ... Chris, we'd like to get more information about the permission issue you ... When> I start a project of files to copy from my old NT server> to my new 2003 server, the share name of all the folders> gets changed to foldername_oldservername. ... This obviously> won't work and if you try to change the sharename it takes> away all of the permissions of the folder. ...
    (microsoft.public.windows.file_system)
  • Re: Access List
    ... If the old and new machines are in a domain and the ... could just use xcopy to copy with permissions. ... "Chris" wrote in message ... > I'm in the process of upgrading to Win2003 from 2000 and moving folders ...
    (microsoft.public.win2000.security)
  • Web forms will not run
    ... I had a hardware malfunction in an old web server. ... have copied the folders and web pages, ... I also elected to tighten security. ... permissions that will allow security compromise. ...
    (microsoft.public.inetserver.iis.security)
  • Cant access dynamically created directories via web.
    ... creates folders on my Windows 2000 web server. ... cascade all of its permissions to its children. ...
    (microsoft.public.win2000.security)