
	Home > Ask the Domino Experts > ARCHIVE: LotusScript and Web Development Questions & Answers > Agent to open an Excel file and pass the URL on for a Web query?

Ask The Domino Expert: Questions & Answers

EMAIL THIS

Agent to open an Excel file and pass the URL on for a Web query?

EXPERT RESPONSE FROM: Dave Hatter

		Pose a Question

		Other Domino Categories

		Meet all Domino Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 31 May 2002
In MS-Excel: Using Data ->get external data->new Web query, if we type the full URL of a view, "http://server/db/view?openview", we can collect data from any view (from Dominno server). But, in this case I have to type the URL and it is fixed. Is it possible that using an agent I could open an Excel file and pass the URL for a Web query as a parameter.

While I've never tried it, I don't see why not. You should be able to write an agent that uses COM to talk to Excel and automate this process. Alternatively, you could use the VBA capabilities in Excel to script this process or you could use something like VB to do this as well.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	ARCHIVE: LotusScript and Web Development
	"Field or view column exceeds 32 Kb" errors from the @DBLookup formulas
	WebQueryOpen/Save agent problem
	Using the function @DialogBox in a Web application
	Code for validation on a field
	Displaying info. in the order it appeared in the view
	Display from my Web page an an online link using Excel
	Using @Unique
	Creating a dynamic menu
	Code used for the HTML head content section
	Using VB script on a Web server and submitting online forms to a Lotus database

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

Lotus Notes Domino on Blackberry and mobile devices

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 1999 - 2009, TechTarget \| Read our Privacy Policy