server

  1. M

    Power BI replacing Reporting Service

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

    Do Until Loop Deletes and Creates New Sheet Instead of Skipping

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

    How to connect to Snowflake server?

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

    VBA to Collect Computer Attritbutes

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

    SQL to Excel without direct access to SQL-server

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

    Password protected server

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

    Offload data from Excel to SQL Server express

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

    [DataSource.Error] Web.Contents failed to get contents from " URL" (500):Internal Server Error

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

    Embedded Picture in Excel File- Need it to show on Email with HTMLBody

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

    Paste Formula as Value (Using Exacta Server)

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

    Multi-user Excel, anyone?

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

    Is it possible to send email with VBA script without knowing my SMTP?

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

    Save Excel .CSV file on SQL-Server instance

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

    Seeking Help on how to write a complex lookup formula

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

    Get File from FTP Server into Access

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

    Checking size of file on web server...

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

    CDO/SMTP email No longer working

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

    Hyperlink function

    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"...
  19. N

    Ecel files currupt on a file server

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

    Need to buy a high end EXCEL pc.

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

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