Recent content by mozingod

I'm having the same problem on at least one so far. It's a WinXP box that has every other setting from the GPO, and even copied its current My Docs to the new share, but it still points locally. If I find anything I'll let you know... Darrell Mozingo

How can I set a user as the default owner for a directory and have it apply to all files/folders created in there from then on? It obviously works if I do it by hand, but any newly created files makes the administrator the owner, despite it only having read access and the user account full...

We have a Netapp NAS that we're trying to host our .NET pages off of using Server 2003/IIS 6. We followed Microsoft's little guide for doing this ( here ) without any luck. We're currently getting the following error: ---- Server Application Unavailable The web application you are attempting...

Is it possible to change where the documents are stored once uploaded to a Sharepoint Services site? We'd like to keep the documents on a NAS to make it easier for local users to access and to off-load the load from the Sharepoint server. I searched all over for an answer with no solutions. Any...

Galen: I finally got it! The code that did it for me was: ActiveWorkbook.PublishObjects.Add(xlSourceSheet, "C:\Inetpub\wwwroot\Plant\Metrics\ScheduleAccomplishment.htm", _ "2003 Schedule Accomplishment", Title:="Schedule Accomplishment&quot...

OK, using: ActiveWorkbook.PublishObjects.Add( _ SourceType:=xlSourceChart, _ Filename:="C:\Inetpub\wwwroot\Plant\Metrics\ScheduleAccomplishment.htm", _ Sheet:="2003 Schedule Accomplishment", _ Title:="Schedule Accomplishment").Publish True I get the...

Unfortunately it's not protected, although one of the other workbooks I need to do this to is, so that information will be very valuable then. I realised that the sheet I was trying to publish was a chart, even though I used that sheet property. So as a test I pointed it to a normal sheet just...

Well it's still not working for me. Could there be something else I need to install w/Excel? Darrell Mozingo

Removing the spaces still gives the error unfortunately. Darrell Mozingo

I'm in the same situation now. I was brought from the corporate headquarters out a smaller plant (200 people) to make them in intranet site and do a PC software/hardware audit. Well, those were done with in the month and they have nothing much to give me. They keep telling me they have to get...

It's the right name. Would putting spaces in the name affect it at all? Darrell Mozingo

Hmm, happen to know why I'm getting this error: Run-time error '1004': Application-defined or object-defined error when I run this code: Application.DisplayAlerts = False ActiveWorkbook.PublishObjects.Add( _ SourceType:=xlSourceSheet, _ Filename:="C:\filename.htm", _...

A * for all that help. Thanks!! Darrell Mozingo

Wow, that's great Galen, thanks! One last question... is there a way to block certain sheets in a workbook from being saved as html? Or only allow certain ones? I've never had the need to look into what VBA can do before now :) Thanks! Darrell Mozingo

This might be a bit over the edge to make it transparent to the users/authors of the spreadsheets, but is there a way to make it automatically over-write the saved .htm? I have the code going good, but it still pops up on closing the workbook to see if they want to over-write the old one, which...