[Talk] FW: question

[Seely, Jay]

Title: question

Can someone help me with the question below. Also how would I write the following if I wanted to transform D("4") into the day before.   The information within the spreadsheet is not in a date format. But when I try to declare it as date within the script I get errors. Where can you declare these items globally and not within the action or  procedure itself..   Dim D("4") AS DATE   TERMDT = D("4") Enter TERMDT - 1         Jay Seely University of Fl Jacksonville Phy,Inc Managed Care Systems Analyst 1833 Boulevard / 6th floor Jacksonville, Fl 32206 P-904-244-1834 F-904-244-1932 Confidentiality Notice:  This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -----Original Message----- From: Seely, Jay Sent: Monday, April 24, 06 10:43 AM To: '[EMAIL PROTECTED]' Subject: RE: question Shawn, I'm making good progress due to your help.   Sub Edit_Action(Optional dummy_ As String) dt = InputBox("Enter dt, ex 040106") D.Open_ "\\Ufjp1\ARO\comm" & dt & ".xls", ftExcel End Sub My spreadsheet name will depend on the dt I place in the Inputbox, but how would I write instructions to tell it to write directly back to that spreadsheet.  I see how to do within the datastation pull down menu, but I will not be working with the same file each time I run this.       Jay Seely University of Fl Jacksonville Phy,Inc Managed Care Systems Analyst 1833 Boulevard / 6th floor Jacksonville, Fl 32206 P-904-244-1834 F-904-244-1932 Confidentiality Notice:  This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -----Original Message----- From: Shawn M. Yeaton [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 06 2:44 PM To: Seely, Jay Subject: RE: question You're going about it the right way, you just can't edit THAT code directly.  You need to make the change by selecting Edit Action. Shawn M. Yeaton Boston Software Systems (866) 653-5105 x805   www.bostonworkstation.com   From: Seely, Jay [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 2:26 PM To: [EMAIL PROTECTED] Subject: RE: question        ElseIf Step = "SELECT PATIENT" Then         If Rule("Patient:@4,1&@65442#65513,-999745#999905") Then             Enter "J"             Exit Sub Shawn,  I trying to set up a script that adds call information to the patients comments screen.  One of my difficulties is that each patient is different in where the cursor falls due to the size of their comment file and the numbers of screens that I have to move thru to get to the comment screen.  I working in IDXPowerTerm. How can I write a range that a cursor may fall into. I get stuck when writing like above....   Jay Seely University of Fl Jacksonville Phy,Inc Managed Care Systems Analyst 1833 Boulevard / 6th floor Jacksonville, Fl 32206 P-904-244-1834 F-904-244-1932 Confidentiality Notice:  This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -----Original Message----- From: Shawn M. Yeaton [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 06 2:01 PM To: Seely, Jay Subject: RE: question Hi Jay,   It sounds like you may not be editing the actions properly.  You shouldn't be editing any code unless it's in the edit action routine.  Feel free to give me a call if you'd like to review. Shawn M. Yeaton Boston Software Systems (866) 653-5105 x805   www.bostonworkstation.com   From: Seely, Jay [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 12:01 PM To: [EMAIL PROTECTED] Subject: question   After making changes directly within the visual basic editor, the changes do not stay within the rules even when I save project. I come back in to the script and my changes are not there.  Any ideas as to what I may not be doing correctly... Jay Seely University of Fl Jacksonville Phy,Inc Managed Care Systems Analyst 1833 Boulevard / 6th floor Jacksonville, Fl 32206 P-904-244-1834 F-904-244-1932 Confidentiality Notice:  This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.