download

Hi all, I use VBA to enter array formula linked to external file (cloud). At the end of my code, I break all links. This results in cells with no values. This is because Excel needs a bit of time to download the content but because I break links immediately after the code, the values are...

PROBLEM STATEMENT: I am unable to open file attachments via a URL using VBA. Instead of getting the file, I am asked to log in. DETAILS: This was working a couple of months ago. The URL's seem to be OK. The URLs are like this...

Hi does anyone know where this file can be found anymore, it does not seem to be supported anywhere, I am trying to find a userform datepicker. Is there another way to get one?

Hi, I want to know if it is possible ( and if so, how would I do so) To Have a cell in my sheet to when clicked on open another excel sheet. So: Press cell A2-> Open Excel Sheet ( Either by download) Unknown If more clarity is needed on the wanted function , feel free to ask!

Using Excel 2007 and getting this message on launch, followed by a long wait as configuration runs (every time). On Googling I see it's quite common and caused by some Windows update. But the instructions for fixing are many and varied. Some say repeat steps 5-8 but they're not numbered. Or you...

Hi Everyone I have a list of files in excel sheet hyperlinked from my network drive I need to download the selected hyperlinked files in specific folder Please help

I would like to write a macro to go to an internal company website to download data and import it into my spreadsheet. The website requires me to login and do a series of mouse clicks to download the data as excel spreadsheets, for which I already have developed a macro to merge these...

Hello all, I am trying to automate some tasks which are being done through Internet explorer, which include downloading a file and then copying it to a different directory and renaming it. I was more or less successful in finding the information on how to do this, the code is working, but it...

I'm a phys ed teacher and recently I posted up a workout log on Microsoft Teams for my students to download, fill out and return to me electronically. Since Teams is still kind of glitchy and not all students know how to access it as easily as a google spreadsheet, I was trying to come up with a...

Hi..i need help with this...i want excel to go to this page<code> "http://www.soccerstats.com/results.asp?league=portugal_2017" and download all the results using vba...im trying to do a football h2h excel spreedsheet. my level of excel is basic. exemple: in sheet 1...a1=portugal and when i...

Hi I have files (.xlsx) within a sharepoint site (folder) that I'd like to download using vba. Alternately, it would be ok to download a single xlsx file. Many thanks Anthony

Hi, I am using Outlook to automatically download a particular CSV attachment I receive by using Outlook Rules and the code below. This process works fine. However, I would like to download the file as an Excel file instead of its default CSV format. Could you please help me make that happen...

Hi, I am using Outlook to automatically download a particular CSV attachment I receive by using Outlook Rules and the code below. This process works fine. However, I would like to download the file as an Excel file instead of its default CSV format. Could you please help me make that happen...

I am attempting to create a Macro to auto-update an existing report. Using Microsoft Office Home & Business 2016 Edition - version 1711 Scenario: Have existing workbook named Expense Report, with 6 worksheets all named by different days and a total page. I also have a web based CSR program...

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.... I need to download multiple files (all files *.xlsx) from a folder on ftp server where i have user name and password. I need to save these files on a folder on my pc. Please help me with a code. Regards Aman

Hey Excel Geniuses, I know that this is possible as I have done this before but I can not remember how. I know how to download data as a CSV and how to upload that into an excel (using from text). However I want to build a connection that will go to the site and download that CSV for me, then...

<tbody> How to build a macro </tbody> How to build a macro that senses when a multi-column csv file has finished downloading and then proceed to process that information. The web service is called manually by the User; it does not support a Data Connection but it does download to the User's...

Dear All, I hope you can help me I am trying to download historical share data for share 8088 from yahoo Japan. The first page of the table I need is in the following location: - https://info.finance.yahoo.co.jp/history/?code=8088.T&sy=1983&sm=11&sd=19&ey=2017&em=12&ed=19&tm=d&p=1 I then...

Hello All, I have never done programming in VB so this is fairly new, had done some PB programming more than 20 years ago but can't remember anything :(. I exhausted in-built sort option Excel provides for what I want to achieve. I need some help in restructuring data that I download...