Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. paulmatt

    Counting pages in word document

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

    Using VB procedures to open files

    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...
  3. paulmatt

    trying to get 2 separate values in alert

    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
  4. paulmatt

    Copy several text field from Outlook and paste in other application

    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...
  5. paulmatt

    Excel Command Buttons

    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
  6. paulmatt

    Printing JPG

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

    Printing JPG

    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
  8. paulmatt

    Printing JPG

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

    Printing JPG

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

    Printing JPG

    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
  11. paulmatt

    Excel Macro Application.ActivePrinter problem

    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...
  12. paulmatt

    DOCS Open 4 vs Office 2007

    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 :=...
  13. paulmatt

    Using ClientDataSet with a local file.

    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...
  14. paulmatt

    Would like to paint TGauge in TListView

    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)...
  15. paulmatt

    Disable Windows Services Programmatically

    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
  16. paulmatt

    Find string file

    My solution would be to insist on a section name, why make life difficult ;-) If this really is not an option then Andrzejek's solution is fine, as long as "UserText=" occurs before any sections that also contain it. Paul Rigby http://www.awgarstone.com VBA - C# - Delphi
  17. paulmatt

    Using VBA to extract data from HTML

    Open the HTML file ("open" command) and find unique pieces of text either side of that which you want. This will enable you to extract the required info and use it as you wish within Excel. "InStr" and "Mid" will be useful commands. However, the easiest way in my opinion would be to use a...
  18. paulmatt

    controls don't show up on page

    Some ideas: Check the HTML using View Source for the resulting pages from your browser. Check the correct HTML tags are there. If not you need to make sure files are saved etc and correct version is uploaded to the right place etc. Put a simple version number in the page to help with this. Also...
  19. paulmatt

    Find string file

    In the following file, "c:\test.ini": -------------------- [a] b=c -------------------- "c" is returned by the following: c = System.PrivateProfileString("c:\test.ini", "a", "b") This works in Word VBA.

Part and Inventory Search

Back
Top