server

Excel voodoo happening. I have a workbook that works fine on many many computers. I started using Excel on a cloud server today, using Microsoft Remote Desktop on my Mac. When I opened the workbook (also on the server) the top row was missing. I mean it was there (things hadn't shifted up) but...

Hello, first I want to say that, I'm very new with Azure and Sql server. second, I have an VBA ADO code with a simple select query from an Azure SQL SERVER db. On my main PC (the PC with my SSMS that i use to contacat the sql server) the code works perfect, but on any other PC (I used the same...

Guys We have a CMMS that its database is SQL Server. My intention is to retrieve some information that is already there and use it in my MS Access database for Issues management. I already setup a DSN to connect to SQL Server and works very well. I would like your tips and hints with the best...

Dear all, I have an unresolved problem: - Currently I have an Excel file (Sheet 1), which has a column called CIFNO (this sheet including many lines - more than tens of thousands of lines). - Data needs to be retrieved in SQL Server, that table (DDMAST) also has a CIFNO column. Currently I...

I am trying to run SQL Server Store Procedure from Excel. I have the following code which ran with no error in Excel but did not seem to do anything in SQL Server. What could be wrong. Also how can I check the the connection is setup correctly and working? Thanks Sub Bld_Eol_Bom_Data() Dim...

Hi, I have a fairly standard table containing columns with office names, addresses, site codes, server numbers and contact names for each site. I want to be able to have a search box that I can type a word into and have matching results returned. I can do this using formula to search one column...

I have a couple of non public IPs. I have a programme that uses 1 of 2. I need to detect if either is available, and if not ensure my functions do not run (The whole thing goes really really slow). I haven't found anything simple that will do what I am looking for, anyone point me to something...

Hi all, I am a frequent Excel user and want to learn about Power Pivot, as I will have to handle very large datasets. So I began to read tutorials and saw that SQL is very often a source of data. I installed SQL server 2012 on my laptop and wanted to begin working with...

I understand that it is frowned upon, and in some places, considered 'bad practice', but how else can you do this? I have a .xlsm file that runs competently unattended. I want to be sure that it runs everyday. How else can I do this if not on a server?

Hi all, I have what i thought was a simple task, but cannot resolve. Simply put analysis server has millions of rows of data, i would like to be able to do download 1 day or one store only, like when using sql query and cell value. Set date or store and refresh. Not sure how to do this, please...

Hello, I have made a data connection between Excel and SQL server and it doesn't work on another PC. It works only on my PC in which i have created. However, I would like to run the file in another PC. I think I need to supply username and password via SQL query. Any idea how to solve it...

Can anyone help with a vba script that will strip each server host and ip address from column B into a new line in a new sheet and apply the solution from column A next to each server in the new sheet? Example: Current Layout <colgroup><col width="77"><col width="553"></colgroup><tbody>...

I'm new to get and transform, etc. I have about 12 tables on a SQL Server database that I wan to connect to. Al 12 tables connected to one excel workbook. However, I need to change the data type on the connection. Is there a way to do this across multiple tables? Thanks

Guys I'm a newbie with OOP (Object-oriented programming) I need your assistance to develop a connection inside a class so I can get/access this connection on a module. Here below the function the connects to the SQL Server that is working fine. What I need is make reference to this function...

Hi there, What I am looking to do is move 5 workbooks from our main server (original files) and create one workbook on my pc so I don't have to go back and fourth and all over the place to grab the info I need from the main server. The catch is, I would like them to sync each way. Meaning, if...

Does CDO messaging not support reviewing emails? My client (a state hospital) must encrypt patient-related emails with Virtru. This is a setting on the message so I need to set the message to Review. Unfortunately that is not a CDO.message option! Can this be done? If not what other library can...

Hello, I need to import data from an SQL database into an excel spreadsheet. The query works fine in Microsoft SQL Management Studio, but I don't know how to get VBA to paste it into cell A1 of Sheet1. I have already created the connection using data-> From other Sources->from SQL server...

I’m in need of help. We had a major virus that took out all the server systems. I was able to restore the data to a new SQL sever and the data looks ok. Problem is we have is that we have a 15year old excel van application that reads and writes to this database. Within it there is an ini...

Hi, I'm hoping someone can help solve this riddle for me. I'm getting the following message in Excel after testing a hyperlink I embedded: "Cannot Locate The Internet Server or Proxy Server" I've created hyperlinks before without this issue while using the same Excel version and Macbook...

I am running into an issue when using the Query Table Connection. I am trying to access a URL that provides a data set that I want to import into Excel. When the macro access the server, it prompts the user to enter their password. Is there any code available to hard code the username/password...