Recent content by paulmatt

Number of pages: ActiveDocument.Content.ComputeStatistics(wdStatisticPages) Paul http://www.awgarstone.com VBA, C#, Delphi

plus to do shortcuts - would have to go to everyone's PC" You can set up a link to the links folder (the links folder could be on a share). There really is no need to complicate this by writing code. Best to implement the good solution yourself so someone else can't suggest it and take the...

inspStartTime.StartTime & inspEndTime.EndTime end up being the same values" Yes, because you are setting them to the same value: inspStartTime.StartTime = btn.Text; inspEndTime.EndTime = btn.Text; Paul http://www.awgarstone.com VBA, C#, Delphi

I think this is a bit of a biggie for trying to get done via forums. I would suggest getting some proper help for this unless you've a lot of time on your hands. If you do or if you are a programmer go through some sendkeys and outlook vba articles/examples to get started, then post specific...

Not sure - I don't use buttons in the spreadsheet itself. You could use buttons on the toolbar instead to side step the issue. (r-click toolbar > customise > macros, drag new btn to toolbar, r-click btn > assign macr). Paul Rigby http://www.awgarstone.com VBA, C#, Delphi

Good tip with the mspaint cmd line... will make a note of that! Paul Rigby http://www.awgarstone.com VBA, C#, Delphi

I've used "shell" before to call the command line: Shell "myapp /aswitch" But you can also use the winapi shellexecute for more control. Look in the infranview documentation for details of how to call it. Paul Rigby http://www.awgarstone.com VBA, C#, Delphi

Well you can just call infranview command line from vba using shellexecute or similar. Paul Rigby http://www.awgarstone.com VBA, C#, Delphi

Yep - even better! Paul Rigby http://www.awgarstone.com VBA, C#, Delphi

You don't need Excel to do this. There are various batch printing utilities, one is called infranview. It can be run from the command line too. Paul Rigby http://www.awgarstone.com VBA, C#, Delphi

You could loop through the active printers and look for one with "ken's" in the name. Or if the expected printer name isn't there in the available printers, pop up a form which allows the user to select the printer from a drop down list. The result could be saved in the registry or a text file...

I don't have an example from Excel, only Delphi, but you basically have to create an instance of the DocsOpen OLE class and then you can do whatever operation you want. In Delphi this is how we got started: Docs := CreateOleObject('PCDocs.Application'); Prof :=...

You don't need to create the file, CDS will do this. 1. Drop a tclientdataset on a fresh apps form. 2. Set fielddefs (eg Name and Value, type string, SIZE 250) 3. Put this for the "write" button: with ClientDataSet1 do begin CreateDataSet; Open; Append...

You need to write a component. http://bdn.borland.com/article/0,1410,20569,00.html I would start something like this: inherit from TListView (or one of it's ancestors), use custom TListViewItems which each include a gauge (you will need to instantiate and position them etc. using code)...

Yes, it certainly used to be (not sure about Vista). Quick and dirty: winexec(pchar('net stop spooler'), SW_SHOW); Substitute "spooler" for the name of the service. Paul Rigby http://www.awgarstone.com VBA, C#, Delphi