server

  1. J

    Problem connecting to DB2 server

    Hello. I normally use the Table Import Wizard in PowerPivot to get new data. I normally use an OLEDB/ODBC connection to connect to my DB2 database. But when I try to connect to the database through the IBM DB2 connection wizard, I'm getting this error message: "failed to connect to the server...
  2. A

    Running Excel from a remote desktop or server!

    Excel friends, I have an excel financial model with some VBA code used by several people located in many countries. I would like to keep them using always the most updated version, and also having some sort of security ID, passwords, VPN, etc. The users should be able to access or read the...
  3. L

    Read only settings

    I have a small office with 4 computers including 1 server. All documents need to be accessible by all workers on all computers. My problem is that every time a document is created on one computer, even if it's first save is to the server, no one else has read write privileges on it until we...
  4. W

    Obtain the share name of a folder on a server

    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...
  5. B

    Excel 2010 keeps opening old version of file

    I have a file that is on a server. When I open it on my excel it opens an old version of it and not the newest copy. If I open it on a coworkers computer, it does open the correct newer version. How do I change this? Thanks, Brad
  6. G

    Import txt File Error

    I purchased PowerPivot For The Data Analyst and downloaded the associated example files. When I try to import the demo file I get the following message: An error occurred while loading the file. More Details:Failed to connect to the server. Reason: No error message available, result code...
  7. S

    Ignore messages by a program due to cnx to excel via macro

    Hi guys I am writing excel macro to create a table for young's modulus of materials. Just briefly describing what is meant to be done, connecting a table with 175000 row (rows contains materials e.x. metals ... etc) with different ID's some times similar, temperatures and norms. What I am up to...
  8. E

    Read/Edit/Update SQL Database from Excel 2007

    Hi, im trying to conect to a SQL Database which can be done easily by "Get External Data" however what i want is the following: -Read Data from SQL Server -Able to modify the table that excel creates -After modifications update that table to the Database in SQL. i dont have a lot of knowledge...
  9. ClimoC

    The Server, The CSV, and the TMP files

    Arvo Thought I'd put this in here rather than the Excel one as the bulk of the code is ADO. So the system I have setup has a read-only workbook that connects to CSV databases, edits them, and saves them back out again (meaning only one workbook to debug!) I have researched and been made aware...
  10. A

    Excel and MSProject automation

    Hello everyone! this is my first post and was reffered here by friends! I am currently working on a project that requires me to export information from MS Project and copy it into excel. The biggest problem im getting is that the files in MS project are located on a server protected with a...
  11. A

    Excel and MSProject automation

    Hello everyone! this is my first post and was reffered here by friends! I am currently working on a project that requires me to export information from MS Project and copy it into excel. The biggest problem im getting is that the files in MS project are located on a server protected with a...
  12. L

    Extend Macros for new Workbooks

    Hello! If I were to build some macros for a workbook, is there any way to extend these to other workbooks? For instance, if I were to be downloading a new excel spreadsheet once a week, is there a way to have the macros already available on the new spreadsheet without having to copy them...
  13. Johnny Thunder

    Updating a file location with Macro

    Hello Friends, I am trying to write a macro that will update a file location based on where the file is on the server by how the user has his drives mapped. For example; on my computer file "Cost Allocations" is on my :H Drive But on someone elses computer "cost Allocations" is on...
  14. S

    ADO Connection Puts Network Database In Read Only

    Hi All, I have an excel spreadsheet that is linked into an access database through ADO connections. The spreadsheet is set up to make updates and adds directly into a table in my database. The database is on a server, what is happening is, and I don't know the cause, the database is being put...
  15. A

    Network Connection

    Is there a script to check if a fileserver connection is valid or not. If a valid connection is detected then continue with other code. If not then exit sub. This is to test if the user is plugged into the network at the office verses at home. The letter drive I am trying to test for is S...
  16. S

    A Friend Suggested SQL...

    We are using Excel for our client database to produce reports and invoices for environmental testing. A lot of technical formulas, lists, etc are in the background. But, the reports have to be easy for the average client to understand at a glance (do we pass? If not, what do we do? Etc.)...
  17. P

    Sending an e-mail from Excel using the server mailfile

    I have some Excel VBA code (see fragment below) which tests the sending of an e-mail via Lotus Notes. This works fine when using a local replica of the mailfile, but not with the server mailfile: Set oNotesSession = CreateObject("Notes.NotesSession") sMailFile =...
  18. O

    Linking to workbook on a server.

    Hi, If someone could provide me with a solution for this it would be much appreciated. I have some excel templates that dump information into another local excel workbook (collection.xls) on the sheet named "datasheet". I use a button on the template with the following code to carry over...
  19. P

    Ping list of servers in Excel

    ****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top