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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top