User Profile

Collapse

Profile Sidebar

Collapse
Matrix2021
Matrix2021
Last Activity: Feb 5 '21, 04:33 PM
Joined: Jul 16 '20
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Matrix2021
    replied to Copy And Paste 66 Data Using Google Chrome with Macro
    in Access
    Hello NeoPa, Niheel, Rabbit, Twinnyfo & Cactusdata


    Thank you for giving me the opportunity to discussed this thread. "Greatly appreciate it".

    My Challenge was solved.

    A person of the name Narimanych, has helped me in a different forum. Plus they are other recommendation give by him & others.


    Below is the link that solved my problem*.


    ...
    See more | Go to post
    Last edited by NeoPa; Jan 6 '21, 10:22 PM. Reason: Link to Competing Forum Site Removed.

      Leave a comment:

    • Matrix2021
      replied to Copy And Paste 66 Data Using Google Chrome with Macro
      in Access
      Hello NeoPa.

      I am graceful for introducing me to the experts on this post...

      Our misunderstandin g have brought opportunity, which I am most graceful for the comments.

      What's next? To get my hands dirty again and see if Niheel recommendations , can solved my problems. Otherwise, it look like there are no other alternative.

      Thanks for your feedback. Is there any other thing that I need to...
      See more | Go to post

        Leave a comment:

      • Matrix2021
        replied to Copy And Paste 66 Data Using Google Chrome with Macro
        in Access
        Hi Niheel

        Thanks for your reply. You have given me a lot of food, I am not familiar of.

        If you are comfortable, would like to start off by saying your quote: "I am guessing you want the latest prices on the foreign bonds? update in your excel sheet then --> push out to your VBA app?" Yes. You are correct.

        However, I am trouble . I am not sure if you can help me out.
        I have given power...
        See more | Go to post

          Leave a comment:

        • Matrix2021
          replied to Copy And Paste 66 Data Using Google Chrome with Macro
          in Access
          Hello Rabbit "You can automate internet explorer by creating and interacting with the internet explorer object."

          Thanks for your reply. the problem I am facing with internet explorer is this. The site is broken very badly. (Please see photo) apparently it is not compatible.

          Hope I answered the question rightly.

          Thanks for the feed back .
          ...
          See more | Go to post

            Leave a comment:

          • Matrix2021
            replied to Copy And Paste 66 Data Using Google Chrome with Macro
            in Access
            Hello NeoPa,

            I am sorry. You are probably right. I mess-up and if there are no solution, it may make sense the moderators ended my post.

            I have little of excel knowledge. reading different blog posts, watching YouTube and trying to make some sense in what I am doing. I have failed very badly. I am not sure on how to proceed?

            The real problem is. How to create a macro to open google web browser, by opening...
            See more | Go to post

              Leave a comment:

            • Matrix2021
              replied to Copy And Paste 66 Data Using Google Chrome with Macro
              in Access
              That's funny Lol. No problem.

              But hey. My work is real work too... I just pulling our my hair, very busy but going no where to find a way to make this work...

              Running, running working, working and getting no where. How can you help a person like that?
              See more | Go to post

                Leave a comment:

              • Matrix2021
                replied to Copy And Paste 66 Data Using Google Chrome with Macro
                in Access
                Cactusdata. Thanks for your reply.

                Yes, I am sorry... The macro really is unnecessary in having more over as I am requesting.

                And I am not sure if you got the opportunity to view the problem for further analysis. What do you want me to do?
                How can I overcome this problem, if it falls under your expertise.

                Thanks in advance
                See more | Go to post

                  Leave a comment:

                • Matrix2021
                  started a topic Copy And Paste 66 Data Using Google Chrome with Macro
                  in Access

                  Copy And Paste 66 Data Using Google Chrome with Macro

                  Hello Forum.

                  I am wondering, how to modify this code below to suit me needs.

                  Code:
                  Sub EXPORTONGLETS()
'VALID DECLARATION
 Dim NOMFEUILLE As String 'NAME VARIABLE FOR THE HOME TAB
 Dim NBLIGNES As Long ' VARIBLE NUMBER OF LINES PROVIDED IN NEWS
 Dim LADATE As Date ' EXPORT DATE INDICATION
 Dim t$
 
 With Worksheets("News")
 NBLIGNES = .Range("A" &
                  ...
                  See more | Go to post
                  Last edited by Niheel; Jan 4 '21, 12:13 PM.
                  • Matrix2021
                    replied to How to make comparison chart to display two varying sets of data.
                    in Excel
                    SioSio.

                    Hello,

                    The VBA coding is great. You have given me an other way to get similar results and I am thankful for the opportunity.

                    Will chat soon.

                    Thanks for taking the time in helping me move to the next level.

                    Greatly appreciate it.

                    Solve
                    See more | Go to post

                      Leave a comment:

                    • Matrix2021
                      replied to How to make comparison chart to display two varying sets of data.
                      in Excel
                      SioSio. I must say to you again... Thank you for your patience and support.

                      I have followed your instructions and tuition. Please identify below if the code have been plugin into the right location and please view the screen shot of the error and other photos that supports what I am trying to accomplish.

                      Thanks in advance SioSio.







                      Code:
                      Dim SheetA As String
                      ...
                      See more | Go to post

                        Leave a comment:

                      • Matrix2021
                        replied to How to make comparison chart to display two varying sets of data.
                        in Excel
                        SioSio

                        Thanks for your feedback. I greatly appreciate it.
                        I have followed your second comments, but when it comes to the coding. I am not sure if I made a mistake. I have receive an error which states: "Compile error: Invalid qualifier".

                        Please view code and image for a better understanding.

                        Thanks in advance for your swift reply.


                        Code:
                        Private Sub UserForm_Click()
                        ...
                        See more | Go to post

                          Leave a comment:

                        • Matrix2021
                          replied to How to make comparison chart to display two varying sets of data.
                          in Excel
                          Hello SioSio.

                          I am not sure if I can fix this. I am trying my best to follow your teaching. I am not sure what I have done is correct and it seems like I am not getting the results.

                          Please SioSio. If you are willing please let me know as I have place the codes in the files below.

                          Let me know, how to move forward

                          This is a short video that explain my problem: https://drive.google.co m/fil...
                          See more | Go to post

                            Leave a comment:

                          • Matrix2021
                            started a topic How to make comparison chart to display two varying sets of data.
                            in Excel

                            How to make comparison chart to display two varying sets of data.

                            Hello.

                            I am not sure if you can help me. I just don't know...

                            I would love to know, how to make comparison chart to display two varying sets of data.

                            I have two workbooks.

                            One of the workbook have 181 worksheets. "Each worksheet name after a country and have its own data.

                            Next

                            The other workbook have 185 worksheets."Eac h worksheet name after a country...
                            See more | Go to post
                            No activity results to display
                            Show More
                            Working...