downloaded

I'm aware that I can use activedocument.follow hyperlink to download a file given a URL, but I'm unsure of how to interact with that file after it has been downloaded. Is it possible to rename the file upon download or specify where the file is downloaded to using VBA? Furthermore, how can I go...

Can anyone direct me to a place where ready made spreadsheets / templates can be downloaded I am at the moment looking for an organizer for growing Vegitables ? Thankyou

I use Workbooks.Count to enable to Set a name to a new download. When the download is a .csv file there used to be no problem. However, in the last week (I have Excel 365, so it may have changed) a newly downloaded file of the generic ".csv" type does not get included in the Workbooks.Count...

Hi all, I try to understand why when I create a graph, for the series value and I put the formula ='VBA1.xlsx'!value With VBA1 the name of the workbook and ''value'' that refers to a formula in the name manager of EXCEL Why it works for a workbook I have downloaded from Internet, and why...

I am trying to find text pattern from String. pattern I am looking for is 6 digit dot 7 digit ex: 123456.1234567 can someone build me needed code for above pattern? explaining how code would be appreciated. I downloaded 5 digit number code from www it reads .Patern = "(?:^|\D) (\d{5})...

I have used the html addin sporadically over 14 year membership. For some reason, my thread is shown in the ribbon tabs, but doesn't work. When I look at the option/addins, I don't find it. I've downloaded the newest version and tried to install, but I get no improvement. Any ideas would be...

Here is VBA code which automates the complete 'Save As' file download procedure in IE11, when a download is offered by IE's Download Notification Bar. To use for your own web site downloads you would automate IE and do whatever is necessary to make the Download Notification Bar appear at the...

Last year I created a spreadsheet with the following formula: =IF(ISBLANK(B20),"",B20*$E$9) entered under the services NOTE cell E9 = 600 <tbody> Qty Service Expenses Total 1 600 20 620 </tbody> =IF(OR(ISBLANK(B20)),"",(D20+E20)) entered under Total OK this has worked until I upgraded...

I have a spreadsheet which I update weekly from an access database table. The table has about 25 columns of which I only need about 8. On initial set-up all the columns are downloaded and the ones not required are deleted. Previously excel has only downloaded the required columns on refresh...

I bought Excel2016 Pivot Table Data Crunching, to try to master everything about the Pivot Table. I am following every chapter, using the downloaded workbook. But when I came to Chapter 4, I can't find any necessary worksheet to work with The downloaded worksheet for Chapter 4 contains only 3...