Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web Macros
Can you make a macro that will go on to the web and retrieve info from certain sites at certain times. Like I want to automatically get turn by turn directions to an address and have it auto imported into excel to be loaded onto a work order to be printed out. Any info would be helpful. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500203 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web Macros
if you create macro when you first download some webdata into excel and
study the macro you can understandand modify to suit you. It will besomething like this the url address and detination can be changed to suit you. With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://in.finance.yahoo.com/p?v&k=pf_2&d=v6", Destination:=Range("A1")) .Name = "p?v&k=pf_2&d=v6" .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .WebSelectionType = xlSpecifiedTables .WebFormatting = xlWebFormattingNone .WebTables = "10" .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .Refresh BackgroundQuery:=False End With "famdamly" wrote in message ... Can you make a macro that will go on to the web and retrieve info from certain sites at certain times. Like I want to automatically get turn by turn directions to an address and have it auto imported into excel to be loaded onto a work order to be printed out. Any info would be helpful. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500203 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web Macros
ref my previous message. I m sorry I did not notice your condition at
certain times. you have to use ontime function. see help Application.OnTime Now + TimeValue("00:00:15"), "my_Procedure" "my procedure" is your sub name "famdamly" wrote in message ... Can you make a macro that will go on to the web and retrieve info from certain sites at certain times. Like I want to automatically get turn by turn directions to an address and have it auto imported into excel to be loaded onto a work order to be printed out. Any info would be helpful. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500203 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web Macros
Thank you for your help. That is awesome. Now I have something more to go on. Atleast I know it can be done. When I record a macro do I go online through a web query or with my browser? Oh well I'll just try both. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500203 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Web Macros
You can try SW
ExplorerAutomation(http://home.comcast.net/~furmana/SWIEAutomation.htm). It allows to create an automation API to any Web applcation. famdamly wrote: Can you make a macro that will go on to the web and retrieve info from certain sites at certain times. Like I want to automatically get turn by turn directions to an address and have it auto imported into excel to be loaded onto a work order to be printed out. Any info would be helpful. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=500203 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Purge macros | Excel Worksheet Functions | |||
Remove macros from spreadsheet | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |