download

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

I am looking for some code to download files from a Sharepoint folder. The file names all contain the phrase "Monthly Invoice". The goal would be to have the Macro/VBA go to the Sharepoint site and specific folder, then only download the files that contain "Monthly Invoice" as part of the file...

Hi, i have searched everywhere and couldnt get any vba code which will work for me. i need vba code to download excel files from a sharepoint (sharepoint2013) link to some folder in C drive and work on them, save and then load them back to same sharepoint link. Please help me

Last week, Yahoo Finance apparently shut down the API that Excel macros use to pull stock data. I have tried using Google Sheets, which does work, but it's a manual process (Copy/Paste-Special from Google Sheets to my Excel worksheet). Has anybody developed a solution that automates the stock...

hi, i am using below code to download data from ftp server , and it work fine , but data not updated , so when i download file if this file updated on the server and i download it again , it will update the file but without new data ( i saw date updated but new data not in the file when i...

I'm not sure if the download of Kutools is related, but the error I get is Compile error: Ambiguous name detected: progress07107 I don't know what that means so I just deleted that report so I can create it later, and it goes to my next Sub and says the same error for that one until there are...

Can anyone point me to where I can download this file please

Hi All, I am new to VBA Coding I am stuck on a coding in vba. I have to go a web page eg.(http://120.12.34.65/instarecoder) then a login window prompted i have fill user id and password there. after that a main page appear there i have to click on check box, some box appear below check box and...

Hi All, Please help me with excel vba code to extract reports from peoplesoft. I tried searching in google but was not successful. I have access to only excel and cannot download any third party tool. Everyday I need to download data from peoplesoft I needed to automate this task that almost...

Hi, I am attempting to create a cryptocurrency tracker/portfolio however I cannot figure out a way to make the prices of each coin update themselves by fetching data from one of two website in GBP either coinmarketcap or worldcoinindex. This is the template I am using:Crypto Currency Tracker -...

Hi All, I'm new to the forum and pretty new to VBA so be easy with me :) I'm currently trying to write a script that will run a transaction in SAP, and download the output to a specific location. There are 2 ways to download the output, one through the menu structure in SAP which I can code...

Hi I am trying to create a macro to open an instance of IE and browse to a URL Then need to search for a hypertext link named "Download in csv" within the page i've navigated to. This hypertext link URL is dynamic (changes) hence I cant link directly to it. The hypertext link function is to...

Hi everyone, I am trying to download a file from the following site Access Denied . Manually I will be able to download the csv file by clicking on the text "Download in csv". I am trying to automate the downloading process in excel. I am unable to find out why it is failing. I have a code...

I have several excel files that will need to be linked. First I will have a File coming from Quickbooks that will have updated inventory on it. Second file is my template file in Excel for that particular vendor that will have inventory, description, etc. Third the upload file for Square which...

Hello guys, I found a code that download all archives from links located in the Column Q, and it's working very well. But would be perfect if I could download with a diferent filename, using the value of column S. Thank you in advance for the help! Sub imagestore() Dim i As Long Dim lastRow...

Hi I have the code below attached to a button in a macro. This is the code in complete and I have been using it to test taking the information from a file on my computer. This works fine, it all plugs in to the right place - no issue. Now that file is on my ftp server which is user and...

Hello all, I am trying to build an Excel VBA command which will automatically do the following things: 1. Import a list from another excel wordbook in an already made excel spreadsheet where items will be matched to the corresponding column (i.e. identify address, postal code etc and...

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 would like to click a macro button and download an xlsx file as new sheets on my current excel file The link: http://us.spindices.com/documents/additional-material/sp-500-eps-est.xlsx?force_download=true It has multiple sheets and I would like for the vba to add those sheets onto my current...