| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help on load the web link into Excel?
Does anyone have any suggestions on loading the web link into Excel?
Following codes is working before, recently when I run the macro, it can open the wb.Sheets("Industry Indexes"), but fails to copy into Sheets("Temp") and close it. Does anyone have any suggestions on what is going wrong? Thanks in advance for any suggestions Eric Dim wb As Excel.Workbook Set wb = Workbooks.Open("http://main.hsi.com.hk/hsicom/table/dyforma1.xls") wb.Sheets("Industry Indexes").UsedRange.Copy ThisWorkbook.Sheets("Temp").Range("A1") wb.Close False |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
| How to load an excel file through web link? | Excel Programming | |||
| Load Excel.xlb | Excel Programming | |||
| Command for userform to load website link | Excel Programming | |||
| How to load a PDF using Excel VBA | Excel Programming | |||
Threaded Mode
