Installshield To Install Add-in
Sep 14, 2007Has anyone ever used InstallShield to install an Excel Add-In?
View 2 Replies
ADVERTISEMENT
Macro To Install Add-ins
Sep 14, 2006I am running a fairly complex simulation at work and have quite a few different functions in it. For the simulation to work properly, i need to have the Solver add-in and the Analysis ToolPak installed. Everytime that i try and use the simulation on a different computer (or if anyone else tries to run it) the add-ins must be enabled again. Is there a way to set up a macro to enable them when either i open the simulation (first preference) or when a button is pressed (2nd preference).
View 5 Replies View RelatedUse VBA To Install Excel Reference
Nov 7, 2011I was wondering if there was a way to use the Workbook_Open() event in Excel to install specific references. I tried to record a macro, and then open the VBA editor and then see what code it showed to install, but there was no code in the macro
I tried:
Code:
With Workbook.reference
.AddFromFile "C:WINDOWSsytem32.stdole2.tlb"
End With
Which is just giving the location of the reference I want to install, and It gives a debug error of Run Time Error 424 Object Required
Use VBA To Install Analysis ToolPak Add In
Feb 23, 2007I found this code in the posts to automatically install the Analysis ToolPak at Open.
Private Sub Workbook_Open()
AddIns("Analysis ToolPak").Installed = True
End Sub
I tried this in the workbook module but it doesn't seem to work. Is this code correct or have I done something incorrectly?
Also, are there any drawbacks to an automatic install of an add in like this and if it runs the code every time the workbook opens, is there any performance issues (maybe only opens a bit slower)?
Install Network Printer Via VBA
Jul 26, 2007I have a new workbook that needs to be printed to a specific printer regardless of who the user is. I am happy with the method used for doing this using the PrintOut function, but am trying to work out what to do in the event that the user does not have this printer installed. The logic, not in true VBA syntax, is as follows;
' Check Printer
If <This Printer> Is installed Then
Printout using <This Printer>
Else
Install <This Printer>
Printout using <This Printer>
I found a useful post about ascertaining whether or not a printer is installed, but can't find anything about actually installing a printer via VBA.
Install 2000 On A System Running 2007
Jun 6, 2009I am running Excel 2007 on my Windows Vista laptop. A workbook I've developed in Excel 2007 (compatibility mode) on my Windows Vista laptop has a macro that runs as expected on my laptop but will not run on my desktop which is running Windows 2000, Excel 2000.
I've addressed this question previously under the thread "Macro Bombs Excel 2000". I've not received a response as to why it won't run under Windows 2000, Excel 2000. I don't know if it's an Operating System issue or an Excel 2000 issue.
I'm developing this workbook for my children for their personal financial management. I'd like to determine if this is an Excel 2000 issue or an Operating System issue. Most of my children run Windows XP, Office 2000. I have a dual system on my laptop (Vista and XP).
I have a legal software license available for Office 2000. My question is, can I load Excel 2000 on my Vista, Office 2007 laptop. I've looked at http://support.microsoft.com/kb/218861/ and they talk about installing oldest versions first. I have Excel 2007 already installed. I don't particularly want to uninstall it. Can I install Excel 2000 without uninstalling Excel 2007?
1. Can it be done?
2. Can it be done without MAJOR operational issues.
3. What is the process?
4. Can I load ONLY Excel 2000?
Retrieve Windows Install Date From Registry?
Mar 23, 2014how to retrieve Install date of Windows from registry (or form any where else). I know this date is saved in key "HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionInstallDate", I used RegRead but it return "0" (zero)
View 6 Replies View RelatedCreating A Custom Button When I Install My Self-made Add-in
Apr 16, 2006Finally after 3 days of intensive studying VBA, my first add-in pack is ready to be installed in the office. I've got my custom form all ready, now all I need is to have excel create a custom button on the toolbar that calls up my custom form when clicked.
The idea of assigning a shortcut key doesn't really appeal to me. I'll be packaging it up in .xla format. Would be greatful if anyone can direct me on how to add a button to call up my form (only one form in fact).
Looping- Loop To Force A New Date Install Via A Input Box
Jan 7, 2010The code below first asks a user to input a weekending date (which must be a Saturday). The value of the input box goes to cell C1 of my spreadsheet. That part works fine. I also have a function in Cell G1 with the function:
=TEXT(C1, "dddd")
I don't know if this is the best way to test for a Saturday but it is what I have,
Where is goes bad is if the date is not a Saturday. I have a loop to force a new date install via a input box but it won't update C1 with the inputed data to recheck for the Saturday value. Below is the whole code I am working with...
Dim aa As String
Dim bb As String
If Range("C1") = "" Then
Do While bb = ""
bb = InputBox("Please Enter a Weekending Date!")
Loop
Range("C1").Value = bb
End If
If Range("G1") "Saturday" Then
Do While aa "Saturday"
aa = InputBox("Weekending Must Be a Saturday. Please Enter a New Weekending Date")
Loop
Range("C1").Value = aa
End If
Email A File To Install A Macro, Toolbar & Button To A User. Re-explained In Post 19
Feb 17, 2009I have finally come up with a macro and would like to install it to around 10 people's "Personal Workbook" in my department. Let me explain a bit further...
We use web-based software which has an "Export to Excel" option which we all use. The resulting data populates into a spreadsheet automatically.
I would like the user to be able to click on Tools/Macro/Run Macro and then run that particular macro. I assume that this macro should be in the "Personal Workbook" so that the macro will be visible no matter what worksheet they may have open?
Can this be done automatically/with a macro or must this be manually done?
I"m using Excel 2003.
Macro To Install A Macro?
Mar 26, 2014running one excel macro that will in turn install another macro(s) on the users machine. A macro to install a macro.
View 2 Replies View Related