tag:blogger.com,1999:blog-28492262.post9021318516896823420..comments2023-12-27T22:22:25.151-08:00Comments on VBA Tips & Tricks: Excel VBA - install an Excel Add-in (XLA or XLL)Unknownnoreply@blogger.comBlogger8125tag:blogger.com,1999:blog-28492262.post-40327884555710676792019-11-22T20:12:26.585-08:002019-11-22T20:12:26.585-08:00At the end of 2019, this post really helped me out...At the end of 2019, this post really helped me out. After hours of flailing about to get a one click install of an addin(.xlam), I finally landed here and was saved by the temp workbook idea. Thanks for sharing.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-53087010756673913702012-07-11T07:35:52.723-07:002012-07-11T07:35:52.723-07:00What do you do when you have added the Addin, it s...What do you do when you have added the Addin, it shows up in your Addin list, but it fails when you try to set Installed = True. I can get it to work on my computer and one other, but some computers it fails on. I've messed around with all of the security settings, set them the same as what is working to see if one of them might be preventing it and it still fails.Keithnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-38073977543380157662012-05-11T23:13:11.954-07:002012-05-11T23:13:11.954-07:00In Visual Basic you need to add a reference to Mic...In Visual Basic you need to add a reference to Microsoft Excel Object Library and then use the following code<br /><br />Set oXL = New Excel.Application<br />oXL.Visible = TrueM Shasurhttps://www.blogger.com/profile/17390752937266096344noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-74159198301614472092012-05-10T07:06:25.943-07:002012-05-10T07:06:25.943-07:00Hi our application written in vb, report writer is...Hi our application written in vb, report writer is crystal report, using SQL 2005, I am looking solution how to open excel from my application directly, how do I do the add in ?<br /><br />Any expert here ?Viviennahttps://www.blogger.com/profile/17123277935081988622noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-17333041840988728642010-01-15T22:26:07.467-08:002010-01-15T22:26:07.467-08:00Thanks Robb.
The code could execute without oXL. ...Thanks Robb.<br /><br />The code could execute without oXL. I have modified it accordinglyM Shasurhttps://www.blogger.com/profile/17390752937266096344noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-67278241665657236802010-01-05T06:16:26.979-08:002010-01-05T06:16:26.979-08:00I don't think you defined oXL in your code.I don't think you defined oXL in your code.Robbnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-14610839941326275282009-02-01T07:10:00.000-08:002009-02-01T07:10:00.000-08:00Did you mean that the Commandbars/Menu bar is not ...Did you mean that the Commandbars/Menu bar is not loaded?M Shasurhttps://www.blogger.com/profile/17390752937266096344noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-29272931362820201832009-01-22T07:03:00.000-08:002009-01-22T07:03:00.000-08:00i have a file that i use in my old computer, now h...i have a file that i use in my old computer, now have a windows xp with office 2007 the file is xla. file but when i instaled it excel could not fin it , can you tell me how to install it???Anonymousnoreply@blogger.com