Recent content by RobertKaucher

I am going to redo this to use powershell, but I have three batch files that I use. You will need PSExec for these to work. You will need to create the reg files from a machine that you have previously installed TigthVNC on already. These are documented on the TightVNC site. I use the pings just...

I recorded a macro and stole the code for the object model from the macro. This is what it looks like: $worksheet.columns.item('d').NumberFormat = "$#,##0.00" $worksheet.columns.item('c').NumberFormat = "m/d/yyyy

Let me get them together and remove all the identifying info and document them a little and I will post them. They were really quick and dirty, so there are probably far better ways to accomplish what they do, but they work!

If you would like any of my batch scripts for installing VNC let me know.

No. Using SQL is not possible due to the complexity of the calculations. I am using Excel. Working with Excel in PowerShell is actually quite easy. I am simply missing one piece of the puzzle. The point here is that this report is being generated with no user interaction. It runs daily and saves...

You should actually look into LanSweeper. I use it for this. I put in the users name into the search field hit enter and it shows me properties regarding the user including the system they are currently logged into. I then just click the computer name link and then the VNC link and it opens a...

I have used PowerShell to get data from SQL server, perform some calculations and then export the data to an Excel spreaksheet. I have managed to format the column width but would like to go one step further to modify the format of the columns contents (ie currency, date, etc) Thank you!

Special features in charting, like images and 3D charts, are supported but get displayed as the basic format (ie 3D is displayed as 2D). So nothing is broken, it's the way it is supposed to work.

I see your point, but there is logic behind this. How could you upload a document and then publish it to a *source location*? The source location is your PC. What I would suggest is that you create draft library with a workflow that publishes the document to a finalized library once the document...

If you can set up rules in OutLook you can make a workflow in SPD. I might be able to offer suggestions for how to go about it. What are the exact requirements?

200820, Are you really talikng about WSS 2.0 and not 3.0? If it is in fact 3.0 I suggest the following: * You can use SharePoint Designer, it's a free download now. * Check out Real World SharePoint...

How are the due dates set? If the due dates are set via a column, this would be really easy to set up using SPD. If the due dates are set at another time, it might be easier to use SharePoint Reminder. Without more information about what you want to accomplish it's hard to say. But saving your...

What is the error message that IE gives you?

What exactly are you trying to accomplish? It soulds like a lot of what their product does can be handled through workflows...

I thought the point here was that the end users did not have the viewer? >>> Can Sharepoint get you away from having the client install a free viewer or something?