remote

Hi, this an continuation of some code I posted in the past see Here ... This new addition uses file monikers to register objects in the Running Object Table and hence makes it possible to access UserForms from remote processes via the standard GetObject vba function. The advantage of using...

Good afternoon! I'm still very very new to VBA and user forms in Excel so I'm hoping to get some help. I'd like to create a user form that would allow for the selection of 2 independent defined variables and produce all possible results. Example: I have a remote that can use multiple battery...

Hi, Harder than it should be. My code is below but im being told to remove the forward slash. Please advise the correct way to open my image using the path shown. Thanks Private Sub Flag_Click()ActiveWorkbook.FollowHyperlink Address:=C:\Users\Ian\Z THE REMOTE DOCTOR\database-logo\flagg.jpg...

Hi i have tables with formulas referencing other tables, which are placed on the firm's remote server, where i login through VPN. Opening and saving of such files (referencing remote files) takes too much time and CPU power - until 95% of CPU power. And, i can't work with values instead...

I use the following formula to return the location of the active "master" workbook. =LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1) This value is used in other formulas within the workbook as well as Power Query to identify the location of various source files in subfolders. My problem...

Hi, Need help my codes keeps crashing my excel. I'm looking to check is the data in cell A and Cell B is the same as Cell A and Cell B on row 2 for the entirety of the data on the sheet. e.g. if a2 row1 = a2 row2 and b2 row1 = b2 row2 Then combine D1 row 2 with d1 Row1 and E1 row 2 and E1...

I am able to reach the remote desktop, but unable to find path to the file on remote desktop to copy the file from remote to my local desktop. Please help. This is what i have so far: Sub Connect() Dim retval As Variant Dim myid, mypw As String myid = InputBox("Enter Mednet ID", "MEDNET...

Hi there, I trying to write a script to compare filesizes of local and remote (on a web server) files... I can get the local filesize by using: Dim localFileSize As Long localFileSize = FileLen(ThisWorkbook.Path & Filename) MsgBox "local - " & localFileSize I can check if my 'remote' file...

Recently my company has changed EXCHANGE servers. I have been using CDO for years. Now my emails are not being delivered. I keep getting this message: Remote Server returned '550 5.7.1 RESOLVER.RST.AuthRequired; authentication required' How can I get around this? Thanks.

Hi all, I am not experienced with network programming so I am asking here if the following prank would work (this is just an illustrative example) Ok- Let's say a remote workbook (located in a network shared Drive/Folder) is currently opened by some user on the network and I wanted to play a...

Hello all, Is it possible to connect to Oracle server with VBA when the excel application and Oracle resides in different servers? I should mention the server where the oracle resides needs it own authentication. So I need to use a kind of connection to the server with supporting authentication...

Sub GetCSV() Const strFilename = "MINUTE.csv" Dim wshList As Worksheet Dim wshTarget As Worksheet Dim r As Long Dim m As Long Dim objXML As Object Dim f As Long Dim arrResp() As Byte Dim strWebfile As String Dim strLocalFile As String Dim strIP As...

Hello all, Does anyone know a way in VBA to get the share name(s) of a certain folder? Detailed explanations: I have access to a folder (say, D:\MyFolder) on a remote server in the network. That folder is shared in order to have access, I do not have access anywhere else. But I would like to...

I do not expect to get an answer on this one but on the odd chance that someone has done this before I need to find a way to collect current CPU usage of a specific application on a remote server or the top applications that are using the most of the processor's time on a remote server? I have...