Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. How to use OLE Automation in my application?

How to use OLE Automation in my application?

Scheduled Pinned Locked Moved The Lounge
comtestingtoolstutorial
10 Posts 9 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • B Offline
    B Offline
    Behzad Sedighzadeh
    wrote on last edited by
    #1

    Hi, Our clients has asked us to be able use VBA in our application.Does anybody has an experience with this kind of task? Can you suggest any good resource to start with? Thanks, Behzad

    Behzad

    C P D R 4 Replies Last reply
    0
    • B Behzad Sedighzadeh

      Hi, Our clients has asked us to be able use VBA in our application.Does anybody has an experience with this kind of task? Can you suggest any good resource to start with? Thanks, Behzad

      Behzad

      C Offline
      C Offline
      Christian Graus
      wrote on last edited by
      #2

      You have a paid client, but you can't read ? I would suggest that real programmers know their stuff enough to tell a client they are wrong when they ask for something that is stupid. It's hard to know if it's stupid in this case, based on what you said, but it's clear that if it IS a stupid request, you'd have no way of knowing, because you have no idea about VBA, it seems. It also seems you can't follow simple instructions, such as 'please do not post programming questions in the lounge', as you have done, despite being asked not to. Luckily, I expect many VBA books tend to use small words and have pretty pictures.

      Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

      L M 2 Replies Last reply
      0
      • B Behzad Sedighzadeh

        Hi, Our clients has asked us to be able use VBA in our application.Does anybody has an experience with this kind of task? Can you suggest any good resource to start with? Thanks, Behzad

        Behzad

        P Offline
        P Offline
        PIEBALDconsult
        wrote on last edited by
        #3

        Behzad Sedighzadeh wrote:

        experience with this kind of task?

        The task of telling someone to stuff it?

        1 Reply Last reply
        0
        • C Christian Graus

          You have a paid client, but you can't read ? I would suggest that real programmers know their stuff enough to tell a client they are wrong when they ask for something that is stupid. It's hard to know if it's stupid in this case, based on what you said, but it's clear that if it IS a stupid request, you'd have no way of knowing, because you have no idea about VBA, it seems. It also seems you can't follow simple instructions, such as 'please do not post programming questions in the lounge', as you have done, despite being asked not to. Luckily, I expect many VBA books tend to use small words and have pretty pictures.

          Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

          L Offline
          L Offline
          Luc Pattyn
          wrote on last edited by
          #4

          I'd love to see histograms on the number of syllables in the words of a language vocabulary, for different human languages. Could be quite interesting. :)

          Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]


          I only read formatted code with indentation, so please use PRE tags for code snippets.


          I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).


          1 Reply Last reply
          0
          • B Behzad Sedighzadeh

            Hi, Our clients has asked us to be able use VBA in our application.Does anybody has an experience with this kind of task? Can you suggest any good resource to start with? Thanks, Behzad

            Behzad

            D Offline
            D Offline
            Dave Parker
            wrote on last edited by
            #5

            What is the application developed in - is this .NET or is it some legacy VB6 app or something? It would probably be better to go with something more .NETty anyway, VBA is kinda dead. I'm not even sure it's possible to incorporate VBA into your own application, it might be limited to just Office. VBS is possible but is pretty outdated.

            B 1 Reply Last reply
            0
            • C Christian Graus

              You have a paid client, but you can't read ? I would suggest that real programmers know their stuff enough to tell a client they are wrong when they ask for something that is stupid. It's hard to know if it's stupid in this case, based on what you said, but it's clear that if it IS a stupid request, you'd have no way of knowing, because you have no idea about VBA, it seems. It also seems you can't follow simple instructions, such as 'please do not post programming questions in the lounge', as you have done, despite being asked not to. Luckily, I expect many VBA books tend to use small words and have pretty pictures.

              Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

              M Offline
              M Offline
              mattiek77
              wrote on last edited by
              #6

              Ouchc

              1 Reply Last reply
              0
              • D Dave Parker

                What is the application developed in - is this .NET or is it some legacy VB6 app or something? It would probably be better to go with something more .NETty anyway, VBA is kinda dead. I'm not even sure it's possible to incorporate VBA into your own application, it might be limited to just Office. VBS is possible but is pretty outdated.

                B Offline
                B Offline
                Behzad Sedighzadeh
                wrote on last edited by
                #7

                I know VBA is outdated but this is the only programming language our clients prefer to write code with.And when most of them ask you to do that, it becomes priority. BTW, our application is .netty! Thanks

                Behzad

                M 1 Reply Last reply
                0
                • B Behzad Sedighzadeh

                  I know VBA is outdated but this is the only programming language our clients prefer to write code with.And when most of them ask you to do that, it becomes priority. BTW, our application is .netty! Thanks

                  Behzad

                  M Offline
                  M Offline
                  Mark_Wallace
                  wrote on last edited by
                  #8

                  So what exactly do they want to do? If it's just a matter of extracting data from your datastore to display/play with it in MS Office (pre 2007), then all they need is a few hooks. Ask in the Visual Basic message board, where there will be people who know about this kind of thing. Asking in the Lounge is a bad idea, because it will annoy people who come to the lounge to get away from such questions.

                  I wanna be a eunuchs developer! Pass me a bread knife!

                  1 Reply Last reply
                  0
                  • B Behzad Sedighzadeh

                    Hi, Our clients has asked us to be able use VBA in our application.Does anybody has an experience with this kind of task? Can you suggest any good resource to start with? Thanks, Behzad

                    Behzad

                    R Offline
                    R Offline
                    realJSOP
                    wrote on last edited by
                    #9

                    A hamlet is a village without a church and a town is not a city until it has a cathedral.

                    .45 ACP - because shooting twice is just silly
                    -----
                    "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                    -----
                    "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

                    P 1 Reply Last reply
                    0
                    • R realJSOP

                      A hamlet is a village without a church and a town is not a city until it has a cathedral.

                      .45 ACP - because shooting twice is just silly
                      -----
                      "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                      -----
                      "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

                      P Offline
                      P Offline
                      Pete OHanlon
                      wrote on last edited by
                      #10

                      John Simmons / outlaw programmer wrote:

                      a town is not a city until it has a cathedral

                      Here in the UK, that's not the case any more. City Status is an honour granted by the monarch on the advice of the Lord Chancellor by letters patent (an open letter, not a charter) normally on special royal occasions. There is no set criteria as in other countries such as the US.

                      "WPF has many lovers. It's a veritable porn star!" - Josh Smith

                      As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

                      My blog | My articles | MoXAML PowerToys | Onyx

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups