<div>
Use a file datasource instead of a system or user datasource. &nbsp;That way you can store the file for the datasource in a common location (a network drive for instance) and set the Excel sheet to reference it there.
</div>


Use a file datasource instead of a system or user datasource.  That way you can store the file for the datasource in a common location (a network drive for instance) and set the Excel sheet to reference it there.

<div>
Does the worksheet have to reside on each computer? &nbsp;I have tried to connect a worksheet on a network drive but it doesn't update when I run it unless I detach and attach the link again. &nbsp;Any better ways of doing this?
</div>


Does the worksheet have to reside on each computer?  I have tried to connect a worksheet on a network drive but it doesn't update when I run it unless I detach and attach the link again.  Any better ways of doing this?

<div>
Also, sometimes I am getting a binding error.
</div>


Also, sometimes I am getting a binding error.

<div>
Thanks. &nbsp;I changed the datasources to file datasources on the server and used the UNC path as well as refresh the data. &nbsp;It works!!
</div>


Thanks.  I changed the datasources to file datasources on the server and used the UNC path as well as refresh the data.  It works!!

<div>
<div class="content wysiwyg-content">
How do I open an Excel 2000 sheet in VB6 that is connected to access through a datasource without the datasource residing on that particular computer?I need to have this sheet open refresh all datasources and then print to several printers? &nbsp;I can't get it to work unless I create datasources on each computer. &nbsp;
</div>
</div>


How do I open an Excel 2000 sheet in VB6 that is connected to access through a datasource without the datasource residing on that particular computer?I need to have this sheet open refresh all datasources and then print to several printers?  I can't get it to work unless I create datasources on each computer.  

How do I open an Excel 2000 sheet in VB6 that is connected to access through a datasource?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.