One way might be to set msched.exe to "Hide Icon and Notifications" in your Notification Area Icons in control panel.
That will of course not allow you to right click on it anymore.

Oh sure! I've found so many useful things in these forums, it's a gold mine!! I'm happy to add to that in any way.
Still not sure if leaving a macro to loop all day long has any long term negative effects, but so far so good.

Good news, I found a way reading every thread on this board, I found something that wasn't an answer, but lead me to the answer. I was using Show>Dialog1, The comma making a hard stop and yes, leaving the dialog window open to interact with, but also locking me to nothing else. So, I removed the com...

I have a Dialog script that gets much of it's info from an excel export .xls Throughout the day there can be new xls to import and I have to close the Dialog and reopen to load the new xls sheet into the dialog. I'm looking to make a button on the Dialog that will close it and start the script over ...

OMG I love you!!!

Thank you!

Am I missing something? The button is blank with this code. I've tried not using % The Array is loading as 0: ARRAY_2_1=36512 shows up in the watch list So 36512 should be in the caption box object WOButton1: tMSButton Left = 61 Top = 61 Width = 75 Height = 25 Caption = '' TabOrder = 0 DoBrowse = Fa...

The caption is what I'm attempting to change with variables. Is that also set in stone?

I've loaded XLSheetToArray and the Watch list shows that it's imported "0: ARRAY_10_1=36412" I'm trying to create a dialog button that can use variables as names. Every day the macro runs new, it will load the xls sheet to the array (new excel sheet every day) The excel sheet can have anywhere from ...

I have a spreadsheet with 30 rows of data, the data in column 7 will either have a 1 or an 8 to indicate a person.. The number of 1s and 8s is different every time. Can MS look at that column and determine how many 1s and how many 8s and return that number as a variable? I was thinking something alo...

What's more.. if you do =TEXT(J9,"1900")
it turns a two digit year into a four digit year!!

Thanks a lot!

Thank you both! Marcus, I'm sorry I didn't understand that that little formula would do what I wanted the first time you posted it!

Thanks again!

Sorry, maybe I wasn't clear. The excel sheet already exists (it's a report that gets run every day with very limited options) and it's filled with numbers.. So I switch the format of the columns to text and add a zero to any 1-9's because I need two digit numbers I don't feel like going through a co...

Correct, either way an keep excel from removing the zero..
I've changed the formatting of the columns to text, and now need to add a zero to the single digit numbers.

Can MS look at an excel cell and determine if the cell has a one digit number or a two digit number? If it does have only one digit number, then add a zero? So, if it's 1-9, then add a zero to the front of the number to make it 01-09? And I'll have a column of numbers that will differ in amount each...

oh my god it works!!!
Thanks so much for your help!
now I just need to figure out how to get it to do 10 in a row.
I think it has to do with the r=1 then r=1+1..
I'm not sure how that works yet.. or if you can use it to count down the rows in a spreadsheet, we'll see..

Thanks again