Api Call For Add-in Folder
May 9, 2007Is there and API call I can do to determine a user's default add-in folder for Excel add-in ?
View 9 Replies
ADVERTISEMENT
Lookup Function Call: Vlookup Call In Sheet
May 21, 2006I 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)
Lookup Folder From Cell Text Then Save Excel File In This Folder
May 14, 2014I have alot of project folders on my harddrive.
All in format: I:/12345-costumer-projectname/
The five digits are unique for each project.
I make calculations for these projects using an excel file. In this excel I also type the projectnumber (cell J2)
Now i would like to make a button. When pressed, it checks the projectnumber cell J2, looksup the corresponding folder and saves the excelfile in PDF format in this folder.
I have found macro to find files in folders, but none which do the above.
Excel 2003 :: Extract Variable Rows Of Cells From Files In A Folder To Existing File In Folder
Mar 15, 2013I need a macro in a workbook to look at all the files in the same folder that have "*att*.xls" in the name and determine and copy from the range A15:W515 only the rows that have data in at least columns A, C and D. Each file will vary as to how many rows there will be and there are more than the files with "*att*.xls" in the folder. The data will be on the only worksheet in each file and the worksheet is named "G2WAttendee_xls" the data from all the files need to be copied to the file called "Consolidated webinar reports.xls" (I am using Excel 2003) and to a sheet called "Attendance Data" and added to the end of the last paste.
At the start of the macro the current file "Consolidated webinar report.xls" should be saved to a sub folder of the current directory and have the date saved added to the name. The sub folder is called "Completed reports". The data in the original file on worksheet "Attendance Data" should be deleted.
At the end of the process all the files that have had data copied from them should be moved to the sub folder "Attendance reports consolidated" (This could be done as each file is closed if that is easier).
I have headings in row 1 of the "Attendance Data" worksheet that match the headings in the various files in the folder (which will always be in row 14 of the individual "*att*.xls" files).
The folder with all the files and the "Consolidated webinar report.xls" file is at path "Z:P and S MEvaluationsWebinar series 2012-13TB".
For All Workbooks In Folder - Copy Range To Different Workbook - Save To New Folder?
Apr 21, 2014I have up to 50 workbooks in one folder with data in a specific range. I also have one workbook which includes additional data, including conditional formatting and dropdowns. I need to copy the desired range from the first workbook in the source folder to the second workbook, then save the latter to my destination folder, using the same name as the first. I need to repeat this process for all workbooks in the source folder.
View 2 Replies View RelatedVBA Code To Find A Folder Name Within Parent Folder That Contains Defined Text
Jul 23, 2014I have an Excel VBA Macro for creating/logging drawing numbers. Each drawing belongs to a job number. Each job number has a folder name containing the job number followed by a description (ie 999999 - bracket assembly) for storing drawing pdf's. The job number is only known as a 6 figure number in the drawing creation process BUT for the PDF saving process it is a string value...as my example above
I have to change my process by pre-creating the Job Number folder, then have the macro look for the appropriate folder by searching the parent folder for a sub folder containing the job number (always the first 6 figures).
I want to insert in my macro some code that searches...
The parent folder for a folder containing the job number. The macro value for the parent folder is P:engineeringdrawings (this never changes). the macro value for the job number is iOpenair (it's an entry that is entered as start the macro). Imagine the value for the job number is "999999"...so the search would be for "999999*.*" The code needs to search the parent folder, find the folder name that begins with a six digit number. Capture the complete name of the folder and store that name as a Dim value that I can call up elsewhere in my macro.
Change (Browse For Folder) To Automatically Locate Sub Folder
Jul 23, 2012I am creating a document for work that automatically generates hyperlinks to pdf files in a given sub folder. Currently I have a section of code that opens a window to choose the folder location.
Code:
'Prompt user to select a directory
Do
Problem = False
Set ShellApp = CreateObject("Shell.Application"). _
Browseforfolder(0, "Please choose a folder", 0, "c:\")
On Error Resume Next
[Code] ........
What I actually want is to not have the window open, but excel automatically choose the sub folder location.
The directory looks like this
Z:ClientProjectDRAWINGS-2 RECORD COPIESPDF
The xlsm file is stored in the DRAWINGS folder, and I need it to point to the PDF folder.
Image Folder - Save 500 Images In Another Folder?
Jul 18, 2014I have a list of items in an excel sheet... 500 of them... and there are images for them in an other folder... The problem is those images are in 1000's and I only need those 500 images.. Images are saved as "SKU.jpg eg NS2354.jpg and we have an SKU column in excel as well .. SKU and their images have same name...
Is there any solution to pick up only those 500 images from those thousands of images?
Is it possible to save those 500 images in an other folder?
Macro To Locate Folder In A Folder And Save
Apr 13, 2009looking for some code to save to a destination
destination address is
C:Documents and SettingsstDesktopOJF
now the problem is OJF has folders named 1 to 500
so if cell d5 = 487 it will need to look in the above desination and then open the folder and save it there.
Loop Through A Folder And Save In Different Folder
Apr 26, 2014I would like to create a code that will open all workbooks in folder "A" one at a time and then close the work book after another code is executed. So one workbook will open and while the workbook is open, I will call another code to format the active workbook and then the active workbook will be saved in folder "B" and closed and go to the next workbook in folder "A" to start all over. The folders are saved on the desktop.
View 5 Replies View RelatedLocate Folder From Part Of Folder Name
May 23, 2007if it's possible to use XlDialogOpen to open up a folder that you only have part of the name.
For example, say you have the following folder paths:
C:Main FolderSubfolder1Smith,Billy 2413
C:Main FolderSubfolder1Brown,Charlie Ray 2416
C:Main FolderSubfolder1Bunny,B 3619
C:Main FolderSubfolder1Fudd,E-G 1864
What I'm hoping to do is just look for the 4 digit number on the end finding that folder name and opening it up. The name conventions before the 4-digit serial number are quite random. Sometimes it includes their full first name, other times it's just an initial for the first name and other times there are other characters included in the name. The one thing that is constant is the 4 digit serial number on the end.
how I could get the Open dialog box to pop up and have the chosen folder number open?
VBA - Cut File From A Folder And Put Into Another Folder?
Oct 9, 2012Is there a way I can from vba cut a file from a folder and put in to another folder? And also create a folder? If yes, how can I do this?
Is it better to use dir or scripting.filesystem object?and if there is an advantage to use one over the other.
Call Sub
Jul 18, 2007I 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
Call .exe From VBA
Jan 1, 2008I 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 Replies View RelatedProtect Call
Dec 8, 2008I 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 RelatedNeed Macro To Call UDF
Apr 29, 2014I 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] .....
Call Function By Name
Aug 30, 2007Just wonder how to call the function if I have it's name in the variable String
for example something like that:
How To Call Sub With Arguments
Sep 30, 2013I'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] ..........
How To Call The Function
May 10, 2007I 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
Call An Add-in Function From VB
Jul 12, 2007I 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?
Funciton Call Up A Value
Aug 17, 2007I 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.......................................
Call Another Program Using VBA
Jun 9, 2008How 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.
Call Procedure From Add-in
Nov 27, 2007I 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?
Call A Sub Procedure From Another
Jun 19, 2008how 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?
Call Macro Using Variable As Name
Feb 7, 2014I 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] ......
Call Bottom Cell
Feb 11, 2010I 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.
Call From Within Macro Script Sub In Another Xla Add-in?
Jun 25, 2014I 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?
How To Call Selection_Change Event
Mar 5, 2007Is 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 RelatedComboBox To Call Another Function
Sep 24, 2008How 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.
Call Cell From Other Workbook
Nov 3, 2008I 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 Related