Search results for query: *

Company changed from Esselte to Roltech in the 90's...try: http://www.roltech.co.uk/ or dig into the abandonware software sites and see if its been freely distributed.

I am not familiar with the Crystal DLL, some of the software I use allows to pass the printer settings through the control, see below example: Dim ps As PageSetup Set ps = file.PageSetup ps.Orientation = 1 ' 1=Portrait 2 = Landscape ps.PrinterPaperSize = 1 ps.Duplex = 2 ' 0=Off 1=ShortSide...

I use a simple bat file like: net use x: \\server1\share then call this from vbs with wscript.shell.run

You have to preset the values in the registry to prevent the user prompt from appearing. Here is a helpful thread: http://www.ozgrid.com/forum/showthread.php?s=0648824ef474da459561ddfb0b2c2458&t=25773 or google for vba access pdf, there are several more sites addressing this. Good luck, Alex

Star for pbail1!

Macaffe used to have a free automated attack as part of their managed service. I used it once or twice and it was slightly helpful...

Sorry I thought the recorder would pick up a little bit more...try this: Sub CSV_Files() 'Just setting up for the open file portion Set fso = CreateObject("Scripting.FileSystemObject") CSVfoldername = "c:\temp\" Set CSVfolder = fso.GetFolder(CSVFoldername) j = 1 'Open only .csv files using...

Open Excel, start Macro Record, open the first csv, open the second csv, stop recording. Now look at the recorded macro, you will see how to import each csv to a worksheet. Make this loop.

Google or threadsearch here for Mail Marshal, we've been very happy with this product for years.

Look at FSO like: Set folder = fso.GetFolder("folder") For Each file In folder.Files If (Left(file.Name, 7)) = "example" Then 'do something End If Next

Google for "Express ClickYes" for a seperate program that will click the yes button for you...ever since that Outlook "Security" update you cannot script an e-mail.

Make a rule...

Maybe when you apply the next "service pack" it should "automatically" enable just password expiriation. Blame it on Microsoft but Win2k server SP3 did that for me once. Once users get used to changing passwords every so often the complexity issue becomes much easier to deal with...

Try to interact with the clipboard directly after taking the screenshot, this site gives some good ideas: http://www.xav.com/perl/site/lib/Win32/Clipboard.html I would take the screenshot, print the clipboard to a PDF driver, then add the pdf file to the message as an attachment using... Set...

I have no suggestions to block external mail based on Computername, by user easy, to block all mail from a given PC easy, but only outgoing mail by computername...not so easy. What is your exchange config? Do you have any other mail software running (anti-spam, mail AV scanners, etc?) Maybe one...

Been a big fan of Mcaffee since a bunch of relatives got infected while running Norton AV (a few years back.) Now have something like Devastator...our Velociraptor runs Symantec AV on everything passing through while the whole LAN runs McAffee (ASAP on desks, with Groupshield on Exchange...

I have used the following code to merge a single Excel file into a DB...you can probably get it to recurse a directory and grab each excel file pretty easily: Note: In my case I had unique ID fields so I only compared this to see if it was present in the DB, you may need to compare more...

Following up to a previous question I had, when I wshell.run "c:\test.xls" I create an instance of Excel that is not visible...in VBA I would add an oExcel.Visible=True. How do I do this in vbscript?? Thanks, Alex

Refer to this site: http://www.granite.ab.ca/access/pdffiles.htm though its a year out of date it tells you what you could do...

the user has to enter the file name before the file is created" This is same problem as CutePDF... The only one I've seen that does not require mucking about in the registry is "pdf995". It stores output file name and folder info in an .ini file. All you need to do is write the .ini file with...