kmaster1

Thanks guys for your valuable input and offers. I will do as you suggested and try to train this 2 hours a week. I think then I will start to see real results soon. And Cory you will get a Pm from me. I could use some real support in this.

Thanks again,

K

I want to improve in using macro express. In your opinion where can I find the best places to do this. Are there any other books besides the macroexpress explained book and are there any other video tutorials or super forum discussions that I can use as a general reference. I work with the internet so I am very interested entering data to web sites and most importantly error checking for online data entry. I know how to put the data in, but there is not much with error checking.

Basically I am looking for the best resource spot I can use to learn macroexpress.

Thanks,

k

Hi there are some programs that I need to run as administrator. This is a command in vista. Just right click on any icon and you can run as admin.

How would I get macxpress to do that?

The ASCII File Begin Process command will do this for you. It reads the first line of the .csv file and saves each record (cell) to individual text string variables. You can then have the macro enter each variable into the appropriate field on the form and save it. After these steps insert the ASCII File End Process command.

 

The macro starts over again with the second line of the .csv file, repeating the steps. When finished it starts with line 3 and so on until every line in the file has been processed.

Okay, but now the problem. The macro needs to start over again. HOW! And I want this to be done in 1 macro that is the confusing part.

Do I use a repeat, but then how to tell when it is finished? Please help

Okay. I have an online school and I want to enroll all my students. So I have to fill out a web form for each student. About 15 pieces of info per student. This will take a long time for 150 students. So I want a macro that will open a .csv file and count the number of rows in my excel file, then repeat filling out the form that many times.

I know I need the ASCII Begin and End which will go to the next row, but the problem is I need it to pull the information out, then fill out the form, save the form, then start all over. What can I do?