Re: pick up a value in MOSS 2007 with a macro inExcel 2007

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Your share point is a webpage the you are accessing using a web browser. The
URL is the address in the webpage where your data is located. One method of
accessing the data is to launch a web browser from excel VBA. Here is very
simple example. You need to understand html objects and data to program
using this method. I can help, but it is difficult without getting direct
access to the html file. I have lots of example and can help. I'm not sure
your experience you ae in programming. It requires more than a novice
understanding of programming.


Sub GetZipCodes()


ZIPCODE = InputBox("Enter 5 digit zipcode : ")

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

URL = "http://zip4.usps.com/zip4/citytown_zip.jsp";

'get web page
IE.Navigate2 URL
Do While IE.readyState <> 4
DoEvents
Loop

Do While IE.busy = True
DoEvents
Loop
Set Form = IE.document.getElementsByTagname("Form")

Set zip5 = IE.document.getElementById("zip5")
zip5.Value = ZIPCODE

Set ZipCodebutton = Form(0).onsubmit

Form(0).Submit
Do While IE.busy = True
DoEvents
Loop

Set Table = IE.document.getElementsByTagname("Table")
Location = Table(0).Rows(2).innertext
IE.Quit
MsgBox ("Zip code = " & ZIPCODE & " City/State = " & Location)


End Sub



"Laurent" wrote:

Hi,
thank for your answer !

post my URL ? you mean from sharepoint ? unfortunatly it s intranet, you can
not reach it from outside.

What I m looking for is quite easy : I m want the code for a macro in excel
2007 to pick up on value in a sharepoint list.

Just give me an exemple of a macro doing this that I can understand how it
works. It would be really nice !

I do not want to import all the list or build some connection but I want to
have the possibility in a macro to chose when and what has to be read on
sharepoint without leaving Excel 2007.

tahnks very much for your help !!!

Best regards





"Don Guillett" wrote:

Perhaps you can post your url and tell what you want.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

.

Relevant Pages

  • Re: Calculating value across multiple worksheets
    ... Please refer to my webpage for the macro code itself, ... My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm ... > Dim cell As Range ...
    (microsoft.public.excel.misc)
  • Print an image of a web page
    ... I have a list of 500 urls in excel and want to create a macro that would ... launch each of the URLs and save the webpage as either a pdf or an image. ...
    (microsoft.public.excel.programming)
  • Re: create xls with pivot setup by web application
    ... Excel you're going to be working with. ... I have a macro created that can be applied by the user easily. ... MS Office System Products MVP ... MS Office Community discussion/newsgroups via Web Browser ...
    (microsoft.public.office.misc)
  • Re: OLE action?
    ... > i have a macro that opens a webpage, 99.9% of the time it works, for some ... > is there any way to get around this or at least be able to save excel ... This doesn't necessarily mean that your macro won't be able to open the ...
    (microsoft.public.excel.programming)
  • Re: Can I save my Excel sheet with Macro as webpage? It seems the Mac.
    ... Excel macros only work in Excel. ... Once converted to a web page the sheet is ... | How can I save my Excel sheet with Macro as webpage and the Micro still ...
    (microsoft.public.excel.programming)