How do connect an Excel file from Remote Server
Hi All,
I am creating one application in Excel. In this application One Excel file will be in the Remote Server.When one persone get log in then the file immediately has to link with this excel file which in the remote server. Now my question is
- Is it possible to connect the Excel file from the remote server using VBA.
Please any one help me to do this. i am searching this in lots of way. if not is it possible Access file.
Kalidas
[468 byte] By [
Kalidas] at [2007-12-23]
Hello, sorry for the late answer. You should map that network drive from windows explorer-Tools-Map Network drive.. with a letter, say Y, and "Reconnect at logon" option for easy acces. Than you can use chdrive "Y:\....." path...
It is ok blackmamba,
Please blackmamba i am seraching this very urgently. please help me. i can't understant. The remote server will be in singapore and the user will be in india. in this case how can we map the singapore server in india pc. There are multiple user if we map ther server in multiple system, will it update all users data? Please blackmamba help me. I need this in urgent. I am waiting for your assistant very eagerly.
Kalidas
hey, i didn't taught it was so complicated, and i'm too a newbie to VBA programming.
But i'll do my best. So, first of all i guess that the two PC's should "see" each others.
First of all i suppose that on the server in singapore you have a shared folder that a user on the india pc should have access. Then you can check this:
Start-Run-\\IP adress of the remote server\Shared_folder and see if you can copy any file from there.
If it's ok then you can do the mapping as i stated before...
