Search results for query: *

Hi All, I've hit a bit of a roadblock as there are Text files that reside on a SharePoint drive that I initially was trying to download using the method below Set req = CreateObject("Msxml2.XMLHttp.6.0") req.open "GET", url, False req.send Problem is there is security that is preventing this...

Thanks combo, I tooled around and am just doing a Access.run "procedure" and putting the openform inside the Access procedure, seems to work but I'll be finding a use for your suggestion later on as well. Thanks!

Thanks Mark, the .Close prompted an error for me but .Quit seemed to work. I'm just having trouble with the form commands, meaning getting a specific form to open and close. Mainly trying Access.OpenForm "Formname" and DoCmd.OpenForm. Any thoughts on that bit? ThankS!

Hi everyone, I've managed to run the access application I want from vbscript but am having a little trouble with the next steps. I'd like to close a form (if it's open) and re-open it from an external vbscript. Is this possible? Many thanks!

Hi all, I'm facing an issue with trying to copy an RTF string to the clipboard, I've seen examples in VBA but not in VBScript. I want to avoid creating a word object to copy this string, this is just an example string from a vba example I saw Dim sRTF sRTF =...

Thanks for the response guys, yeah the yellow isn't that quite intense, I see what you're saying though! I did actually dive into the windows themes to see if that would be a viable option and things like high intensity black does change the font, the only problem is that it disables the...

Thanks for the response! Yeah I'm not sure, there's no looping being done and I do release the word objects at the end of execution so it's a bit bizarre. I implemented calling the code from a vbs as a work around and that seemed to work :S

Hi all, I have an unusual situation with a user, there is a word template that gets populated from a web application and that template has some font that is yellow. It's preferred that this font stays yellow for most users but one user cannot see the font because of some eyesight issues. The...

Hi all, One user has been experiencing this error that isn't recreatable by other users or myself and happens pretty frequently with them. It's happening in an Access Function where I pop-up a word document and automate some bookmarks within it. That error pops up and references this line...

Hi guitarzan, thanks for replying. That's actually the first thing the script is doing so it's tripping right at the start, it's being executed through the PCOMM environment as a .mac file, written in vbscript. I might be able to generate a better worded error if I have the user run the script...

There's a strange error occurring but it's only happening to some users and not others. They're all running the same OS and same lotus notes version. It's prompting an error on this line Set notesuiworkspace = CreateObject("Notes.Notesuiworkspace") The only thing the error says is: Error...

Hi everyone, I've scoured the net and didn't find something to work in VBScript for this. I basically want to set the affinity of a current process, e.g. if they are all selected, to only select 1. I found this code for setting the priority which is in the same area as the affinity so I was...

Beautiful, works like a charm as always, thanks again!

Yeah, sorry Guitarzan, I just had a bit of trouble applying it to the area I was trying to apply it for! I'll give it a try again and see if I can work out the kinks. Thanks for your help, again!

Sorry Guitarzan, missed your post. I have something like this going at the moment IF i2C = 6 THEN s1C = s1C & "<TR><TD>TEXT GOES HERE</TD><TR>" END IF So basically it's just slotting in this text once it gets to button 6, I'm just looking to customize the font of the "TEXT GOES HERE"...

Thanks Geates! Managed to have it work decently, not sure if it's possible to change the font and font size of the "insert text here" in the same spot? My knowledge is very limited as I've leveraged this code from elsewhere. Also, not a huge deal but when I try and center the "insert text...

Hey, I was just wondering if anybody knew how to add text in between a row of buttons? I've tried things and haven't been successful as of yet :( basically what I'm trying to achieve is button 1 button 2 button 3 Set of text here button 1 button 2 button 3 button 1 button 2 button 3 Set of...

Thanks for the reply guys. Jges, unfortunately I was looking to utilize a script so I could run it automatically on someone else's PC so downloading a program isn't the most feasible. Thanks

Hi all, I have pilfered through a lot of posts but can't seem to combine exactly what I'm trying to do. I have a bit of code here but basically, instead of the .txt files I want it to cycle through every file in each folder and match them against each other. If the file doesn't exist in the...

I have been invoking this vbscript from another vbscript using the following Set WSHShell = CreateObject("WScript.Shell") WSHShell.Run "wscript " & strFileName, 1, True (Tried the value as 0 as well but same result as below, and the msgbox that returns the value inside the msgbox script also...