Hi All, wondering if anyone has come across a way to manually trigger an "onClick" event associated with a button within a page? At the moment, the only way for my to get it working with the web recorder is to have the mouse hover over a button on a page which then shows the "download" button. This ...

Hi All, It's been a while since I've posted here, but was wondering if anyone had any tricks on manipulating whole columns of data at once, more specifically, if there was any way to copy a whole column from one document to another. In my example, I'm opening 4 Excel documents and combining them int...

Hey Hagchr,

sorry for the delayed response back to you.

I've given both of these solutions a go, combining a couple of ideas, and it's working really well! Thanks so much!

Dominic Fichera

Hey all, I'm trying to add a "password protected" tab to my page control. Essentially, I want the tab to prompt users to enter a password, and if it's wrong, bounce them back to another tab. So far, I've got a sub routine that's triggered when the tab is shown (onShow), and it prompts users to enter...

All good JRL I got the general idea with your explanation and have already modified my script accordingly.

That's perfect! Thanks JRL!

Still think it's a bit odd you can't clear the dropdown without resetting the list, but very glad it can be done at all. That makes life much easier!

Thanks again,

Dominic Fichera

Hey guys, Does anyone have a suggestion for how to clear a ComboBox when the Style=csDropDownList? I've tried: 1) The regular: SetDialogProperty>Dialog,ComboBox,Text, 2) Setting one of the "ListText" values as a space (" ") and then SetDialogProperty>Dialog,ComboBox,Text, 3) SetDialogProperty>Dialog...

Answered my own question after a bit more playing around.

Set the page index where 0=first position and 1=second position etc.

Thank everyone

Dominic Fichera

Hey guys, Wondering if it's possible to change the order of the tabs in Page Control? For example, I've currently got it going Tab 1, tab 2, tab 3, but would like for tab 3 to be the first tab. I've had a play around with some of the options, but it hasn't been able to change the order. Thanks for t...

Very slack of me! I answered my own question with some Googling.

FYI for anyone re-reading this post, it goes the line before the code that causes the error:
Thanks,

Dominic Fichera

Hey hagchr, Where would I put that in the grand scheme of things: VBSTART Dim xlApp Dim xlBook Sub GetXL Set xlApp = GetObject("FILEPATH").Application Set xlBook = xlApp.ActiveWorkbook End Sub Function FindCell(Sheet,Data) Dim theCell Dim xlValues xlValues = -4163 Dim xlSheet Set xlSheet = xlBook.Wo...

Hey guys, I have a script I'm running which will search Excel for specific data. If it can't find that data (which is a valid option) the script presents an error to the users. I know where the errors are caused, but not how to stop them. Since I am working with users who are likely to "freak out" (...

hagchr wrote:Hi, It seems to work if you use the full path.

Code: Select all

xlApp = GetObject("C:\Users\...\Book1.xlsx").Application

That works perfectly, hagchr! Thanks!

Hey all, I'm working on a script which essentially opens an excel document in the background, searches for a cell and returns the co-ords. I've based my script off the one Marcus posted here https://www.mjtnet.com/blog/2010/12/15/mixing-the-native-excel-functions-with-vbscript/ , but with one key ch...

Hey Marcus,

Hmm... Interesting. Must be another flaw with the Live website in IE11 vs Macro Scheduler Everything worked better before we upgraded from IE8

I will keep playing around and see how I go. Any chance of Chrome integration anytime in the future?

Thank you,

Dominic