Hi All,
I need your help on GetObject function;
The context;
Set myObj = GetObject( ,"Excel.Sheet")
fails though the other conxtext;
Set myObject = GetObject("c:MYDOCU~1\book1.xls", _
"Excel.Sheet")
succeeds even both cases are using...
I finally got the conclusion to this subject and
here is the sample code.
Please note that your PC needs MDAC before you run this.
You will get it from
http://www.microsoft.com/downloads/release.asp?ReleaseID=30894
<SCRIPT LANGUAGE = "VBScript>
'...
I need help to write VBScript copying files from web like;
Set fso = CreateObject("Scripting.FileSystemObject")
fso.CopyFile "http://www.XXX/BB/TESTBook.xls", _
"c:\MYDOCU~1\"
Could it possible ?
Initially...
******************************************************
Dim ol,ns,newMessage,nl,myUser
Set ol = CreateObject("Outlook.Application")
Set ns = ol.GetNamespace("MAPI")
On Error Resume Next
ns.Logon "Microsoft Outlook Internet Settings"
if Err then
Err.Clear
Set ol =...
Hi, I need your help to solve this problem;
Public Sub MyShell()
Dim ReturnValue As Long
Dim myApp As Excel.Application
ReturnValue = Shell("c:\Program Files\Microsoft _
Office\Office\EXCEL.EXE", vbMaximizedFocus)
AppActivate ReturnValue
Set myApp = GetObject(...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.