So I was just looking for basic examples of reading xml structure data with visual basic subs/scripts. specifically, if possible, how can i take structure data of xml, read the data with some vba, and lay it into excel spreadsheets? or just a learning resource for this type of thing. thanks very much! ...
I've got two spreadsheets ("Old" and "New") and a VB Script macro. The macro runs in one ("New"), does a comparison of the contents of the other ("Old"), and then outputs the results back on to the "New" spreadsheet. I'd like to build an executable where I input the two file names and click a run button to simplify this procedure. The c...
Ok, 2nd attempt at writing a Stack Overflow Question, so forgive me if this seems familiar. I am rewriting an Excel Macro that was built over a 2 1/2 year period, frankenstein style (added to piecemeal). One of the things I need to do is load the data into an array once and only once for data accuracy and speed. For my skill level I...
Hi guys, Apologies is this is the classic newbie question, but I haven't been able to find a concrete answer. I'm entirely new to Excel VBA and to programming in general. What I'm trying to do is select a subset of data from a large excel sheet that's roughly in this format: Name Data One Data Two Data N -----...
I have a sheet which has date with extra space at end. And i want to remove them so that i can format them as date and sort excel sheet. I used macros available online for ex: Sub TrimColumnA() Dim rng As Range On Error Resume Next ''#if entire column is blank, exit sub Set rng = Intersect(Range("B1").EntireColumn, ActiveSheet.Use...
Hi, I have developed some code which creates excel macros and each time after creation of new macro I want to digitally sign the macro programmatically. Can you let me know if there is any way using which I can create new digital certificates and assign those to macro programmatically. Thanks. ...
I would like to create a dialog box or message box in excel WITH custom button labels i.e. FIRST and SECOND. I would like for this box to open up when the file is first opened...and doesn't allow user access to the worksheet until they select either FIRST or SECOND. I can make a form, but I would rather not add a form since this should...
I have a small script in Excel/VB that I'm trying to get working. All I want to do is select a dynamic range of data to copy but I can't seem to find any help/code on how to get the grid data (like A11). Here is code I have from macro recording that selects the range of data: Range("D291:D380").Select I was hoping I could just do ...
Hi Friends, we have subscription to Bloomberg data, we use excel to load data from bloomberg using bdp function. but its pain,so we decided to find easy way to do this . Is there any way to program and calculate Fixed Income Chars from a list of securities using VBA ,access,sql or anything.? Thanks ...
Hi, The below macro is pulling a value from a cell which is referencing a range and then actioning accordingly. How can I change this to only run the case for the relevant entry in the cell? Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Address = "$C$5" Then Select Case Target.Value Case Phones...
Hi, I am a mechanical engineer who has recently dabbled with VBA in Microsoft Excel (Office 2003). I have created an excel (.xls) file (created macro using VBA). The excel file is protected and has hidden worksheets. When I try to run the excel macro in Internet Explorer, I get an error message "Method of class "Sheets" failed in object...
I want to be able to insert a reference into a cell with arbitrary text around it. ex. use a reference to cells A1, B1 C1 => "blah blah <A1 text> foobar <B1 text>" Is there any way to do something like this while still maintaining the references? ...
I have a user-defined function written in VBA that updates colors in a drawn shape (traffic light consisting of three circles). The call in a worksheet cell looks somehow like this: setTrafficLight(A1, "Oval 1", "Oval 2", "Oval 3") where A1 is a cell containing e.g. "green" or "red". The other parameters are the names of the shapes. ...
I have an excel sheet with values in columns A, B and C like this: A B C 1 8.22 1.99902 32.48974 2 8.22 3.04698 33.92426 3 8.22 2.26374 33.1547 4 8.22 2.78227 33.2593 6 8.22 2.46798 33.34269 6 8.22 2.57802 33.67131 7 8.22 2.46798 32.7427 8 8.22 2.57802 33.07131 There is also a ce...
Hello All, I seem to have a dilemma. I have an EXCEL 2003 template which users should use to fill in tabular information. I have validations on various cells and each row undergoes a rather complex VBA validation upon change and selection_change events. The sheet is protected to disallow formatting activities, insert and delete of rows ...
Hi, I'm keeping a array of cell addresses which calls particular function. And I need to trigger all these functions in these cells When a user click a particular button. But I could not find a way to update stored cell addresses whenever user delete/add a particular row/column. Can somebody please suggest me a way of achieving thi...
hi, I need to set a unique name for the cell which calls particular user defined function. so I tried to set a name within the function as follows Dim r As Range set r = Application.Caller r.Name = "Unique" But this is not working. Please help Thank You ...
I'm Writing a VBA macro in excel that is supposed to open "fileB.xls" and then close immediately after it opens. Since we will be talking about 3 excel files I'll call the first one fileA. The code for the buttons on the userform for file A look like the following. Private Sub CommandButton2_Click() 'Code for Button in FileA ' ...
Hi, I'm using excel 2007 and i'm adding a macro that looks something like this : Function S(Value As String, Pattern As String, ReplaceWith As String, Optional IgnoreCase As Boolean = False) Dim r As New VBScript_RegExp_55.RegExp r.Pattern = Pattern r.IgnoreCase = IgnoreCase r.Global = True S = r.Replace(Value, R...
I want to plug a range object into a formula. An example should look roughly like this: Dim x As Range Set x = Range(Cells(1, 1), Cells(2, 1)) Range("C1").Formula = "=SUM(" & x & ")" The result should be "=SUM(A1:A2)" in cell C1. The point is to plug the the range object into a formula. I used SUM as an example, the real formula is...