Integrated method for creating a refreshable web query

A computer program product comprising a computer-readable medium having control logic stored therein for causing a computer to edit a tabular data object displayed in a Web page open in a Web browser program in a spreadsheet program, the control logic comprising computer-readable program code for causing the computer to:

• receive a user command to edit the tabular data object displayed in the Web page;
• determine whether the Web page was created using the spreadsheet program;
• if the determination is made the Web page was created using the spreadsheet program, perform a first sequence causing the computer to:
• launch the spreadsheet program;
• and
• paste the tabular data object to the spreadsheet program so that it may be edited;
• if the determination is made the Web page was not created using the spreadsheet program, perform a second sequence for causing the computer to:
• launch the spreadsheet program;
• and
• open a Web query dialog box in the spreadsheet program, wherein the Web query dialog box is loaded with the Web page displayed in the Web browser program;
• receive a user command selecting the tabular data to edit in the Web page displayed within the Web Query dialog box;
• and
• paste the tabular data object selected in the Web Query dialog box to the spreadsheet program so that it may be edited.

A computer readable medium accessible to a computing system and on which is encoded a computer program for executing a computer process for creating a Web query in a spreadsheet program directly from a Web browser application program using a context menu, the computer process comprising:

• displaying a Web page in the Web browser application program window;
• placing a pointing device within the Web browser application program window receiving a user command to activate the context menu in the Web browser application program;
• determining whether the pointing device is located over at least one of a predefined set of objects in the first electronic file;
• if the pointing device is not located over at least one of the predefined set of objects then do not display the context menu;
• if the pointing device is located over at least one of the predefined set of objects then performing a first sequence, comprising;
• displaying a command button in the context menu;
• determining whether the command button in the context menu was selected;
• if the command button in the context menu was selected, determining whether the pointing device is located over the tabular data;
• if the pointing device is located over the tabular data, then performing a second sequence comprising:
• launching the spreadsheet program;
• creating a Web query in the spreadsheet program associated with the tabular data object in the Web page;
• if the pointing device is not located over the tabular data object in the Web page, determining whether the pointing device is located over at least one of a predefined set of objects in the Web page;
• if the pointing device is not located over at least one of the predefined objects, then performing a third sequence, comprising:
• launching the spreadsheet program;
• and
• opening a dialog box in the spreadsheet program, wherein the web browser application program is running within the dialog box so that the user may select a tabular data object to copy to the spreadsheet program.