Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I have a macro that calls up the I-series data transfer dialogue…

Customer Question
I have a macro that...
I have a macro that calls up the I-series data transfer dialogue box. when I place the following code into the vba Application.Run "fShowTToDialog" it does not bring up the dialogue box. It works on my laptop but it will not work in the cirtrix environment. Also I cannot get it to automatically press the ok button once the box appears.
Submitted: 3 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 4 hours by:
6/24/2015
Programmer: Russell H., Programmer & Coder replied 3 years ago
Russell H.
Russell H., Programmer & Coder
Category: Programming
Satisfied Customers: 12,963
Experience: Programmer & Coder
Verified
Hi, thank you for contacting JustAnswer.com. My name is Russell. I will do my best to provide the right answer to your question. The difference is, I think, that the Citrix environment is networked, whereas testing it on your laptop is a non-networked environment or context for it to run in.Popping up a dialog box would be a privilege, over the network, that your program (or, your login to the Citrix system, perhaps) does not have. Likewise having it approve/submit itself is probably an operation that requires special privilege in a networked environment. Since I have no further ideas than that, about the subject of your question, I must Opt Out, with apologies. I hope I have given some guidance toward one direction that might be looked into, toward a solution.
Ask Your Own Programming Question
Customer reply replied 3 years ago
That makes sense as to what causes it to stop the process potentially. I can ask for that to be adjusted potentially in the Citrix environment. If I can't it can be ran manually.The second question though was how do I get it to press the ok button in the test environment using a macro. When I have it pop up the dialogue box it then doesn't focus the code onto it. When you tell it to send keys it simply stops the process. When you cancel the dialogue box it the. Performs the actions on the spreadsheet. Any idea what code I would need to put in after it displays the dialogue box to get it to press ok?
Customer reply replied 3 years ago
When I say manually I mean the iseries down load can be ran manually from the menu options at the top of the screen. It just won't work through a macro.
Programmer: Richard, Consultant replied 3 years ago
Richard
Richard, Consultant
Category: Programming
Satisfied Customers: 47,537
Experience: Programming and Network consultancy for 15+ years
Verified
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.
You can either run the send keys statement before the opening of the dialog
Or turn off the dialog with
Application.DisplayAlerts = False prior to the call, and set it back to True after.
If you would like any additional information or assistance, please do not hesitate to let me know.
And if you can take a second to rate my service by clicking one of the stars at the top of the screen and then submit, that would be greatly appreciated.
Thank you
Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Richard Your Own Question
Richard
Richard
Richard, Consultant
Category: Programming
Satisfied Customers: 47,537
47,537 Satisfied Customers
Experience: Programming and Network consultancy for 15+ years

Richard is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I want to import external web data into my Excel (Mac 2011)
I want to import external web data into my Excel (Mac 2011) spreadsheet. There are dozens of tutorials online for PC's and they simply just use the Data-External Data Sources-From Web option. Where is… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am not a programmer. I create macros by performing the actions
I am not a programmer. I create macros by performing the actions I want the macros to perform. I have done a lot of this successfully but I am having a problem doing the following: Using the above met… read more
AAATom
AAATom
Software Engineer
Master\u0027s Degree
42 satisfied customers
John, I would like to create a macro that 1. will go into
John, I would like to create a macro that 1. will go into a sheet name (provided by InputBox) and 2. will search (left to right) a specific row (provided by InputBox) and 3. Will create a list (simila… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Please Help with Excel / VBA / HTMLTextBox. I work with vendor
Please Help with Excel / VBA / HTMLTextBox. I work with vendor pricing that comes to me from a website that I cut and past into an excel 2003 spreadsheet. The problem I have is that all information is… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I create a spreadsheet and email it - all with VBA. It contains
I create a spreadsheet and email it - all with VBA. It contains a ScrollArea definition. When I email it, the ScrollArea definition is lost. How can I place a macro inside the "created" spreadsheet th… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
i would like to conditionally format a trendline in an excel chart based &#
i would like to conditionally format a trendline in an excel chart based on a date. so a date greater than six months is green, a date within 6 mos of a certain date is yellow and a date greater is re… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
Hello; I would like to bring to my Excel worksheet 4 different picture
Hello; I would like to bring to my Excel worksheet 4 different pictures, depends on the results of another input that will be on cell B2 in that worksheet. If this cell has "1" picture #1 will be show… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have a question about using forms created in the VB Editor
I have a question about using forms created in the VB Editor within a VBA macro launched from Excel. Basically, I'm pretty good with VBA. I've used simple application.inputbox windows to collect infor… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need some data validation code for VBA 2007. For Cells Range
I need some data validation code for VBA 2007. For Cells Range (O2:O20) restrict user choices to (REL,N/A, X or "") where "" means cleared cell or no data.… read more
Raj
Raj
SAP ABAP Consultant
Master\u0027s Degree
27 satisfied customers
John, Got one I am not sure if it is possible (sure it will
John, Got one I am not sure if it is possible (sure it will take some work). I want to insert a "logo" (bitmap file) base on a TRUE/FALSE condition. This is basically a color logo and a black/white lo… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have an excel spreadsheet with a textbox on first row. I
I have an excel spreadsheet with a textbox on first row. I also have some vba code within the sheet1 that call for autofilter function as soon as textbox change. I want to create a addin that automati… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
In Microsoft Excel I have used the Visual Basic editor (accessed
In Microsoft Excel I have used the Visual Basic editor (accessed via the "Macro" item in the Tools menu) to create a couple of functions. They both compile without indication of errors. But when I ref… read more
ehabtutor
ehabtutor
Computer Software Engineer
Bachelor's Degree
936 satisfied customers
I have transcripts in Excel with each comment being a unique
I have transcripts in Excel with each comment being a unique record. Can I search the worksheet for a specific word and have excel automatically copy all the cells that contain that particular word in… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hi. I m new to VBA in Excel 2007 and been given an assigment
Hi. I´m new to VBA in Excel 2007 and been given an assigment where I´m to make an userform where we can insert Surname, Last Name, Date og birth, Adress, Zipcode, City and Team number into a worksheet… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I get compile error only comments may appear after end sub&
I get "compile error only comments may appear after end sub" in the following code: when I try to paste the code here i run out of room can anyone help?… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Okay--thats fine, I also have a few other questions, about
Okay--that's fine, I also have a few other questions, about VBA code and Macros in Excel...if I am wanting to learn the basic method of writing code for a Macro, what is the best way for me to learn t… read more
Cherryl Lewis
Cherryl Lewis
Bachelor's Degree
180 satisfied customers
I have the following code as a Macro within Excel. Sub Sow5()
I have the following code as a Macro within Excel. Sub Sow5() ' ' Sow5 Macro ' Macro recorded 6/2/2009 by Thomas F. Schield ' Sheets("SOWs").Select Application.Run "Show_Toolbar" Application.Goto Refe… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Request for Tony M EXCEL QUESTION This is a follow up to
Request for Tony M EXCEL QUESTION This is a follow up to a previous question regarding addition of cells in excel as follows: I want to add cells in an excel sheet. For example, each cell has contents… read more
Tony M
Tony M
Sr. Application Developer
Bachelor's Degree
54 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x