sunilvedula

thanks for your reply. i tried exactly what you said. i estimated my regular area where my data would lie and took approximation of in and around that area which i know it will highlight. so i told my macro to move around the estimated area and look for the highlighted pixel color and then move few points beside and copy the data. this is working fine but my doubt is if i need to look for some thing else which area i am unaware then how do i do? by doing ctrl f (find) if it find how do i my mouse to that area. Any other faster way or anything else?

Hi All, I am finding a text in an screen through the macro express by making it do ctrl F and the item gets hightlighted. Now i want my mouse to move to that highlighted item. Is it possible? Neither tab nor arrow keys work on this screen.

i read it and i downloaded it but did not use it. Once i use it i will let you know. I have tried using the shutdown option available in ME but it did not work

Hi Paul, I used the code you suggested. It does not get executed when i lock the system. i.e system does not get shutdown. any ideas????

Hi Terry, Sorry forgot to mention abt that. It is not the sheet that is protected but the entire workbook is protected with a password. It means when i try to open the file "Test" it opens and the first window that is visible is password window. Here i am unable to type the password. If i record the macro as u suggested i was able to type but when i try to code it in scripting editor it does not work. IF you would like to have a view at my code let me know. I will paste it.

Shutdown Schdule this macro: CODE Write Registry Value "%T[1]%" into HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\AutoAdminLogon -- T1 contains 1 Write Registry Value "%T[99]%" into HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\DefaultPassword -- T99 contains your login password Program Launch: "shutdown.exe" (Normal) Parameters: -s reboot -f -l 1 Once rebooted, schedule this macro to run on startup: CODE Write Registry Value "%T[1]%" into HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\AutoAdminLogon -- T1 contains 0 Delete Registry Value: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\DefaultPassword i am a bit confused to say. What i understand with this code is it copies the passwd, reboots the system and then relogin without passwd by deleting it. runs the macro and then locks the system. Am i right? second thing is once it relogs in will it excute all the commands as it would like when we run it normally? Once the macro completes its work would it then close? If so can yu send me the detailed code for locking the system after the macro runs. Whatever code i see above is to reboot the system without password. Please help me understand.

Probably you are right kevin. i have tried to open an excel document that has been protected with a password and it does not allow. But when i recorded the macro it could do it though i dont like recording. i am comfortable with scripting. that raised some questions that if when i record a macro it is able to type the password then i should be able to do it even through scripting editor. let me know your thoughts. second question is we lock our systems whenever we are not at our system(ctrl+alt+del). all our computers are network based. my questin ws can we run macros when the system is locked. i have been able to open programs but unable to type anything when the system was locked. for eg i was able to open a notepad but unable to type anything in it and also unable to save it. Any advice pls. this becomes important because we want to load data from an application onto a database designed in access even before uses login in their shifts. we are trying to schedule a macro every morning at 6am so that it runs and loads all the data from the application to the database and makes it ready for all the use when they login. all this work macro express does it and i have written the program. But we would like it to work when the system is locked as none of us are available at that time. else some one else has to cme and unlock the system to run the macro which is not ht best alternative solution. Any suggestions ?

Hi All, Can macros type the password for an excel password protected Document? Also is it possible to run macros when windows is locked?

Can u give me ur email address so that i can be in touch with and also ur gmail or yahoo messenger id

I owe more than a cookie and i will never ever say to anyone that nothing cannot be done. Lesson learnt and i am ever grateful to you. should you have any help that i can do will do without hesitating. I am fan of your from today. Thanks a lot lot....lot ....lot cant say how much..........

Maybe i will check as suggested but i have no clue how to go about it. Havent ever come across such a request. You are right abt understanding the requirment that they will want to build their own structure.

