Re: Using VBA to group rows in EXCEL Programming Software Development by cgeier VBA is not VB .NET. [Visual Basic for Applications](http://en.wikipedia.org/wiki/Visual_Basic_for_Applications) VBA Validation Module Programming Software Development by Paladine VBA Validation Module Re: VBA source code Programming Software Development by Thong_Ispector VBA = Visual Basic for Applications... [url]http://msdn.microsoft.com/isv/technology/vba/faq/default.aspx[/url] Re: Is it VB6 or VBA? Community Center Meta DaniWeb by Jupiter 2 VBA is specific to Excel. Word. Powerpoint for versions 2003 and earlier. Certain code structures from vb.net can be used in 2003. There is a compatibility update from Microsoft called Office SP3. Any user with Office SP2 should (must) use this update. VB.net is for ALL Microsoft products 2004 (if there was a version) and later. VB6 is a … stumped random character generator Programming Software Development by herephishy VBA so that each click generates a random character between A and Z in cell A1, and the number is displayed with a random font size in the range of 16 to 24 points. can anyone help me out?? Re: VB 6 ,excel ,explain Programming Software Development by Jx_Man -VBA is a subset of VB which runs inside one of the office applications. As a result VBA inherits the current Office object library and application instance by default and any references that are included. However in VB you have to create the application instances if you need to manipulate one or more of the Office application objects. -There is … Re: SQL For MS Access? Programming Databases by jbennet VBA can do file I/O Re: Calling VB function from Access to update a field Programming Software Development by weasel7711 VBA within access. Re: Parse variable names and operate from string Programming Software Development by Teme64 VBA (or VB.NET) doesn't have any Eval function like you have in JavaScript. I found this article: [URL="http://www.developerfusion.com/code/198/evaluate-string-formulas-in-vb/"]Evaluate string formulas in VB[/URL] which uses Script Control's Eval function. The article's download link is outdated, here's correct link to [URL="http… Re: macro get value Programming Software Development by TnTinMN VBA is a subset of VB6, so I think that would be the best place. http://www.daniweb.com/software-development/visual-basic-4-5-6/4 VBA How to Populate Combobox2 Based on Previous Combobox1 Selection Programming Software Development by Behseini using MS Excel 2007, and VBA I have two combobox.The first combobox has three items as:{One, Tow, Three} now I would like to load the second combobox based on what user select in combobox1. For example if user select One in the from combobox1 then namebox1 will populate to combox2 and if if user select Two in the from combobox2 then namebox2 will … VBA Check Combo Value Programming Software Development by ImZick Im using VBA build inside excel is there a way to find if ComboBox has a value? for example i have 80 ComboBox and i want to check if they have a value like "A", "B", "C" and "D" and if the value is blank like "" then stop the checking. vba:explain code Programming Software Development by OneDreamCloser Hello All, Could you please help me with the following VBA code that I have to understand (but I am not aware of VBA) [CODE]Public Function ErlangB(Servers As Single, Intensity As Single) As Single 'The Erlang B formula calculates the percentage likelyhood of the call ' being blocked, that is that all the trunks are in use and the caller ' will… VBA to VB.net "Open filePath For Input As #1" Programming Software Development by Papa_Don Hello Group, I'm trying to convert some VBA code into VB.net. Here is that VBA code: Open filePath For Input As #1 ' filePath = the text file I need to read Do Until textRowNo = 8 'discard these first 7 rows... Line Input #1, LineFromFile 'this is the row counter textRowNo … Re: VBA - How to convert xls, xlsx files in a directory to csv Programming Software Development by Stuugie Hi Tensigh, Try the following but do not forget to add your file hiding code at the top: Sub SaveToCSVs() Dim fDir As String Dim wB As Workbook Dim wS As Worksheet Dim csvWs As String, csvWb As String Dim extFlag As Long '0 = .xls & 1 = .xlsx extension types Dim fPath As String… Re: VBA to VB.net "Open filePath For Input As #1" Programming Software Development by Papa_Don Rev Jim, I've purchased "Mastering Visual Basic 2010" but I don't see anything that suggests converting VBA code. I've also taken a couple of college courses in VB.net which were awesome. The codes suggestions above look pretty good. The next thing for me to do is to try them and build around them. My assumption was I'd use … VBA Excel: Looping Subs. help ! Programming Software Development by orsodani Hi everybody I have've been asked to do something but I can get only to a point and I am now stuck. Please help. I have written a Sub in VBA for Excel 2003 (see below) in which the top cell of a range (WorkRange) is initially set at Cells(1,2), where there is the first available price for a price series. Prices stream into the spreadsheet (… VBA/SQL INSERT VALUES syntax Programming Databases by stabatron5000 I have a table in Access with multiple foreign key fields. I would like to populate this table from Excel with SQL. Hardcoding values works fine: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES (x,y,...)[/CODE] Nesting SELECT statements like this fails: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES ( (SELECT f_key_x FROM … VBA Access, issues setting values from subreports Programming Software Development by OsheRono Greetings, I have been cracking my skull all weekend trying to find a solution to this, and I have no idea how to search as I'm not sure what to search for (I have performed a search, but it didn't show what I was looking for, hence, the post). I have the following query in access 2002: [code=sql]SELECT BDC_Piece_Defaut.Type_Defaut, … vba xl stack space problem Programming Software Development by tgiller Hello I have a problem with my vba collection object. When I run the code below I get the "out of stack space (error 28)" message. It seems to me that my collection shouldnt take up so much memory as the each object in it is just a set of a string and 3 single values. Yet it does. The code works fine if I eliminate ie two properties … VBA Macro security problem Programming Databases by Datsun90 Hi all, I have designed an application in MS Access 2007 that will be used in some schools (over 60 schools). Each time I start the application, it shows an alert in the message bar that the VBA macros are disabled, and gives me the option to enable it for the current session only. I know that it can be solved by enabling macros from the … VBA - Access 2007 - Referencing Form Functions in a Query Programming Software Development by weasel7711 I have a small company Database that tracks our repair orders. I have a query that I would like to execute based on criteria that the user inputs. I am new to VBA so most of my code is based on google research. I took a technique of wrapping my criteria variables with get/set functions. Supposedly, according to this site: [URL="http://msdn.… Re: VBA - Access 2007 - Referencing Form Functions in a Query Programming Software Development by weasel7711 [CODE=SQL]SELECT tblRMA.RMA, tblRMA.Customer, tblRMA.Status, tblRMA.PONum, tblProduct.Serial, tblProduct.Model, tblRMA.DateAssigned FROM tblRMA INNER JOIN (tblModel INNER JOIN tblProduct ON (tblModel.Model = tblProduct.Model) AND (tblModel.Model = tblProduct.Model)) ON tblRMA.RMA = tblProduct.RMA WHERE (((tblRMA.Customer)=GetCustomer()) AND ((… VBA for MS Access question - split function Programming Software Development by jay.barnes Hello! I'm working on VBA within MS Access XP, and can't seem to get the proper usage of the split function down. I've been trying to make this work, but I keep getting the "Run-time error '9': Subscript out of range" error. Since the code of my project is kind of long, I'll try to stick to the most relevant part- can someone … VBA Search and Replace partial formatting Programming Software Development by scaiferw Working in Word 2010, I have a long document with many formatting changes to be made. To start with, throughout the document I'd like to replace "Click OK" with "Click [B]OK[/B]", so the OK will be bold but not "Click". I also need it to be case insensitive, as some places may be "Click ok" or "… VBA Excel: change numeric value to string with 1000 separator (,) Programming Software Development by amitash Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks VBA 6.5 / Excel 2007:Subscript out of range message for method not found Programming Software Development by bruce.feist Situation: My VBA program compiles, but fails at runtime when I try to access a specific method. It doesn't seem to matter whether I set the method up as a function or a property get. Here is the code fragment which calls the method: ****** Function roots() As Variant ' array of variant(string, double or ratio): real roots only Dim … VBA - How to convert xls, xlsx files in a directory to csv Programming Software Development by Tensigh I'm trying to write code in VBA in Excel that opens a desginated directory, finds all xls and xlsx files and then converts them to csv. I found two sets of code that do one or the other perfectly, but I can't make it work. I'm sure I'm just missing one step but the more I tweak the code the less it works: Sub select_rows() strPath … Re: VBA - How to convert xls, xlsx files in a directory to csv Programming Software Development by Tensigh Stuugie, you're the best. One thing I can control is the name of the Excel files when they get stored in the original directory. If I tell the user to name the files as Workbook1.xls, Workbook2.xls, etc, then it will work. I'll try this at work tomorrow. The split function in VBA works almost exactly like it does in Python. Re: VBA - How to convert xls, xlsx files in a directory to csv Programming Software Development by Tensigh I'm not really an expert on VBA but I'll try to help. Do you have the line: `Dim wB As Workbook` somewhere in the code? If I understand the error correctly, it's saying that you're trying to access the wb object without having it created as an object.