Search results for query: *

The $Include works on my system. I can make work with very simple commands such as msgbox pop-ups. So the problem is in the code. I'm not familiar with header files at all. In fact this is the first time I have heard of such a thing so please forgive me. I'm sure the problem is with the...

I think the problem afortuna is running into is the macros are too long. I don't think declaring the subroutines inside the "Main" macro will work in this case. He, and I have been trying to get the $Include statement to work, but to no avail.

This works, my other post does not. NL$ = Chr$(10) EndMsgtext$ = String1 & NL & String2 & NL & String3 MsgBox EndMsgtext http://www.tek-tips.com/viewthread.cfm?qid=1474038

Msgbox ("This is Line #1" & vbNewLine & "This is Line #2" & vbNewLine & vbNewLine & "There are two lines above this one")

dim MyDate as Date, throws an error.

Report Date 12 month or More 6 month 5 month 4 to 5 month 10 day / 235 A January 1, 2014 1/1/00 to 12/31/12 01/01/13 to 6/30/13 07/01/13 to 07/31/13 7/01/13 to 8/31/13 1/1/00 to 12/31/13 February 1, 2014 1/1/00 to 1/31/13 02/01/13 to 07/31/13...

Report Date 12 month or More 6 month 5 month 4 to 5 month 10 day / 235 A January 1, 2014 1/1/00 to 12/31/12 01/01/13 to 6/30/13 07/01/13 to 07/31/13 7/01/13 to 8/31/13 1/1/00 to 12/31/13 February 1, 2014 1/1/00 to 1/31/13 02/01/13 to...

so if i run the report on Jan 1, 2014, i want the begin date of 010100 (jan 1 2000) which is hard coded and the end date for jan 1 would be 123113. And so on for each month. I also have many reports that will use different date ranges (not always 010100 as start date), so maybe going from the...

The January 1, 2014 is the "As of" date. The end date of the report is the 123113.

I know, i've looked around a bit and I'm not sure how to grab a substing. Maybe there's an easier way to do what i want. I probably could use a little guidance. I made the combobox, but I wasnt sure the best way to translate their selection to the 6 digit date, ie. "January 1, 2014...

I'm going to try that with a few upgrades now, Remy988. That is an excellent suggestion.

Do I have to create my own dialog box to use the cancel button?

How do I program the Cancel button on an input box to stop the macro that the input box is a part of. Below I have two input boxes, and I'd like the macro to stop anytime the cancel buttin is pressed. sess0.screen.moveto 21,3 sess0.screen.sendkeys("<Tab>audme") msgtext = "Input...

I owe you a beer Remy, tanks for all you help. is there a reference to the methods properties and whatnot attachmate uses? It's hard to find anything.

Remy, I see what you were sayin'. Thanks again. And i DO like the "cancel" button. I want the selection that I choose from the dropdown box to get pasted to a coordinate on the screen, rather that showing in a dialog box. The goal is for the name that is chosen from the list, the OK button...

Remy, thanks for the suggestion, the button has been added. How does one get the text associated with the combobox selection to be pasted to the active session. Once the user clicks the button, I'd like the name to get pasted to the session. I can't find anything. And also, is this the only...

Hey, it's youre newest noob here again! I made a combobox for a macro that I am making, but I have a quick question. I found some code that helped me with this one, but I'm not sure how to pass the selected value in the combo box to the quickpad, then to a field in the session once the "OK"...

Man, both those worked, thanks Skip and Remy.

I'd use excel VBA, but I don't really know how to interact with it.

no, with the numeric value, still throwing an error.