Search results for query: *

I have to pass 71 variables to an ASP page. I am using a shell command to send the URL. I need to know how the Task ID is passed back from the shell command so that I can close the IE window without closing any other instances of IE that may be running. Is this possibile in Excel? ...Going...

Hmmm Not sure If the Cells property will work here but it doesn't give me a compile error.... Sub MyQuery() a = 0 On Error Resume Next Cells(2, 1).QueryTable.Refresh BackgroundQuery:=False a = Err.Number If a > 0 Then MyQuery End If End Sub That's the best I can do without the exact error...

Bah! I want to edit after posting.... I resolved it by moving all of the code into the UserForm, but I would still like to know what is happening since I have another project that will pass data from a form into various cells in several sheets.

Not much in that thread I didn't try first. After some playing around I discoverd something more confusing. Instead of recording the click I made a Global variable again. If declared in either the Form or the Sheet, the data would not pass. Declared in both, the data would pass but it was...

Hmmm not my area, but... If you can move the query into a macro, you could pass the error into a variable then check if the error has changed or is Null before moving on to the next query. If you know the error # that is generated by the failure you could change the IF statement to check for...

This should be a best practice but in my experience it's not... Create alternate scenarios for people that need extra practice. and make any hands on simulation as close to reality as possibile. If you are CBTing a web based tool, make sure keyboard commands as well as mouse clicks are captured...

I keep extensive records. I had a class that had a 75% failure rate out of 30 ppl. When I showed my boss the missed days and tardies that were accumulated as well as the documentated corrective actions compared side by side to the final exam scores. Her tone changed to sympathetic and she...

Call center here.... 1. I want an application like NetSupport School on the training systems to push presentations and live demos to my class while locking them out from browing the web and allowing me to take control of thier system instead of squeezing inbetween people to show someone how do...

Class control. How they deal with irrelevant questions. Thier presence(mobility, diction,annunciation). How they explain questions. Encouraging participation. Materials they prepared. - Easy to read and see were handouts prepared? We also have classroom policies that we see if they address...

Info on the Speech SDK: http://www.microsoft.com/windowsxp/using/setup/expert/moskowitz_02september23.mspx

Is the dropdown in the sheet, a Userform, or in Data Validation? Will the Chart be placed as an object in the same sheet or as a new Sheet?

Well, The not so pretty way would be to copy the button over. Then, launch the VB editor and copy all of the code from one sheet to the destination sheet. You might have to tweak the Userform so it sees the code in the new sheet but it should work. The other method would be to place the code in...

You could pass the File name to a variable. Then make the dialog box = the variable. You need to have TextBox1 somewhere on the form. I created a "browse" button and attached this sub to the button click event. This lets you capture the file name for use later in your application. After this you...

I am having trouble passing a variable between a Userform and Code contained within a sheet. I have built a workbook that is used by our training department for gathering and storing all data relevent to a class(attendance, scoring, Logins,etc.) One of the things I am doing is pulling data from...