Posted to microsoft.public.excel.programming

rosen

external usenet poster

Posts: 3

vbscript question...

If I want to perform a data base update (i.e. same as hitting "!" in
the UI) from a vbscript what command should I use....

SpreadSheet = "D:\test.xls"

' Create the Excel application object
Dim Excel
Set Excel = CreateObject ("Excel.Application")
Excel.Visible = True

Excel.Workbooks.Open SpreadSheet

Excel.Refresh <---- This is giving me an error
Excel.Workbooks.Close
Excel.Quit

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Run VBScript from Excel	Amy M	Excel Discussion (Misc queries)	4	September 19th 08 09:07 PM
Anoth vbscript question ... sorry !	Sean	Setting up and Configuration of Excel	1	March 20th 08 09:22 PM
VBscript	sebastienm	Excel Programming	0	September 22nd 04 08:24 PM
VBscript	raji	Excel Programming	0	September 22nd 04 08:03 PM
Pastespecial via vbscript not working	msnews.microsoft.com[_7_]	Excel Programming	2	December 20th 03 02:37 PM

All times are GMT +1. The time now is 11:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us