Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Hello All, hope somebody could h
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 All, hope somebody could h
Hello mikrom, in your experience, will Python have all necessary for this task modules/libraries? -
Hello All, hope somebody could h
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 All, hope somebody could h
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? -
Hello All, hope somebody could h
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 All, hope somebody could h
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 h
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 -
How to get rid of Acrobat print dialog when batch printing PDF files?
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...- sglab
- Thread
- Replies: 0
- Forum: Adobe: Acrobat
-
Using method saveAs of JSObject
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...- sglab
- Thread
- Replies: 0
- Forum: Javascript
-
Using JSObject saveAs method with VBA
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...- sglab
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using JSObject saveAs method with VBA
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...- sglab
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Calendar items don't show up in Calendar and don't have start and end dates
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...- sglab
- Post #6
- Forum: Microsoft: Office
-
Calendar items don't show up in Calendar and don't have start and end dates
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...- sglab
- Post #4
- Forum: Microsoft: Office
-
Calendar items don't show up in Calendar and don't have start and end dates
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...- sglab
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Instr function can't find a character
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.- sglab
- Post #13
- Forum: Visual Basic (Classic)
-
Instr function can't find a character
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...- sglab
- Post #12
- Forum: Visual Basic (Classic)
-
Instr function can't find a character
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...- sglab
- Post #9
- Forum: Visual Basic (Classic)
-
Instr function can't find a character
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. -
Instr function can't find a character
Hello jges, thank you for the idea. I'll definitely try this approach. Best regards. -
Instr function can't find a character
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...- sglab
- Post #7
- Forum: Visual Basic (Classic)
