Macro Scheduler Forums

Jmac2501

awsome thanks

Jmac2501

I have to make folders out of addresses and want to seperate the address like this: From this - 12345 1st St, Sacramento, CA 95817 to this - 12345 1st St Deleting everything after the ( , ). I have a scrip but its not working. let >y=1 let>address=12345 1st St, Sacramento, CA 95817 label>ADD let y=y...

Jmac2501

how can I schedule a scrip to run at start up?

Jmac2501

yeah thanks I got it working by using month>x day>y let>x=x-1 let>Dialog1.msComboBox1.ItemIndex=%x% let>Dialog1.msComboBox2.ItemIndex=%y% let>Dialog1.msComboBox4.ItemIndex=%x% let>Dialog1.msComboBox5.ItemIndex=%y% let>Dialog1.msComboBox3.ItemIndex=22 let>Dialog1.msComboBox6.ItemIndex=22 it was the l...

Jmac2501

Hey I have a script that I need help on. I want to make the combo boxs defalt to the date. for example msComboBox1 is the month and it always starts at 1, I would like it to change with the date like say its april, I would want it to defalt to 4 instead of 1. is there a way to do that? Thanks Dialog...

Jmac2501

I tried both way with TRUE and True.

Jmac2501

I have written meny scrips like this and have no idea whats wrong with this one. My problem its its not reconizing the checkboxs as being TRUE. Dialog>Dialog1 Caption=Dialog1 Width=189 Height=307 Top=348 Left=276 Label=What Would You Like To Add,16,8 CheckBox=msCheckBox1,Ftest,32,40,97,True CheckBox...

Jmac2501

nm I got it. I used the VK system.

WKD>VK1

Jmac2501

ok what i want to do is have the script wait for a lcl the cont. Is there any way to do that?

wkd> I don't think will work.

Jmac2501

lol, I did a search on counting days, and find Days.

Thanks it works great.

Jmac2501

I need a simple script to tell me how ment days its been from date to date.

exp: from 5/1/08 to 5/6/08, number of days = 6

should be simple enough but its got me stumped...

and help Thanks.

Jesse

Jmac2501

ok i have got it working. here is the script: What i did was took out the xlapp.workbook.add and added SetFocus>Excel* VBSTART Dim xlApp Sub OpenExcel Set XLApp = GetObject(, "Excel.Application") xlApp.visible = true End Sub Sub CloseExcel xlApp.close End SUb Function GetCellX GetCellX = xlApp.Activ...

Jmac2501

No, I get an error. But I was thinking that the part that needs to be changed is this:

Code: Select all

Sub OpenExcel
  Set xlApp = CreateObject("Excel.Application")
  xlApp.Workbooks.add
  xlApp.visible = true
End Sub

Sub CloseExcel
  xlApp.close
End SUb

but i don't know Vb.

Jmac2501

ok so i tested it and it works and does what i want. But how can i change it so that instead of opening a new excel window it just sets focus to the excel window already open?

but thanks for the VB script it was a big help.

Jmac2501

I will try this and see how it goes. Im not to good with VB but ill give it a shot. Thanks will post back.

Search found 76 matches

how to detect a ( , )

run at startup???

Combo box to reflect date

why is this not working???

wait for lcl then cont.

Get how meny days its been.