Access Files On Remote Computer

Nov 27, 2009

I have an excel workbook that lists the number of mailboxes on several exchange servers. Because this info is put in manually by several people throughout the day there is a chance for mistakes. I can use remote desktop to get into these servers and check all these but when you have over a hundred (Enterprise Level) of these different mailbox stores to check, it takes a while and just isn't fun. I have a friend who made a vbscript file that can check them all but I don't have that code but now I know that it is possible...well with vbscript anyhow.

is it possible for excel to access a remote computer? and how would this be done? If needed to we can be already remoted into it I just need help with the Syntax of how to then access it via some VBA.

View 4 Replies


ADVERTISEMENT

Does An Add-in Script Executes From A Remote Computer?

Dec 2, 2009

i have an excel file with some vba code that includes some functions of a third party add-in also. It works fine when i open this file on the host machine. (Assuming host machine is where the Excel File is placed) But when i try to open the same file from some other computer(remotely/by sharing folder), the add-in malfunctions because of one reason that it considers the remote machine to be its host. Is it possible to set a permanent host machine for that any add-in. Or is it possible for that add-in / Excel file to do its calculations and updation of links on the host machine where it is placed.

View 4 Replies View Related

Restrict Workbook Access To One Computer

Dec 23, 2006

I wish to send a workbook but need to ensure that this workbook stays on the computer it is destined for. I understand that for ultimate security excel may not be the best option, however im using excel and with that need to look at the best options available to me.

My thoughts were along the lines of sending a simple application for better words in excel, and having the user fill in a few details, this would trigger a events macro recording A the machine id ( which i have forgotten how to do any any help would be great with that ) or B the user ID to a hidden cell, then on receiving this back be able to use that as a key in the application before sending it out.

Then if the user was to pass this to another person it would not work as the code would not match. Does this seem like a best approach or is there a better way that a similar effect could be had?

View 9 Replies View Related

Listing Files From Your Computer

Apr 16, 2004

I am attempting compile a list of files from my computer into a spreadsheet but I am not sure how to get the list in the first place--I have searched many, many websites and everyone directed me here...

View 9 Replies View Related

Macro To Zip Access Files?

Mar 13, 2014

I need a macro to zip only the access files in the folder placed in the desktop.

View 1 Replies View Related

Unable To Access RPT Files In Excel Macro

Dec 7, 2012

I am not able to access *.rpt files in excel macro

By using this below mentioned codes am not able to open the files from folder.

Code:
fpath = "C:Documents and Settings est"
f = Dir(fpath & "*.xls")
Workbooks.Open Filename:=fpath & f

View 4 Replies View Related

Macro To Access And Read Data From HDF Files?

Feb 16, 2013

Does Excel can be used to read data from HDF files? Specifically, what I would like to do is this: I have an Excel worksheet with some latitude data on Column A and longitude data on Column B. I would like to open a HDF file, which contains many sets of data, out of which 2 are the latitude/longitude data, and a third set contains the data that I want to extract. I will use the latitude data in Column A to search through the first set in the HDF, which will return me the row number. I will then use the longitude data in Column B to search through the second set to return the column number. With these row and column numbers, I will then extract the corresponding data in the third set, and write it to Column C in the worksheet.

how to write a simple VBA code for it? Or point me to some relevant information?

View 1 Replies View Related

Access: VBA Combining Multiple Excel Files To 1 New Sheet

Oct 10, 2003

I have multiple worksheets spread across multiple Excel files (1 worksheet per file).

All files are stored in the same folder, and all worksheets have the same column headers and structure. I need a block of code that will combine all of these worksheets into a single worksheet in a master Excel file. That is, the code needs to:

1. Open the first Excel file.
2. Copy the first worksheet's contents into the first worksheet of the master file, beginning at the next empty row it finds.
3. Close the Excel file, and move on to the next file.
4. Repeat.

