Hi! I'm stuck on this one and have been trying to figure it out all day, with no luck. I'm pretty new to VBA and macros so what is easy to a lot is quite the challenge for me. I have a workbook that I need to put some code into that will go to a specific sheet then open up a SharePoint document and then either copy some data I need to my workbook or save the document in my "data" folder on my hard drive. I have some code below that works, but am stuck at how to proceed.

The code below goes to my sheet and then opens an internet explorer page and goes to the link (in cell A1 of the sheet). I have tried to use the "Get External Data" (from Web) function on the Data Tab of Excel and record the macro so i can see the steps, but it always errors out and doesn't record. The data will not import into my workbook. I checked and my java script is enabled, so I don't know why it won't import in. It may have something to do with the fact that the arrow icons (to select the table to be copied) are not where I need them in order to select the data. By the way, I have Excel 2007.

Any help would be GREATLY appreciated!!

One more thing (maybe it will be useful): the URL address for the SharePoint document ends in .aspx: http://abc.123.com/group1/group2/gro.../xlviewer.aspx




Please Login or Register  to view this content.