server

Hi, Have a traditional star schema Kimball Tabular model in SSAS. There are 2 fact tables. GeneralLedger and GLBudget. I've been encountering a timeout every time with the Summarizecolumns command below. I took out the measures below and still get the timeout. If I remove the BP dimension...

Dear All, I have to download all files from a ftp server and paste them in a folder in computer my ftp server is: ftp://user:pw@10.128.158.152 (user is user id and pw is password) my destination folder is c:\temp Can anyone tell me how to write a macro for this copy (cut) paste function in...

Hi, I am new to VB and have a custom requirement as below, 1. Create a drop down list in excel and the values in the drop down list should be pulled from a table in SQL server database. 2. In the same Excel sheet, Create a Button, When clicked, that will call a store procedure from the small...

Hi, I am able to create easily enough to open or even hyperlink to a specific folder location based on cell values but would like to be able to open a location based on only cell value. To give a background example of what I am trying to achieve: Cell A1 = Name of Client (NAME) Cell B1 =...

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.

I'm requesting stock quote data via RTD from my brokerage's server, but they have a limit of 50 quote-requests / second, and the server disconnects you if you exceed that. The worksheet is currently set to execute 500 rows of formulas at once (each requesting 1 symbol quote), which I need to...

I have a workbook where I work with Excel files via VBA which involves defining a variable as an object, then setting that object as a new filesystemobject. The code would look like this: Sub Test() Dim fso as Object Set fso = CreateObject("Scripting.FileSystemObject") End Sub Of course...

Hi all, I have an excel file saved on our server that contains hyperlinks to various folders/documents/pdf's across our server, I want to save the excel file to another location on the same server but when I do that the hyperlinks stop working. I've tried changing the hyperlink base to x and...

'SET ARITHARBORT OFF ' 'SET ANSI WARNING OFF, In SQL server, whether Microsoft or Oracle, what would be the implications of fast-incoming positive Integers in a database of 2 opponents (eg. in an election) & possibility of manipulation by introduction of a foreign algorithm (from a hacker or...

Hey Everyone, I need to show a chart that displays between 0 & 120 Seconds (including milliseconds) for Server Loading times tested daily and, then average out the worst servers based upon the daily values entered. In example; 06/15/2017 - 4.02 Seconds 06/16/2017 - 22.92 Seconds 06/17/2017...

Hi, I have searched for the topic, but have not found a match, so posting this as a new topic. I have a reporting dashboard that automatically posts (using VBA) as a web page on certain events. I can post that easily enough on my client's network, and users with access to that can see the...

Overview: Looking for direction on the capability described below. Need general directions to know if this is feasible and list the topics that I should go study. Objective: Store MS Access database and complex set of Excel macros on a server. This will serve about 30 to 40 individuals. My...

I have a list of servers that I would like to find out if they are on or not. I want to do this by pinging each server. On my work laptop I have the permissions necessary to ping each server individually in CMD and Powershell, but I cannot execute any scripts to allow me to automate the process...

Hi I have an excel filewith web query. This query refresh every minute. If my pc is on - the file is refresh every minute. I want to know ,if there is a way to put this file on a server (maybe free server) or another way. My goal: The file will be regularly updated 24/7 (Not from my pc)

Every time I open files from our Sharepoint server the document properties window pops up, which I find really annoying as it wastes screen space and requires an extra click to hide the window. Is there a way to hide the document properties window automatically each time I open the workbook?

I'm pretty good at manipulating VBA scripting, however I've never built a connection from scratch. Only information I have is what I have from my connection from an Oracle SQL developer. ID/password: dcXXXXX12/ dcXXXXXXXu Hostname: pprmm24x Service name: dpr81dc_ro_6777_01 Port #: 1521

<acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> to insert images from file path Basically I have an Excel...

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

Hi all - thanks in advance for any help. I have an application which basically works fine, but I am looking at making some improvements. One thing it does is try to work with other files held on network servers. Occasionally, these files have already been opened by another user, and so the...

Hello, When I insert an Excel worksheet into PowerPoint (both 2010), I get the following error when I try to to open the worksheet: "The server application, source file or item can't be found or returned an unknown error. You may need to reinstall the server application". I can copy a...