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
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
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
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
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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.