S
steve09
Using XP and Office 2000.
Trying to automate import of data from www.pcquote.com - some of thei
option chart tables.
What I have so far is after the ***'s below.
Whenever this IQY file is run it opens a new Excel file and inserts th
data in to that file. What I would like is to be able to:
1) Select a specific file to download data in to.
2) Automatically insert a new worksheet in to that file before th
download and rename that worksheet to today's date.
3) Create a single executable/command file that would allow me to ru
this on multiple stocks, eg. run the above for MXIM, QLGC, etc.
Can anyone help or point me in the right direction? Have spent hour
looking at Microsoft site and this forum to no avail. Truly appreciat
any and all help.
***************
WEB
1
http://tinyurl.com/2u74a
Selection=26,27,28,29
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=Fals
Trying to automate import of data from www.pcquote.com - some of thei
option chart tables.
What I have so far is after the ***'s below.
Whenever this IQY file is run it opens a new Excel file and inserts th
data in to that file. What I would like is to be able to:
1) Select a specific file to download data in to.
2) Automatically insert a new worksheet in to that file before th
download and rename that worksheet to today's date.
3) Create a single executable/command file that would allow me to ru
this on multiple stocks, eg. run the above for MXIM, QLGC, etc.
Can anyone help or point me in the right direction? Have spent hour
looking at Microsoft site and this forum to no avail. Truly appreciat
any and all help.
***************
WEB
1
http://tinyurl.com/2u74a
Selection=26,27,28,29
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=Fals