downloaded

  1. M

    How to download a ZIP file and access its contents while on MAC.

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

    Gardening - Vegitables

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

    Workbooks.Count problem

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

    Chart with reference (name manager) does not work

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

    .pattern question

    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})...
  6. cnestg8r

    Help with HTML Maker

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

    Using UIAutomationClient to automate the Save As file download in IE11

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

    Formula error

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

    Get Data ?

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

    Missing Contents/ worksheets necessary for Chapter 4 of Excel2016 Pivot Table Data Crunching

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

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