Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.72 seconds.

  1. Re: VBA: Copy data from closed Workbook and paste

    Have a look at the following link...

    https://www.rondebruin.nl/win/s3/win024.htm
  2. Re: VBA: Copy data from closed Workbook and paste

    The following macro opens the source workbook, and then copies the values from the named range to the destination workbook, starting at B2. Change the starting cell as desired. Then, once the...
  3. Replies
    3
    Views
    87

    Re: Find and Replace

    You're very welcome, cheers!
  4. Replies
    3
    Views
    87

    Re: Find and Replace

    Try...


    Dim sinChars As Variant
    sinChars = Array("/", "\", "~*", "[", "]", "~?", ":")

    Dim i As Long
    With Range("B2:B" & lastRow(ActiveSheet))
    For i =...
  5. Replies
    7
    Views
    175

    Re: Copy status value from web page

    Is see that you have this line...


    objIE.document.getElementById("quickSearchTextField").Value = Var

    ...that enters the search term on the page. And then you have this line...


    'wait for...
  6. Replies
    7
    Views
    175

    Re: Copy status value from web page

    Since I don't have access to the website, I'm not sure that I can help. In any case, I would suggest that post the code that you have and I'll have a look, maybe someone else here might be able to...
  7. Re: Trying to use "PageSetup.PaperSize" with a constant not working

    &0 is the prefix for an octal literal. So &43 is automatically converted it to its 3 digit octal literal equivalent, which is &043. For more information regarding literals, have a look at the...
  8. Replies
    7
    Views
    175

    Re: Copy status value from web page

    Are you checking the Busy and readyState properties, something like this?


    Do While objIE.Busy Or objIE.readyState <> 4 'READYSTATE_COMPLETE
    DoEvents
    Loop
  9. Replies
    7
    Views
    175

    Re: Copy status value from web page

    Can you tell us what the problem is?
  10. Re: VBA copy visible cells to email body below text

    Instead of using the SendKeys method, use the WordEditor property of the Inspector object, which returns the Word Document object model...


    With MItem
    .To = "test@email.com"
    .Subject =...
  11. Re: Sumfs does not work when a workbook is closed

    Try...

    =SUMPRODUCT(--('[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$A:$A>='[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$A$1684),--('[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$J:$J=B19))
  12. Re: Sumfs does not work when a workbook is closed

    Here's the English version, which uses the comma as a list separator...

    =SUMPRODUCT(--('C:\Users\ve023g\Desktop\zeid\Zeid Workshop\[Direktgeschäft VU - 2019 NeU.xlsx]Daten...
  13. Replies
    2
    Views
    181

    Re: workbook close not working

    The index for the Workbooks object requires the workbook name only, and should not include the path, try....


    Workbooks(LatestFile).Close False
  14. Replies
    10
    Views
    282

    Re: VBA MkDir Folder

    Hi Pinaceous, try...


    MkDir ThisWorkbook.path & "\" & workbooks(2).Worksheets("Sheet1").range("A77").value & Format(Date, "mm-yy")

    Change the sheet name accordingly.
  15. Replies
    2
    Views
    136

    Re: Not able to submit a HTML form

    Since the button resides within the Forms collection, you'll need to refer to it via the Document property of the Form object...


    htmlDoc.forms(0).Document.querySelector("button[value='Sign...
  16. Re: Sumfs does not work when a workbook is closed

    That's great, I'm glad I could help.

    You too, have a great weekend.

    Cheers!
  17. Re: Sumfs does not work when a workbook is closed

    My version of Excel uses the comma as a list separator, whereas yours uses a semi-colon. Did you replace the commas with semi-colons? Also, did you change SUMPRODUCT to your language version?
  18. Re: Sumfs does not work when a workbook is closed

    Try...

    =SUMPRODUCT('[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$C$2:$C$1703,--('[Direktgeschäft VU - 2019 NeU.xlsx]Daten '!$J$2:$J$1703=B19),--('[Direktgeschäft VU - 2019 NeU.xlsx]Daten...
  19. Re: VBA Save chart as png not saving correctly... Step through and it's working?!?

    Try activating the chart before pasting and exporting...


    With ActiveSheet.ChartObjects.Add( _
    Left:=rSelection.Left, Top:=rSelection.Top, _
    Width:=rSelection.Width + 2,...
  20. Replies
    10
    Views
    282

    Re: VBA MkDir Folder

    Try it like this...


    MkDir ThisWorkbook.path & "\" & Format(Date, "mm-yy")
  21. Re: Email individual worksheet as image in Body of text

    You need to qualify your range reference...


    Set r = ws.Range("B4:J10")
  22. Replies
    2
    Views
    50

    Re: Add Filename to the txt file

    I'm assuming that you want to add the filename on the same line. If so, try...


    Print #1 , Application.UserName, Now, ThisWorkbook.Name

    Hope this helps!
  23. Replies
    4
    Views
    123

    Re: Error: Invalid Picture in Userform

    You're very welcome, cheers!
  24. Replies
    4
    Views
    123

    Re: Error: Invalid Picture in Userform

    Try activating the chart before exporting it. For example, add the following line prior to exporting the image..


    CurrentChart.Parent.activate

    Does this help?
  25. Re: Count the number of lines in an active x textbox?

    The new line character for a textbox is denoted by the constant vbCr or its equivalent value Chr(13). Therefore, we can use the Split function to return an array of lines based on vbCr as the...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4