Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. VBA for SAP to get file name in ME53N

    Hello guys,

    I need my macro to open the Attachment Files button inside a Purchase Requisition and tell me the file name attached.

    I was able just to get the "PDF" text, but not the name itself....
  2. VBA to check for PR SAP attachment

    Sub teste()

    Set SapGuiAuto = GetObject("SAPGUI")
    Set SAPApplication = SapGuiAuto.GetScriptingEngine
    Set SAPConnection = SAPApplication.Children(0)
    Set session =...
  3. Re: VBA to check SAP Purchase Requisition attachments for Service

    Anyone?
  4. Re: VBA to check SAP Purchase Requisition attachments for Service

    I need to check if "Attachment List" is enabled or not:


    https://blogs.sap.com/wp-content/uploads/2012/11/2_158403.jpg

    I have tried all I know but nothing so far worked...
  5. VBA to check SAP Purchase Requisition attachments for Service

    Guys, I am struggling with this....

    I am trying to check if there are attachments in PR for service, but I can only check if my macro click to open the attachment table. In some cases, when there...
  6. Replies
    10
    Views
    246

    Re: Save PDF to a folder using VBA

    There is no option for solved, that option does not appear to me...
  7. Workbook won't open from SAP unless macro stops

    Hello!!

    I am really having trouble with this issue here.

    This is my code:


    Sub sap_attachment_2()
    'anexos na lista de anexos
  8. Replies
    10
    Views
    246

    Re: Save PDF to a folder using VBA

    Sorry, bu I don't know how to mark as solved.
  9. Replies
    10
    Views
    246

    Re: Save PDF to a folder using VBA

    I managed to do what i wanted.

    First, I get the hwnd name and then move the pdf file to my folder.

    Here I get the pdf filename:

    Public Function getNameFromHwnd(hwnd As Long) As String
    Dim...
  10. Replies
    10
    Views
    246

    Re: Save PDF to a folder using VBA

    Yes. My file is in SAP, I double-click to open the PDF file with Adobe Reader. I Have already managed to move the file from Temp to my folder, but now I would like also to close the PDF file, Idk if...
  11. Replies
    10
    Views
    246

    Re: Save PDF to a folder using VBA

    The file stays in "C:\Temp", I need to save to another folder
  12. Replies
    10
    Views
    246

    Save PDF to a folder using VBA

    Hello guys,

    I tried to search about this around here, but couldn't find anything.

    I have downloaded a PDF file from SAP, and I just need to save the PDF to a specific folder in my computer....
  13. Running VBA macro with SAP while windows user is locked

    Hello everyone, i really am struggling with this.

    I made a macro to run before i got to work while my windows user is locked.
    Altought, i noticed the code "selection.copy" is not copying anything...
  14. Auto logon to SAP to run excel macro

    Hello, i run a daily macro to generate some reports using the excel VBA and SAP macro as well.

    I made my macro to run early in the morning without me, but every time i get in my computer there is...
  15. Replies
    22
    Views
    1,222

    Re: count new entries from dates

    That's alright, I managed to do using what you've done.
    Thank you so much!!
  16. Replies
    22
    Views
    1,222

    Re: count new entries from dates

    It worked, although, how can I do the same formula selecting the date from Column "N", returning me 1 for the new values and 0 for not new values?
  17. Replies
    2
    Views
    508

    Re: Excel formula to Power BI DAX

    Sorry, Take a look at this my other thread: https://www.mrexcel.com/forum/excel-questions/1085048-count-new-entries-dates-2.html

    Look at the post #19
  18. Replies
    2
    Views
    508

    Excel formula to Power BI DAX

    Hi everyone,

    I have this formula on Excel and I would like to transform to Power Bi, I have already tried but with no success. Could anyone help me?


    <tbody>
    Formula Excel

    ...
  19. Replies
    22
    Views
    1,222

    Re: count new entries from dates

    Oh my god that worked! You guys are genius!
    I don't know if i have to open a new thread... but I would like also, the same logic, count how many serial numbers I have as output, in other words, how...
  20. Replies
    22
    Views
    1,222

    Re: count new entries from dates

    It didn't worked... when i used big data the value returned was ALL new values EXCEPT the last day using your formula, so, since I have values from 2nd january it counts ALL new values.

    This is...
  21. Replies
    22
    Views
    1,222

    Re: count new entries from dates

    Excel 2013/2016
    <tbody>

    M
    N
    O
    P
    Q
  22. Replies
    22
    Views
    1,222

    Re: count new entries from dates

    The result is correct in post #4 , but in my worksheet there is data from 02/01/2019 to today. Applying your formula, returns the values that weren't NEVER in my sheet but today, but I actually need...
  23. Replies
    22
    Views
    1,222

    Re: count new entries from dates

    Ah okay, i'm sorry.
    It worked, but there is a way to calculate the new values comparing to yesterday? Your formula calculates the new values without comparison.
  24. Replies
    22
    Views
    1,222

    Re: count new entries from dates

    What does the "--" means?
  25. Replies
    22
    Views
    1,222

    Re: count new entries from dates

    Look at this:
    https://ibb.co/7ygRsPX
    https://ibb.co/7ygRsPX
    https://imgur.com/a/e9aOzHv

    I need a formula to count the blue values in the "N" column. A formula to count how many values are new...
Results 1 to 25 of 64
Page 1 of 3 1 2 3