So in the end, ten worksheets residing on ten different Excel files will be combined into a single worksheet in a single file. No breaks are needed between them, instead, the last row of a worksheet would be followed by the first row of the next one immediately below it. No aggregate functions involved, no sums, nothing like that (which is why I don't think I can use the Consolidate function in Excel).

View 5 Replies View Related

'Remote' Addition

Mar 16, 2009

I am hoping someone with excel experience can be of help to me with an unusual request for excel.

Assume cell A1 = 2, B1 = 3 and i wish the sum of this (5) to appear in cell C1. Very straight forward so far, however i wish the result to appear in C1 when i left click on a cell other than C1, say for example D7.

I can't use any macros for this.

View 11 Replies View Related

Phantom Process With Remote VB6 Dll

Jun 21, 2008

I remoted most of my number crunching stuff to a dll.

It work fine except for a few strange things that I observed like from time to time a strange message "Error in loading DLL" even though everything works fine. This message appears only when entering the main formula in the formula, and is no problem at all in usual work.

When I investigated, I noticed in the "windows task manager" that one instance of excel remains open even after I have closed excel. This phantom excel process is maybe related to the other problem I explained above.

Instead of calling a VBA function, it creates a VB6 object from this dll and uses the methods of this object. In this way I have remoted the number crunching functionality.

The main parameter passe in this process is a reference to the original workbook. I need it because the number crunching functions need to read data from the workbook.

I made it sure to terminate the life of the object properly on both sides by ad hoc obj=Nothing statements.

Still I think that the "garbage collection" or the "terminating" is the cause of the problem.

View 9 Replies View Related

Ignore Remote Requests

Dec 24, 2008

I've just discovered that if you include the line: Application.IgnoreRemoteRequests = False. in a Workbook_BeforeClose event, and then close the workbook using ActiveWorkbook.Close

the

Application.IgnoreRemoteRequests = False

line is itself ignored! Code attached - the only workaround I can come up with is also included (to re-enable IgnoreRemoteRequests BEFORE the workbook is closed programmatically) - can anyone confirm this, or break it, or come up with a better explanation or workaround?

View 7 Replies View Related

Remote Extra Commas From Column

Jul 21, 2014

I am looking for VBA code to remove extra commas from d column.

Missing
, , , 1617614,
, , , 1676652,
, , , , 1676664, 1676665, 1676666, , 1676668, , 1676670
, , 1591813,,,,
, , , 1591113,

View 9 Replies View Related

Electronic Log Of Sheet Usage - Remote

Jun 5, 2007

I send out multiple versions of the same sheet every month. I want to be able to have a script run every time the spreadsheet is opened to send an electronic log directly to a text file on my machine (or something similar)

Is this possible or some sort of a pipe dream?
It would be used for me to monitor usage of the sheet, and i'd require only the same of the spreadsheet (which is always unique), the date/time and possibly the computer name / username? (not really needed)

View 9 Replies View Related

Unable To Send Mail Using CDO (remote Server)

Feb 11, 2009

I have CDO set up on in an excel workbook contained on our network. We have been using the following code for well over a year. It works flawlessly on 12 of our 13 computers. I can send mail through Excel using the following code on my computer. But not on a particular computer. The user at that particular computer can't send mail through the CDO code from her computer but can from other computers.
This problem is definitely isolated to a computer. I had tech support un-install office, use a cleaning tool, then re-install office. The problem persists. Is there a particular setting on this computer that needs to be set that I am unaware of?
Here is the code...

View 3 Replies View Related

Get Value Of Hidden Element From A Form That Is On Remote Website?

Jan 9, 2012

My code should get the value of a hidden element from a form that is on a remote website. Then it should display that element's value on my excel worksheet.

One or the other of the 2 lines between the commented out lines should work. Instead the code runs until within a minute after the page has finished loading, and then stops completely without getting the hidden element's value.

Code:
Sub work_damit()
Dim ieApp As Object
Dim URL As String
URL = "http://www.craft-e-corner.com/p-2688-new-testament-cricut-cartridge.aspx"
Set ieApp = CreateObject("InternetExplorer.Application")
ieApp.Navigate URL

[code].....

View 9 Replies View Related

Reading Remote Desktop Current CPU From Excel?

Sep 17, 2012

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?

View 7 Replies View Related

Sending Mail Through A Remote SMTP Server

Feb 14, 2005

I've been trying to send emails through an SMTP server in various ways. I've been able to send email using CDO going directly through an SMTP server on my same local network (not requiring a username and password). But now I am trying to send email from my home with the SMTP server I am using that is hosted by some commercial company. I used the code below, which is sponsored by Paul Sadowski:

Sub sendMailRemote()
'Sending a text email using authentication against a remote SMTP server

Const cdoSendUsingPickup = 1 'Send message using the local SMTP service pickup directory.
Const cdoSendUsingPort = 2 'Send the message using the network (SMTP over the network).
Const cdoAnonymous = 0 'Do not authenticate
Const cdoBasic = 1 'basic (clear-text) authentication
Const cdoNTLM = 2 'NTLM.......................

View 9 Replies View Related

Update Remote References Without Opening The Second Sheet

Feb 27, 2008

Is it possible to update values within a second workbook without opening that workbook?

Also, is it possible to use INDIRECT to reference another workbook?

View 9 Replies View Related

Data From Closed Workbook On Remote Server

Jul 4, 2007

I worked with an Ozgrid macro until it was what I wanted using files on my local PC. I then edited the macro to get data from a closed workbook on a remote server. I now have a Run-time error '1004'

Method ' Range' of object'_Worksheet' failed and the debugger takes me to this line of code.

With Sheet1.Range(AreaAddress)

The only thing I have changed up to this point in the macro, is the address of the file on the remote server.

I am at a loss with this now. Am I trying to do the impossible? ....

View 9 Replies View Related

Excel 2010 :: Error VBA 462 Remote Server Not Found

Nov 2, 2013

I have created a macro that creates a powerpoint from excel in office 2010. I have followed all the required steps, like adding object library and all. but still many times the PowerPoint crashes at slide7, 8 or 9 and have to restart. I generally get the above given error.

Code:
Sub CreatePowerPoint()
Application.ScreenUpdating = False
'Macro Created by Pallavi NC (pallavi.nc@hp.com)
'Add a reference to the Microsoft PowerPoint Library by:
'1. Go to Tools in the VBA menu
'2. Click on Reference
'3. Scroll down to Microsoft PowerPoint X.0 Object Library, check the box, and press Okay
'First we declare the variables we will be using

[code].....

View 1 Replies View Related

Programmatic Access To Trust Access To Visual Basic Editor

Jan 10, 2007

I am Generating Excel file with Macro using my asp.net (c#) application.

I am able to generate Excel file in development environment, but in Production it gives following error:
"Programmatic access to Visual Basic Project is not trusted Line: Microsoft Office Excel"

I did googling a bit and found that I have to open Excel file physically make few security related changes in macro as below.

1. Open the Office application in question. On the Tools menu, click Macro, and then click Security to open the Macro Security dialog box.
2. On the Trusted Sources tab, click to select the Trust access to Visual Basic Project check box to turn on access.
3. Click OK to apply the setting. You may need to restart the application for the code to run properly if you automate from a Component Object Model (COM) add-in or template.

Can i do above changes at runtime (using some code)?

View 4 Replies View Related

Access-Like Report Without Utilizing Access

Sep 12, 2006

I have an Excel file ( named "Classes.xsl"), that has a worksheet (named "RawData") that is layed out something like:

Name Dept Class
John 0547 Class 1
Jane 0368 Class 1
Jim 0368 Class 2
Sue 1235 Class 2

I am trying to get an Access-Like report without utilizing Access. Is there a way to generate a report similar to below using Excel as the data source (could be mail merge, perhaps a macro with a printout) I am not sure which way to try and was hoping someone could point me in the right direction...and possibly provide an example.

Class EnrollmentClass 1John 0547
Jane 0368Class 2Jim 0368
Sue 1235

View 4 Replies View Related

Get Computer ID

Mar 5, 2008

Is there a code available that can be used to get the user's computer ID number (Not Computer Name)? I'm using a password generator to randomly generate a password and I would like to use this unique password with the user's Computer ID.

View 9 Replies View Related

Computer IP Address

Mar 10, 2006

I have a problem running an excel macro on different laptops because the IP needs to be known (my program links to databases that are installed on a "server" laptop). The IP can be sourced by using the "Start, Run, cmd, ipconfig" but my users can have problems with process.

Does anyone know of a vb function that will display the ip of the computer that the code is run on?

View 9 Replies View Related

Macro To Get Computer ID

Jun 28, 2007

a macro to get the computer ID of the computer where the excel file is opened?

View 9 Replies View Related

Overflow On One Computer But Not On The Other

Sep 8, 2007

i am experiencing runtime error '6': overflow on one computer but not on another computer when it is the exact same file running on two different computers.

View 9 Replies View Related

Formula To Get The Name Of My Computer?

Apr 5, 2008

Is there a code or formula to get the name of my Computer?

View 9 Replies View Related

Return The Name Of Computer

Jan 15, 2003

Is there any way to return the name of the computer in Excel using VB?

View 9 Replies View Related

Assign Computer ID

Feb 9, 2009

Does anyone have a macro that could assign a 16-digit number, seperated by dashes, to a computer? (i.e. Computer ID: xxxx-xxxx-xxxx-xxxx)

View 9 Replies View Related

Scale Differs From One Computer To Another

May 9, 2014

Here's the scenario. A co-worker and I access the same file from the same online database and download it in the same manner. We have the same version of excel. We then open these identical files, we run a formatting macro (identical), but when it comes time to set the page breaks in order to get the items to print on the same page I have to increase a columns width to make it fit on one page and yet it still doesn't match theirs. It appears to have a different scale but I'm not sure of the option difference between our machines. I don't know how it could be the printer since it physically gives her different page break option than what mine does.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved