Recent content by AlexIT

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