Hi All, I have a strange request from one of my department members. They want me to create a macro which would be used by anyone irrespective of the department or anything. What I understand is they want a macro which will prompt the user to input the variable and it will create the multiple choices menu or boxes based on the input and create a macro based on the input received. I am trying to be clear. Let me give an example. When we start this macro it should prompt like: “How many boxes do you need in the first screen?”. If user gives 5 it should take the input and be able to create 5 boxes or multiple choice menu and then should prompt for the text for those 5 boxes and those should become the headings for those. It goes on creating like that until click cancel. Now the macro should save the macro with the inputs and that should become a new macro which can be used by others. The idea is if we create a sample macro like this it will not require us to create macros for every other department but just pass on this sample file and every department people based on their requirement will create from this file and start using the new created macro file. I know this a strange request (at least for me) and if anyone has any ideas please suggest and also if this is possible or not.

thank you for your response. should work for me too. will try and let you know

Hi Kevin, Thank you for providing me with a list of options. Thanks a ton. The second option should work for me. will check and confirm the same. One quick question. How do we convert macro into playable one? Can you elobarate on that please. Because i have written the macro with activation of a title window. If you can let me know how to convert into playable one then i can trigger it with click of a button.

HI all, i want to trigger macro express when a key is pressed in ms-access database. i have developed a database in ms- access which multiple users use. Now when they complete a work they need to send an email to business are confirming the job is done with a formatted excel sheet to which a reply is sought from the business area who will attach some images and send it back to us. With access i am able to send mail but cannot format the excel sheet the way i want. i have designed a macro to do the desing part so that it goes to the mail and pastes the data in exce in rich text format so that the business are people can drop images beside the data and send it back to us. to make this possible i should be able to trigger the macro express but that i find it difficult. i can try opening the macro file with sql code but how do i make it trigger? can macro express self trigger once the file is opened? any ideas please put forward as i need to submit my presentation ASAP. BTW I USE MACRO EXPRESS 3.2

HI all, i want to trigger macro express when a key is pressed in ms-access database. i have developed a database in ms- access which multiple users use. Now when they complete a work they need to send an email to business are confirming the job is done with a formatted excel sheet to which a reply is sought from the business area who will attach some images and send it back to us. With access i am able to send mail but cannot format the excel sheet the way i want. i have designed a macro to do the desing part so that it goes to the mail and pastes the data in exce in rich text format so that the business are people can drop images beside the data and send it back to us. to make this possible i should be able to trigger the macro express but that i find it difficult. i can try opening the macro file with sql code but how do i make it trigger? can macro express self trigger once the file is opened? any ideas please put forward as i need to submit my presentation ASAP. BTW I USE MACRO EXPRESS 3.2

Hi All, I have a scheduled macro which needs to be run when windows is locked "ctrl+alt+del". It is required to run before everyone logins so that they can have the data ready. I have schedule the macro at 8.00am every morning. It opens the executable file of a program and then needs to type the username and password and then do a series of steps before it downloads the report. Now when i try this it works only till opening the application and is unable to type the username or password. Can anyone help me in this regard. I did have a look at the topics already posted but could not find a right answer.

will try and let you know if it helped me or not!!

Hi All, As mentioned above in the subj line i want my pop up window which macro express generates to be active and disable any other window which is open on the desktop. which means even if the user clicks elsewhere when the pop up is there nothing should happend and action should be performed only when the use clicks on the popup. Is this possible? The reason is the macro i made for one of our process ensures tht people work according to the flow of macro but when it pauses for an option to be keyed by the user they can put aside the macro and do other work in the windows which is not acceptable. We would like to avoid it.

hi kevin, i purchased it from amazon.com. It clearly said that with purchase of the book one licensce was free and hence the question i asked.

hi all, i recently purchased macro express explained book from amazon and accompanying cd for 49+shipping. they told me that one licensce was free. now i dont the find the licensce code anywhere. Neither in the book or the cd. If any one can help me out with this issue it will be of great help.

Also is it possible to call a excel macro in the macro express which we create . Is it possible if so how do i do that?

Just a doubt! do we need to specify the location where our macro is loacted along with meproc location. Or is it sufficent if i give the location of my macro. Because when i specified the location of my macro it did not respond. It gave an error. pls suggest

Thanks for all those suggestions. we will try to stick by them

HI all, just wanted to know if we can activated a macro from a command button from an excel sheet. what i want is when the user clicks the submit button my macro with name "scores macro" needs to get activated. is it possible if so how do i do that?? Also i am not so knowledgable in exccel