server

I just started learning Reporting Services of Ms SQL Server and found it is no match with Power BI from a beginner view. Anyone is still using Reporting Server and please advise if I should continue with MS Reporting Service or simply jump onto Power BI instead ? What is the advantage of...

Hi all, I am revamping some code that aggregates data from several tabs of a workbook and copies them to another file, which is used as a link file in an Access Database. When the code goes into a Do Until loop, it processes the data fine, unless there is a blank tab and then a final tab with...

Hi everyone, I'd like to know if someone tried to find out any solution, how to connect desktop MS Excel to Snowflake server (as well as we connect to this server via Tableau). Is there any possibility how do that? Thanks, Tomas.

Greetings All, I have a school the runs 30+ computers. Recently, we had a lot of them stolen. I would like to have my inventory not only list the SN of each, but also a lot of the fine details that help recover these items if it occurs again. I am a start-up school, money is very tight, so...

Hi! I hope this is the right forum for this question. I have spreadsheets that I want to share with my clients that fetch data from an SQL server. But to update this data require login credentials to the server, and I don't want to give my clients direct access to the server, even if the...

Hi All, I have excel program which gets data from server, address is like: \\ABC\Data\Items.xlsb It was working perfect, now company put password on server folder (let say “sunset”) What should I add to my macro to open my file “Items.xlsb” from protected server ? Thank you in advance

I have data & PowerQuery in Excel and I wish to store data in SQL Server Express instead. How to do that ? In addition, should I keep PowerQuery in Excel, or actually we could use SQL Server Express to do the PowerQuery job ? Please advise. Thanks

Hello guys, I am running a web dataquery on Excel 2016, which dumps the data to a table on a Sheet. This runs continuously, and have it set to refresh in backgound automatically every 5 minutes. Every so often I get an error warning : [DataSource.Error] Web.Contents failed to get contents from...

I currently have a Macro that will Send an email Automatically in Outlook. I use .HTMLBody. The Email needs to include a picture after the text. I have it working with <img src...=""> pointing to a jpeg on a Server. However, it's slow as it takes several seconds for the picture to open once...

Hi Guys, I'm new to VBA. I'm working on my first macro. I want to paste a formula (using the Exacta Server - Company Server) as a value (instead of a formula)... The caveat is excel doesn't calculate the formula UNTIL the macro ends. Is there a way to FORCE excel to calculate the formula while...

You know how you can put a spreadsheet on a shared drive, and then anyone can use it, but only one person can use it at a time? Well, I just got around that limitation. :) I work for a huge law firm. We send our closed case files to offsite storage, but we frequently have to bring some of...

Hi everybody, I've been trying to configure my excel spreadsheet to send a short email notification to colleagues when a certain value is detected. However, my organisation wouldn't give me the SMTP server address. I've been reading about this topic but I get the sense that it is not possible...

Hello everyone... I have a few files that are automatically being prepared though a macro and then an 'output file' is saved. I would like these files to be saved to SQL server (2014) using the same VBA code. I tried many code-snippets but nothing seems to work. I don't need/ want to insert...

I want to say thank you for clicking on my post and and thank for any help you might be able to provide. What I am trying to accomplish is for an old BBS that I help assist run. I am trying to provide helpful information for the small user base that still continues to play. Attached below is...

There is a file in a FTP server that I would like to download into MS Access 2010 to replace the old version of the file when I run the code/macro. We will call the table "PriceFile" To get to the server I usually open a browser and enter "ftp://XX.XX.XXX.XXX", enter in user and pw, and then...

Hi there, I trying to write a script to compare filesizes of local and remote (on a web server) files... I can get the local filesize by using: Dim localFileSize As Long localFileSize = FileLen(ThisWorkbook.Path & Filename) MsgBox "local - " & localFileSize I can check if my 'remote' file...

I have a routine to send email using CDO (found on the web, but not sure where). I have been using it for about 4 months and only had one problem,"The transport failed to connect to the server." . I waited about an hour and all was well. I reference a excel file using vlookup to get the...

Dear Friends In my Excel workbook I have created links to some media files with the help of Hypelink Function. The media files are on the shared folder on the server PC. The workbook is on Client PC in a shared folder. Now when I click on the link it says "Cannot open the specified file"...

The excel files corrupt when saved to a file server instead of the file there is a folder with the file name of the excel file plus a number of extra charactors (random) and in the folder a file with a randon group of letter and numbers for a file name but no extension. This file can be...

Hi I need to purchase a new high end PC. I currently have a 2 year old XEON pc, with 32gb ram, 64bit, SSD. I need more power from Excel. Cant figure out if i need more ram or a faster processor with more cores. I use a 100mb file that OBDC to our server. But I only see about 20% cpu usage and...