Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Other Programming > VBScript
|
VBScript For questions and discussions related to VBScript.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VBScript section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #11 (permalink)  
Old September 10th, 2003, 03:08 AM
Authorized User
 
Join Date: Aug 2003
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to wenzation
Default

pgtips,
i know it's hard on you. But i really need help to get connected to the network drive(K:\) from the network folder. Can you help me please.

i'm a beginner, hoping to learn more.. please help... thanks a lot
Reply With Quote
  #12 (permalink)  
Old November 24th, 2006, 03:53 AM
Registered User
 
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to digitaldxb Send a message via Yahoo to digitaldxb
Default

Hi I have the same issue and I followed your instructions and created a virtual folder under the main website and i can see the content of the folder in IIS but i am not able to connect via asp script , could you please suggest i am getting below error message :

Microsoft VBScript runtime error '800a004c'

Path not found

/xyz/Addxls_auto.asp, line 111

My Code is below :
Code:
foldername=CStr(cyear) & mm & dd
Set objFolder = objFSO.GetFolder(Server.MapPath("myfolder"))
mPathName = "myfolder\"&foldername&"\"&"subdirectory"&"\"&"temp.xls"
' Response.Write mPathName & "<br>"

'-- Start of First Record Entry ------------------
If (fs.FileExists(mpathName)) = true Then
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
                      "DriverId=790;" & _
                      "Dbq=" & mpathName & ";" & _
                      "DefaultDir=B:\temp"


Reply With Quote





Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating folders on network share JonniP Access VBA 1 January 3rd, 2007 03:51 PM
Listing shared network folders in Java ravishakya Pro Java 0 September 7th, 2006 10:06 AM
Copy Files and Folders on Local Network rupakroy5 VB.NET 2002/2003 Basics 1 May 22nd, 2006 10:09 AM
Report scheduling and deposit on network drives. bjswift BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 1 October 3rd, 2005 01:12 PM
FSO - Network Drives - Please help! sparkyUK Classic ASP Basics 8 August 23rd, 2004 09:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.