Search results for query: *

Hello microm, that is more that I could hope for. Thank you very much!!! I will study the code and try to use it, or parts of it, in our environment Best regards

Hello mikrom, in your experience, will Python have all necessary for this task modules/libraries?

Hello microm, your breakdown of what I described previously looks much more organized. The problem with installing any of the utilities you mentioned is not allowed in our environment. We do have the bash script that comes with the data and which does all of it, but to run it we have to use...

Hello microm, thank you for pointing this out and sorry, if my question upset anyone. I know that VBA and VBScript are not the same. I wouldn't mind if you or anyone else could come up with something in VBScript to address my question. Isn't the task at least a bit interesting?

Well, this is pretty much what I am doing here. My task a bit more complex than I originally stated, and I am trying to piece together snippets from different scripts I find. We actually receive a ZIP file and a txt file with a password. ZIP extracts a bunch of folders and one of them has a csv...

Hello Rick998, thank you for your reply. It's really helpful. PowerShell is something I haven't touched before - maybe it's time I did - and Excel is right there and it speaks human language. Anyways, I will look into utilizing PowerShell Have a great day

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

Hello SkipVought, thank you for your reply. I will definitely post this question to javascript forum, too. Just thought that since this JSObject is what they call a "bridge" to Adobe Javascript, someone has had some experience with invoking this very method from VBA. I mean, I've done some...

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

Thank you, SkipVought for explanation on this date representation concept. Right or wrong, but these 1899 dates are actually like flags for me when I analyze extracted data. What I was more interested in - because we have to give our client some sort of explanation - is how could there be...

Hello SkipVought and mintjulep, I knew there would be some confusion to what I described. Let me try to explain myself: 1. We have extracted data from PST files that do have Calendars along with regular mail items; 2. I don't know what "unnamed source" means exactly; 3. When we process PST...

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

xwb, thank you for pointing that out - duly noted - but even with CStr(Chr(n)) Instr wouldn't return a position of the character I was looking for. Best regards.

Hello dilettante (?), thank you for your input, too. I mean, this whole conversation in this topic has been a valuable lesson for me. So, you're saying that conversion to ANSI occurs when one uses Asc to determine the code for the character, right? Instead, one should use AscW, right? Best...

judgeh59, I used something like below: for i = 1 to len(fName) debug.print Asc(Mid(fName,i,1)) next So, at position numbers 3 and 6 it would print "47" (see the string in my initial post) At the same time Instr(1,fName,chr(47)) returns 0 Anyway, thanks to one of the other Forum's members...

Hello jges, I tried your approach and it did work just perfect. Thank you so much and good luck. I also wanted to thank everyone for their input as they showed me different ways of looking at the data I'm working with. Best regards.

Hello jges, thank you for the idea. I'll definitely try this approach. Best regards.

Sorry for not answering sooner - was working on a rush project. Thank you all for your replies. Chris, this is the reason I went here with my question. Neither Instr nor Replace can pick up this character "?". It's not "/". When I go by character, I get its ASCII code as 47, but when I use...