I want to run an .exe program from Excel, so I used the shell method. This program should read in some input in text format. However, when I call from Excel, the prgram cannot read the input. When I run the program alone, it is OK.
View 6 RepliesI have a work book with 3 sheets. Sheet 1 is the main sheet and sheets 2 and 3 will use (I hope vlookup) to update 3 columns from info in sheet 1. my attempt at a vlookup call in sheet 2 is: =VLOOKUP($b3,[master_AoJ_2.xls]Sheet1!$B$3;$B$65,false)
my understanding is that: - $b3 is the cell in sheet 2 that will be updated as a result of the vlookup call. - [master_AoJ_2.xls]Sheet1!$B$3;$B$65 refers to range $B$3:$B$65 on sheet1 of master_AoJ_2. it does not work... infact I get nothing at all. when I type the call into cell $b3 of sheet2 excel thinks it is stariaght text. this is how I coded the function call =VLOOKUP($b3,[master_AoJ_2.xls]Sheet1!$B$3;$B$65,false)
I am using a user Form in excel VB
I have a bunch of text boxes on another form. What set of text boxes i use depend on what illertation I am on, "counter". I am calling the sub which uses the "Select Case" code to figure out which textbox to use.
When I run it, it reaches the call, goes into the sub, and when it exits the sub it screws up. It says "Type miss match"
Intresting note, if you click play again, it works right away untill it runs another illertation through and gets back to that spot.
In the call function in the code below, all variables have Nothing in them when I put my mouse over them in debug. When I say nothing it actually says like textboxy = Nothing
counter has 1 to start.
Here is my code
Call subcase(textboxy, textboxM, textboxMa, textboxw, textboxd, checkboxx, counter)
and here is the sub! thanks again!
Sub subcase(textboxy, textboxM, textboxMa, textboxw, textboxd, checkboxx, counter)
Select Case counter
Case 1
Set textboxy = frmNewItemMore.txtYear1
Set textboxM = frmNewItemMore.txtMonth1
Set textboxw = frmNewItemMore.txtweek1
Set textboxd = frmNewItemMore.txtDay1
Set textboxMa = frmNewItemMore.txtPM1
Set checkboxx = frmNewItemMore.chk1
I can protect my all sheet in excel but How to protect single cell or column, row? Is there any code for protect.
View 14 Replies View RelatedI have UDF and would like to use a Macro Button to have it run whenever I need to. Now I have to disable macros with notification in trust center and after entering data, enable content. I have my UDF in a module, is it possible to have another module with a macro so I can run this UDF whenever I need to?
[Code] .....
Just wonder how to call the function if I have it's name in the variable String
for example something like that:
I've heard of calling a sub with arguments but don't believe I'd done it in the past. I want to remove the empty rows in 3 worksheets so that my row count actually stops where the existing data does. The second sub is where that takes place. What is the best way to call the sub to execute on the three sheets?
My thinking had been that if I used the argument ws as worksheet I could simply call the sub with the worksheet name as the argument.
Code:
Option Explicit
Sub PopulateProfit()
Dim wb As ThisWorkbook
'Dim ws As Worksheet
Dim wsProfRep As Worksheet
Dim wsChaseRaw As Worksheet
[Code] ..........
I wrote a function procedure in VBA. Pasted it into a 'VBAProject' sheet in my workbook. But when I try to call the function (by entering the name and arguments into a cell), the sheet displays "#NAME?".
What have I forgotten?
example:
Public Function TotDays( _EndDate As Date, _StartDate As Date _) As Integer
TotDays = EndDate - StartDate
End Function
cell
a5: =totdays(b2,A2)
b2: 4/1/2007
a2: 3/1/2007
I created a file with one sub and one function. Saved it as an add-in. and followed the promts to insert the Add-in.
The button I assigned to the macro works fine, but when I call the function, I am told "Sub or Function not defined".
Is there some special way to call an add-in function from VB?
I have three macro's.
1) Execute
2) CreateMatrix
3) CollectDebtCount
What I want to do is have the macro called Execute call up and trigger CollectDebtCount macro and CreateMatrix macro.
My problem is the value to limit the For/Next block in CreateMatrix is not using the value generated by the CollectDebtCount.
An example of the output is as follows: If the user enters the number 3 to the question "How many different type of debt do you own?", then the macro CreateMatrix should generate the list starting in cell A2, the value = 1, then in cell A3, value = 2, and in cell A4, value = 3.
Sub CollectDebtCount()
Dim Question
Question = InputBox("How many different type of debt do you own?")
Trim Question
End Sub
Sub CreateMatrix()
J = 2
I = 1
Dim Count
For Count = 1 To Question
Cells(J, I).FormulaR1C1 = Count
Count = Count + 1
Next.......................................
How to call another program from excel using VBA, then excetue commands within it.
All the commands are text based, and the program will respond to it, but i am not sure how to automate this.
Is there and API call I can do to determine a user's default add-in folder for Excel add-in ?
View 9 Replies View RelatedI have a userform in an add-in (which is loaded), when I try and call it from an excel sheet, I get the following error "Variable not defined"
Private Sub CommandButton3_Click()
UserForm1.Show
End Sub
The code in the userform is all private subs.
Similarly when calling a public sub from the add-in such as;
Private Sub CommandButton3_Click()
Call SillySub
End Sub
I get the error "Sub or Function not defined".
How should I be doing this?
how do you call another sub's function from another sub? For example:
Sub Worksheet_SelectionChange(ByVal Target As Range)
StartingDate:
Static STempHolding As String
If STempHolding <> "" Then OldStartingDate = STempHolding
STempHolding = Target.Value
EndingDate:
Static ETempHolding As String
If ETempHolding <> "" Then OldEndingDate = ETempHolding
ETempHolding = Target.Value
End Sub
If i just wanted to call the StartingDate function, from my Worksheet_Change sub how would i do that?
I am trying to run different macros by clicking various different buttons on the sheet, I then want different data to load into the user form depending which button was pressed. So I have buttons named "SV_1" and another named "SV_2". when either button is pressed then it runs a common macro that gets the name of the calling item. then I want to add "Macro" to the beginning of the calling item name and then call that macro. here is the code that I am working with, when using a watch i can see the value of the variable is "MacroSV_1" when button 1 is pressed but I cannot get it to run the Sub.
VB:
Public ClkBtn As String
Public CallMacro As String
Sub ItemCall()
[Code] ......
I want to be able to call the bottom number in a set of data that is ever expanding. I don't really know how else to describe it , so I will give an example.
Say I have:
3
6
4
I would want to be able to call 4, but then if I had:
3
6
4
5
I would want to be able to call 5, and so on. Is there any simple way of doing this? I basically want the maximum cell name, and the corresponding data inside of it.
I am trying to write a sub that executes a sub in an xla add-in. How can that be done in general?
More specifically I am wondering whether it can be done with the limited info that I have about the add-in and the to be executed macro within the add-in.
assume the name of the xla add-in is test.xla. The add-in is locked. I therefore do not know the name of the sub to be executed nor do I know the "on action" name of the sub in the ribbon. All I have is the Ribbon button label. Assume the ribbon button label is "ButtonLabel".
Is it possible to call the macro just by knowing the ribbon button label? If yes, how does the script look like assuming the above xla and button name?
Is there a way to call a sheet selection change event when the workbook opens? I am currently using this work-around to call the event:
View 13 Replies View RelatedHow is it possible to take the choice from the Combo Box and send that into a Stored Procedure statement in Excel VBA
I have 3 Combo Boxes, Months, Years, Date.
I'm trying to fillout these into this statement to run my Stored Procedure.
I would like a code that will look for a workbook and then look in cell a5 and return number to a45 of active work sheet. I would also need it to add a6 + a7 + a8 and return sum to a46
View 2 Replies View RelatedI've created a simple UserForm, and with some great help from royUK. I've managed to get it working to suite my needs. The next thing I need to do is call it when the user runs the macro.
How do I call the UserForm from within the macro that I created?
Once the user gives the input, how do I take the values and pass them to the loop in the macro?
I change the international setting by using the API call shown below. The settings change, but is not activated before I exit Excel and go in again.
View 7 Replies View RelatedI added a new sub to and now I'm getting a compile error. This was working fine until I added "Cust_Rev1". I get an compile error saying "expected variable or procedure, not module". Both are located in personal.xlsb. If I rem Cust_Rev1 out, I don't get a hiccup. (FWIW, I've been running "Cust_Rev1" on its own to debug it.)
View 2 Replies View RelatedSuppose I have an optionbutton named for each day in February, say Feb1, Feb2, Feb3, etc. Would the following code do what I want it to do?
View 4 Replies View RelatedIs it possible to call a Private Sub from another Module?
View 2 Replies View RelatedI have a macro call psc in one module
in a different module I would like to "call psc"
however, this does not work
I have created a custom menu and saved it as an .xla, one of the functions on the menu is to open up a workbook from a file path. The second option on the menu is to run a macro from the custom menu that is saved in this opened workbook.
Is it possible to write a code that will go off and find this macro from this open workbook?
The reason I wanted to do this is so the user has two options to enter data from however I didn't want to copy the macro over from the original workbook as in time the workbook will be updated
I have found some code that does what I want- but i do not understand how to use - call it. The programmer says ...
GetNetworkIPAddress()
' can be called from a worksheet cell using the formula:
' =GetNetworkIPAddress()
I have put this in a cell but i ger an error #Name?
what should i do ?
I have a named range, which pulls a text value from a vlookup. This text is the name of a vba sub I have written. What I would like to do, is call the macro based on this value. This is what I have so far but I can't get it to run.
Code:
Sub ControlSheets()
ActiveSheet.Calculate
Hideallsheets
Dim MacroSub As String
MacroSub = sheets("Control").Range("SheetMacro").Value
Call MacroSub 'this is the name taken above that i want to call
End Sub
Just want to know that can a formula call data from one workbook and paste it as a value in another workbook? Can it be done through VBA?
View 4 Replies View Related