Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

network access problem

Status
Not open for further replies.
anyideas

anyideas

Programmer
May 2, 2002
127
GB
Hello,

I'm opening an excel file on my local machine using a unc address as below:

Set objExcel = objExcelApp.Workbooks.Open("\\x1032NT4\c$\devImplem\welcomeLetter\wordFormat\DataFiles\" & datafile)

However, if I specify I different network machine on the LAN it falls over with an error.

Does anyone know how to open the file and specify the remote machine username and password for an nt box?

Cheers in advance
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
via vb 6.0, please split access table
Replies
1
Views
312
strongm
strongm
2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
1K
strongm
strongm
Ken01
  • Locked
  • Question
Problem with CopyMemory statement
Replies
1
Views
335
strongm
strongm
sal21
  • Locked
  • Question
ARRANGE this Access coe to vb6
Replies
4
Views
521
strongm
strongm
wires
  • Locked
  • Question
Install VB6 IDE and Access97 on W11 ARM version 1
Replies
3
Views
657
Gabor526
G

Part and Inventory Search

Sponsor

Back
Top