Jump to content

XL Report using Active X


Recommended Posts

Attached is an example that does this using report generation toolkit, but does it through ActiveX calls.  I think this needs to be ran on a workbook after all other writing has taken place, because it does it on a per worksheet view.  For me I had N work sheets already made, some with data, and some with charts and graphs, then calling this would set the text and logo to the footer.  Saved in 2015.

 

Footer in Excel.vi

Link to post
Share on other sites

This is also working with my code but the problem is adding Signature line. if I use AddSignatureLine Mehtod then during creation of Excel report, it will open Signature dialog box that is not what i want using ActiveX.

Sign.png

Link to post
Share on other sites

Oh I'm sorry I'm was not familiar with a Signature Line.

One thing that I find useful is to use the Excel feature of recording a Macro, then looking at the generated code, and then translate that into LabVIEW.  The problem is I can't even create a signature line in a footer, in normal Excel.  If I click into the footer, then the Insert >> Text is all greyed out.  Still I enabled a macro recording, then recorded my operations, and added a signature line at a normal place in the worksheet and looked at the generated code and it was the following:

    ActiveWorkbook.Signatures.AddSignatureLine _
        "{00000000-0000-0000-0000-000000000000}"

Not sure what it means but I'm guessing that you can't automate the creation of that signature line using the VBA this way and that it was designed to have a dialog prompt you for the settings for some reason.

Link to post
Share on other sites
22 hours ago, hooovahh said:

 I'm guessing that you can't automate the creation of that signature line using the VBA this way and that it was designed to have a dialog prompt you for the settings for some reason.

Yes, You are right, we are not able to make it fully automate because We can only close pop-up dialog box manually.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Similar Content

    • By Yaw Mensah
      I have installed Labview 2020 on Dedian Buster using the rpm to deb conversion method via alien. Due to Architecture mismatch i deleted the *i386.rpm files before conversion.
      My Problem is that after creating a project at "Build Specification"-> "rigth click" i am only able to select "Source Distribution". Application does not show up as an option. 
      I will be grateful for any suggestions.
      Thank you in advance.
    • By javier_r
      VIPM.io now allows you to post LabVIEW Resources, Ideas, and Tools. For example, you could post a link to a video tutorial or blog article about a package. You can also post ideas, like feature requests or new tools. Best of all, package developers are notified when you post your ideas and resources, and you can comment and discuss posts with the community. Take a look at this video to learn more: https://www.vipm.io/posts/664960df-f111-4e13-989a-24be8207182d/

    • By Shuvankar Das
      I want to connect My ccd camera with labview. The details of my system is given bellow. I cannot connect it please help   OS:  WINDOWS 7, 64bit   LabView Run-Time 2013(64-bit) NI-IMAQ 4.8 NI-IMAQdx 4.3   Camera: QICAM Monochrome Cooled (QIC-F-M-12-C) Model QICAM Resolution 1392 x 1040 Sensor 1/2" Sony ICX205 progressive-scan interline CCD Pixel Size 4.65 x 4.65µm Cooling Type Peltier thermoelectric cooling to 25˚C below ambient Digital Output 12 bit Video Output FireWire (IEEE 1394b) Max. Frame Rate 10 fps full resolution @ 12 bits Pixel Scan 20, 10, 5, 2.5MHz Mount Type C-mount optical format  
       
    • By javier_r
      Hello everybody!
      Wondering how many people have tried the new vipm.io site. We have added a ton of features to make it easy to Discover LabVIEW Tools and there are some cool ones coming soon.
      Check it out and let me know what you think 😀
       
      Javier

    • By DigDoug
      CLA_ATM_QMH_PRACTICE.zipHi Folks,
       
      I'm taking the CLA exam in a few weeks and would like some feedback on the solution I put together (attached). A few specific questions:
      Can I dump tags in the VI Documentation of the VI like I did in Error Handler - Console Error.vi and get credit since there are instructions for developers to complete this work? This would be my strategy if I run out of time. 
      Does this seem like a passing solution? Why/why not?
      Where do you think I would lose the most points in this solution?
      Any other feedback on this exam or general strategy tips are greatly appreciated!
       
      Best Regards,
      Aaron
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.