| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening SharePoint lists with Excel Macro
I want to write a macro to open a SharePoint List and copy the data into the
excel file where it will be combined with other SharePoint data from other lists. The path to the list is (forgetting the xxx.yyy.zzz portion): http://xxx.yyy.zzz/Disciplines/Produ...A/default.aspx when I select the datasheet view (to copy from) it has this path http://xxx.yyy.zzz/Disciplines/Produ...et%20View.aspx Normally I would open another excel file (such as test.xls) and use this command, but the equivilent to open these SharePoint lists is what I need help with: Workbooks.Open Filename:= _ //xxx.yyy.zzz/disciplines/test.xls Thank you -- Thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Worksheet Functions | |||
| Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Discussion (Misc queries) | |||
| Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
| Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
| Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
Linear Mode
