Search results for query: *

Hello All, hope somebody could help with this. We regularly receive text files, which contain list of hyperlinks to ZIP files, which we need to download to a local drive. Doing it one by one could be annoying so, is there a way to automate this task, using Excel VBA? Thank you

Hello maybe it's not a right place, but I hope somebody has a solution for the issue I have. I am using an application which has batch printing capability, but when one has to click on Print button in Print dialog when another PDF is opened, it doesn't feel like batch printing. Normally...

Hi All, I have a question for you and hope someone has already figured out the issue I am having. I am trying to automate some tasks in Acrobat using JSObject and VBA - or, VB -, and while everything seems to be working, I can't convert PDF I am working with to JPEG, using method saveAs of...

Hi All, I have a question for you and hope someone has already figured out the issue I am having. I am trying to automate some tasks in Acrobat using VBA or VB, and while everything seems to be working, I can't convert PDF I am working with to JPEG, using method saveAs of JSObject. Not only I...

Hello everyone! I hope this is correct forum for my questions. If not, please point me to the right one. Here's my situation. We have processed data - extarcted contents and metadata - for our clients using some application. Data is PST files. During post-processing analysis of metadata, we...

Hello everyone, I have this weird - at least to me - problem. I have files' names that contain "/" characters as in "10?13?2010 RER Weekly eNewsletter [72A6][122096].eml.msg.htm". The task is to to rename files by replacing "?" for "_". When I go character-by-charater in the file name, using Mid...

Hello everyone, I have this weird - at least to me - problem. I have files' names that contain "/" characters as in "10?13?2010 RER Weekly eNewsletter [72A6][122096].eml.msg.htm". The task is to replace "?" for "_". When I go character-by-charater in the file name, using Mid function as in...

Hello everyone, I hope somebody could explain to me - in plain English - the meaning of domain name "corp.com". We have software that processes Outlook mailboxes and extracts metadata for mail items. Some of these items have <From> field populated with something like that "some_name@corp.com"...

Hello everyone. I have a question for you. I need to create a Sceduled Task to run a script on remote machine. Below is the code I use for training, so to speak. This code fails with Error 22. What might be the reason? strComputer = "." Set objWMIService = GetObject("winmgmts:" _ &...

Hello everyone, I hope someone could give an advice here. I'm trying to figure out how to run scripts remotely - so, I started slowly with a simplest script, which I can't seem get to work. Dim Controller, RemoteScript Set Controller = WScript.CreateObject("WSHController")...

Hello everyone, I have a question for you. Is there a way to read email header using VB? The reason for that is that when I try to read properties of email, in some cases sender's email address is returned in a form like: [COLOR=red]O=MAIL/OU=xxxxxx/CN=RECIPIENTS/CN=xxxxxx [/color red] When I...

Hello everyone! I have a problem that I hope you'll be able to help me with. I'm using VB6 to create some reports in Excel. Depending on the type of report, there will be different number of columns. So, I have [COLOR=blue] xsl as Excel.Application wbk as Workbook wsh as Worksheet [/color...

Hello everyone, I have a question for you. I need to do some processing on a bunch of text files, using VB 6. I know that they are UTF-8 encoded files. I tried to read them using Scripting Runtime objects and methods, but only got garbage. I tried to use ADODB Stream object as I had found a few...

Hello everyone, I have a question for you. I need to do some processing on a bunch of text files, using VB 6. I know that they are UTF-8 encoded files, but is there a way to figure this out before I start process them? Some VB objects or functions, maybe, that could open file and return their...

Hello everyone, I have a question for you: is there a way to programmatically sort messages in Outlook folder by say, date on which messages were sent? I don't seem to find any method to do that. Any help will be greatly appreciated. Thank you.

Hello everyone, I have a couple of questions for you. 1. Can anyone post a small, but accurate piece of code on how one can access Calendar folder using CDO and iterate through its items? 2. Can anyone tell me if there's a way to get Internet Message ID - found in the Internet header - for a...

Hello everyone, I hope somebody could help me with my problem. I need to be able to extract file(s) embedded in Word document or RTF file and displayed as icon, and save it to specified location. This is a general idea. Embedded file(s) could be of diferrent formats: Microsoft Office suite...

Hello everyone, I have a question for you. Does anyone know why text wouldn't wrap in a cell even after "Wrap text" is checked and Format -> Row -> Autofit is applied? Thanks you in advance.

Hello everyone, I have a question for you. Actually, a couple of questions. 1. Is there a way to create a new Outlook data file programmatically? Not a folder in say, Inbox, but like you'd do using File -> New -> Outlook Data File and so on? 2. I have data file with emails' metadata...

Hello everyone, I need your help with error handling. I use On Error GoTo statement before opening workbook. It does catch the first occurrence of error '1004' - Method Open failed, it does go to error handler, but that's it. When next workbooks fails to open, application crashes with Visual...