Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.18 seconds.

  1. Re: How to read gmail inbox without outlook, dll ....

    Cross-posted. Please post the link(s) to your cross-posts on other forums. See forum rule 13 - https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
  2. Re: Is there a way to dynamically continue numbering between tables?

    Welcome to MrExcel forums, but please post links to your cross-post(s). See forum rule 13 - https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

    See if this Worksheet_Change...
  3. Replies
    5
    Views
    43

    Re: VBA to download images and rename

    That URL is not an image.
  4. Re: VBA to save a .XLSM file as two different names in same folder and continue code uninterrupted

    Use SaveCopyAs instead of the first SaveAs and then you don't need the second SaveAs:

    ActiveWorkbook.SaveCopyAs Filename:=ActiveWorkbook.Path & "\Import.xlsm"
  5. Replies
    5
    Views
    43

    Re: VBA to download images and rename

    Give examples of the links (URLs) and file names.
  6. Re: Pull email from specified folder instead of folderpicker

    Add this after the PickFolder line in your original code:

    MsgBox strFolderName.FolderPathand tell me what is displayed in the message box when you run it.

    For example, if...
  7. Replies
    5
    Views
    43

    Re: VBA to download images and rename

    Try adapting the code at https://www.mrexcel.com/forum/excel-questions/1057981-saving-images-urls-within-excel-directory-instead-excel-sheet-post5080413.html#post5080413

    One change, to use the...
  8. Re: Macro for copying and pasting charts from Excel into Word

    Welcome to MrExcel forums.

    I can't read your code so started from scratch. For the code below, you need to set a reference to Microsoft Word Object Library, via Tools -> References in the Excel...
  9. Re: Duplicate Attachment when Sending Email using Gmail in Excel VBA

    Try adding, immediately after the first NewMail.Send:

    <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit;...
  10. Re: Help exporting excel data to word and attaching to email as PDF

    https://www.mrexcel.com/forum/excel-questions/1008938-saveas-pdf-excel-vba-post4842977.html#post4842977 shows how to save (export) an open Word document as a PDF file.

    There are many examples on...
  11. Re: Pull email from specified folder instead of folderpicker

    Does https://www.mrexcel.com/forum/excel-questions/1103379-using-excel-vba-count-mails-outlook-post5306340.html#post5306340 help?
  12. Re: Export Excel CSV to MS word with specific table format

    The .Cell syntax is .Cell(row, column). Add the numbers and variables either side of the comma to determine which row or cell they are referencing. When a Cell is Split, the number of rows in the...
  13. Re: MSXML2.serverXMLHTTP : Adding Authentication + getting JSON

    Prepend the value with an apostrophe or set the cell's format to text:

    Range("C2").Value = "'" & Json("Index")(1)("Name")(2)("Result")

    'or
    Range("C2").NumberFormat = "@"
    Range("C2").Value =...
  14. Replies
    8
    Views
    195

    Re: Help with for loop macro between workbooks

    You should really change the code to make it suit your data rather than the other way around. I used Sheet1 in the code because you said that was the name of both sheets. It is easy to change the...
  15. Replies
    2
    Views
    63

    Re: Macro to sort worksheets

    Try this macro:

    Public Sub Sort_Sheets_In_2_Groups()

    Dim i As Long
    Dim group1Names() As String, group2Names() As String
    Dim n1 As Long, n2 As Long

    n1 = 0: n2 = 0
  16. Re: Transfer Excel data to MS Word Text FormField VBA Code

    Once you've inserted your text form fields (legacy forms) in the document, with the same names as the bookmarks, you would have to replace the With myDoc.Bookmarks ... End With block with something...
  17. Replies
    3
    Views
    66

    Re: Add date to existing output of pdf file

    '/' is invalid in file names, so you could have this:

    strFileName = "C:\Users\Ian\Desktop\REMOTES ETC\DR COPY INVOICES\" & Range("N4").Value & Format(Date, "_dd-mm-yyyy") & ".pdf"
  18. Replies
    8
    Views
    195

    Re: Help with for loop macro between workbooks

    I just tested the code with "ASIN to LD.xlsx" hidden and it still works :)
  19. Replies
    8
    Views
    195

    Re: Help with for loop macro between workbooks

    Put this code in a standard module in a new workbook and save it as macro-enabled workbook (.xlsm or .xlsb file).

    With your 'ActiveWorkbook' and 'ASIN to LD.xlsx' workbooks open and the macro...
  20. Replies
    2
    Views
    42

    Re: How to Click 'Yes' to Downloading a File

    See https://www.mrexcel.com/forum/general-excel-discussion-other-questions/1086615-using-uiautomationclient-automate-save-file-download-ie11.html
  21. Replies
    10
    Views
    193

    Re: How to click hyperlink on webpage

    Try adding this to your code. It uses HTML library data types, so you must set a reference to MS HTML Object Library, via Tools -> References in the VBA editor.

    Dim HTMLdoc As HTMLDocument
    ...
  22. Re: Macro to cycle through dropdown, paste output to tab by grouping

    What type of dropdown is it - a data validation in-cell dropdown, a combo box form control, or something else? The code to loop through the dropdown values is dfferent depending on the type.

    For...
  23. Replies
    3
    Views
    98

    Re: VBA Macro for ontime start and end time

    See https://www.mrexcel.com/forum/excel-questions/377011-ontime-end-time.html
  24. Replies
    2
    Views
    102

    Re: Losing Table theme in RangetoHTML VBA

    Try changing:

    .Cells(1).PasteSpecial Paste:=8
    .Cells(1).PasteSpecial xlPasteValues, , False, False
    .Cells(1).PasteSpecial xlPasteFormats, , False, Falseto simply:

    ...
  25. Re: Import multiple pages of txt file and format

    Try starting with the macro at https://www.mrexcel.com/forum/excel-questions/971331-request-vba-code-importing-multiple-tab-delineated-txt-files-into-excel-2010-a-post4662237.html#post4662237. It...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4