Search:

Type: Posts; User: John_w; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.27 seconds.

  1. Re: Trying to reverse arrow head shape in diagram

    Welcome to MrExcel. I think you just need to select each shape:

    Sub reversearrows()

    Dim sh As Shape

    For Each sh In ActiveSheet.Shapes
    If sh.Type = msoLine Then
    ...
  2. Replies
    4
    Views
    104

    Re: Check status of current filter mode

    I'm not sure how well this code will work with your data and filters (AutoFilter, not Advanced Filter). I've tested it on a few simple AutoFilters and it works for me.

    There are 2 routines:...
  3. Replies
    33
    Views
    600

    Re: Need help with Get External Data (long shot question!)

    The main disadvantage of a macro-enabled workbook is that any macros (including Workbook_Open) won't run unless the user enables them. The enabling of macros is done either in the macro security...
  4. Replies
    33
    Views
    600

    Re: Need help with Get External Data (long shot question!)

    Yes, simply paste my code into modules, as previously described, in your workbook. I have slightly changed the code so that it operates on your "tax_credits_web" sheet, rather than the active sheet,...
  5. Replies
    33
    Views
    600

    Re: Need help with Get External Data (long shot question!)

    No, I do mean a new workbook, to keep it separate from my first attempt.

    The first routine (starting Public Sub Get_Tax_Credits) should be pasted into a new standard module (also called a regular...
  6. Re: Export excel sheet as PDF to an existing folder

    I tried Leith's code with a picture on Sheet3 and the picture is saved in the PDF file.
  7. Re: Prevent deletion of last row of excel table

    Sorry, but preventing deletion of the Total Row completely escaped me. The fix is to lock the entire row in which the Total Row occurs.


    Public Sub Lock_Table_Header_and_Total_Rows()

    Dim...
  8. Replies
    33
    Views
    600

    Re: Need help with Get External Data (long shot question!)

    Yes, it is possible to automate this with no manual intervention or having to put the required year in a cell - my first solution was just to show that the correct web page data is imported for the...
  9. Replies
    33
    Views
    600

    Re: Need help with Get External Data (long shot question!)

    It sounds like you're not using the macro correctly - you shouldn't be 'refreshing', the macro imports the web site table from:


    https://www.taxtips.ca/nrcredits/tax-credits-XXXX-base.htmwhere...
  10. Replies
    33
    Views
    600

    Re: Need help with Get External Data (long shot question!)

    Try this macro. It runs a web query to import the data for the specified year (in B1 on the active sheet, so no need to change your computer's date) starting at A3.


    Public Sub Get_Tax_Credits()...
  11. Re: Prevent deletion of last row of excel table

    I'm unable to reproduce the problem - for me, the table's Total Row can't be deleted. Remember, the code is referencing the first table on the active sheet.

    Do any errors occur? If so, what is...
  12. Re: Prevent deletion of last row of excel table

    A possible solution is to lock the table's Header row and Total row and protect the sheet but allow users to insert and delete rows.

    This macro does this on the first table in the active sheet,...
  13. Replies
    26
    Views
    26,027

    Re: Convert String to MD5 Hash

    I'm also using Excel 2016 32-bit and get the same results as you. The problem is that the StrConv function is unable to convert all Unicode characters to UTF-8 encoded bytes. There is a good...
  14. Replies
    4
    Views
    124

    Re: Remove empty rows from .txt file

    You're correct about changing those two variables to Object to fix the errors. I inadvertently left them as early-bound data types, which require a reference to MS Scripting Runtime.

    Try this...
  15. Replies
    4
    Views
    124

    Re: Remove empty rows from .txt file

    A different approach is needed - use FileSystemObject to create the text files from the arrays.


    Sub Split1536Loop()

    Dim Wb As Workbook
    Dim FileNameExt As Variant
    Dim...
  16. Replies
    3
    Views
    127

    Re: Advanced filter from another workbook

    Yes, try using the Sharepoint path, although I've never used Sharepoint so don't know if it will work.

    As a test, have both files on your local drive and see if the time taken to open the Project...
  17. Replies
    3
    Views
    127

    Re: Advanced filter from another workbook

    The simplest solution is to open the Project Log workbook momentarily and do the advanced filter on the required sheet (here named "Data Sheet") in that workbook:

    Private Sub...
  18. Re: Drag-down VBA function (many sheets) snag

    Your code looks OK - which line causes the error? Click Debug on the error message and the errant line is highlighted in yellow. (BTW it's easier for people helping you to put the complete error...
  19. Replies
    1
    Views
    84

    Re: PDF Manipulation in VBA

    The code at https://www.mrexcel.com/forum/excel-questions/979092-extract-page-pdf-based-selected-keywords-excel.html shows how to delete pages in a PDF file using the Acrobat API - the DeletePages...
  20. Re: Export excel sheet as PDF to an existing folder

    From your description and 'reading between the lines' because your description is a little ambiguous, my understanding is that your main folder is "C:\Users\SSF1590\Desktop\TARA Project\Folders" and...
  21. Re: Copy worksheets to new workbook, delete connections, then save new workbook

    This macro copies the two worksheets named "Sheet1" and "Sheet2" to a new workbook and then deletes workbook connections, workbook queries and Excel links in the new workbook. The new workbook is...
  22. Re: Excel VBA - Export the same range changed by a function to a PDF file

    My code copies the cell values and formats for the specified range to the temporary sheet, so the temporary sheet and therefore the PDF should look exactly like the range on the original source...
  23. Re: Upgraded to 2016: Graphs are no longer animated running VBA

    Try activating the chart object:

    ActiveSheet.ChartObjects("Chart 1").Activate
  24. Re: Excel VBA - Export the same range changed by a function to a PDF file

    Try this macro, which adds a temporary sheet and copies A1:D5 to the next row, three times. It also puts a page break between each block of cells. Just change the PDFFullName string value to the...
  25. Re: How to publish as web page with relative path

    As you have multiple publish objects we need to loop through them and change the filename property to the current folder.

    Private Sub Workbook_Open()

    Dim po As PublishObject
    Dim p As...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4