Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
vba6
- Page 1
Re: Using VBA to group rows in EXCEL
Programming
Software Development
9 Years Ago
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
19 Years Ago
by Paladine
VBA Validation Module
Re: VBA source code
Programming
Software Development
18 Years Ago
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
14 Years Ago
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
15 Years Ago
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
16 Years Ago
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
16 Years Ago
by jbennet
VBA can do file I/O
Re: Calling VB function from Access to update a field
Programming
Software Development
13 Years Ago
by weasel7711
VBA within access.
Re: Parse variable names and operate from string
Programming
Software Development
12 Years Ago
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
11 Years Ago
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
11 Years Ago
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
11 Years Ago
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
12 Years Ago
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
9 Years Ago
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
9 Years Ago
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
9 Years Ago
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
14 Years Ago
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
14 Years Ago
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
13 Years Ago
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
13 Years Ago
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
13 Years Ago
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
13 Years Ago
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
13 Years Ago
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
12 Years Ago
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
12 Years Ago
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
11 Years Ago
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
10 Years Ago
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
9 Years Ago
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
9 Years Ago
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
9 Years Ago
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.
1
2
3
17
Next
Last
Search
Search
Forum Categories
Hardware/Software
Programming
Digital Media
Community Center
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Meet People
Forums
Top Members
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC