I have spent a number of hours searching Google to find some information, but never enough to help me pull together all that I looking to accomplish; so I hope someone here will be able to help shed some light. Really I just need a sample script to work from and should be OK, I think.
What I looking to accomplish is to take an Excel spreadsheet which contains columns for a street address, city, state, and zip code along with a various number of rows for each record to capture each cell's content as a variable to be used in a action script and proceed to the next record to perform the same function again. I am having trouble mounting the file .csv file, and a bigger issue on how to script the loop of dynamic variables for each record.
My only programming experience stems from PHP and MySQL, so any help with this VBScript would be greatly appreciated. Thank you!
What I looking to accomplish is to take an Excel spreadsheet which contains columns for a street address, city, state, and zip code along with a various number of rows for each record to capture each cell's content as a variable to be used in a action script and proceed to the next record to perform the same function again. I am having trouble mounting the file .csv file, and a bigger issue on how to script the loop of dynamic variables for each record.
My only programming experience stems from PHP and MySQL, so any help with this VBScript would be greatly appreciated. Thank you!