Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 2008 > Visual Basic 2008 Essentials
|
Visual Basic 2008 Essentials If you are new to Visual Basic programming with version 2008, this is the place to start your questions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2008 Essentials 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
 
Old May 28th, 2008, 08:50 PM
Registered User
 
Join Date: May 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Accessing MS EXCEL file across network in VB2008

Hai,

    I like to know how to access data from a *.csv file or MS EXCEL file from a network.........let me explain my problem in more detail...My system is connected to a network and in the same network one more machine has been connected,which I can access .Now I want to access the file which is in the second machine in the network and from that file, I have to extract data from certain columns and in the first machine I want to use Visual Basic 2008 to do this. Using the data ,I will process it in the first machine.So I need to access the file and read it across the network and no need of writing back.

    In certain forums I saw the code for accessing a file from the local directory,but I didnt find any solution for accessing a file across the network and one more thing is all the code which was given is not working in Visual Basic 2008,I am getting some exceptions.........So anyone can help me on this and provide a sample code for this problem..........



Thanks in advance...........
 
Old May 29th, 2008, 12:23 PM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

It is not helpful to read that you are “getting some exceptions.” There are so many that you could be getting that there is no way to address such a statement.

To access resources on a network is exactly the same as accessing resoures that are local. You specify the location of the resources. So rather than C:\MyData\MyResource, it might be \\MyServer\MyData\MyResources.

So describe the statements you are using, and which line raises errors, and what that error is (the message, not the number...).





Similar Threads
Thread Thread Starter Forum Replies Last Post
Run a MS DOS Batch file from Excel VBA Louh Excel VBA 1 March 4th, 2008 10:02 PM
Problem in opening excel file in MS Excel 2000 kallol Visual C++ 0 November 16th, 2007 05:48 AM
MS Excel - File Links - VBA a_barnsley Excel VBA 1 July 23rd, 2007 10:48 AM
Accessing network registry katsarosj Pro Visual Basic 2005 0 August 12th, 2006 04:20 PM
Again a problem accessing a network resource nikunjn VS.NET 2002/2003 0 February 6th, 2004 02:47 AM





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