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

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

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

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 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

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

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

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

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

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

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

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

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

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

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

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.)...

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 =...

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

****** 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"...