E
Eric
Does anyone have any suggestions on how to create a macro to complete
following tasks?
There is a list of numbers under the spreadsheet Lists on column A, such as
1 in cell A1
3 in cell A2
....
[Creating a spreadsheet under specific name if required]
For the first numer from the list, if there is no spreadsheet named under
"1", then it will automatically create a spreadsheet named "1", which name is
retrieved from the list.
[Generating a query for connection before loading]
I would like to load the text from http://www.question.com/1.html into "1"
spreadsheet, the number 1 is retrieved from the list before inserting the
query 1.html. If the number is 3, the 3 will be inserted into query 3.html,
and all text will be load from http://www.question.com/3.html.
[Next number until the end of the list]
After completing the task for the number 1 in cell A1, then the next task
for the number 3 in cell A2 will be run until the end of list.
Does anyone have any suggestions on how to do it in excel?
Thank anyone very much for any suggestions
Eric
following tasks?
There is a list of numbers under the spreadsheet Lists on column A, such as
1 in cell A1
3 in cell A2
....
[Creating a spreadsheet under specific name if required]
For the first numer from the list, if there is no spreadsheet named under
"1", then it will automatically create a spreadsheet named "1", which name is
retrieved from the list.
[Generating a query for connection before loading]
I would like to load the text from http://www.question.com/1.html into "1"
spreadsheet, the number 1 is retrieved from the list before inserting the
query 1.html. If the number is 3, the 3 will be inserted into query 3.html,
and all text will be load from http://www.question.com/3.html.
[Next number until the end of the list]
After completing the task for the number 1 in cell A1, then the next task
for the number 3 in cell A2 will be run until the end of list.
Does anyone have any suggestions on how to do it in excel?
Thank anyone very much for any suggestions
Eric