[visual-basic:vba] Forum Topics

Hello, I am fairly new to VBA development trying to upgrade my employee training database in VBA from a single listbox with single line select/add/edit capability to one that pulls employee data from listbox1, searches training available by job title in listbox2, and combines the data into listbox3 also adding …

Hi, first, let me say this seems the best site I have come across for some great education and discussions... much appreciated! I am now to VBA and have a macro that I want to run until I get a particular message "#VALUE!" in a particular cell "B2". So far …

Ok I have a a list of about 392 items that needs to be put into an excel form. I manage to get Column A (which is the inserted worksheet names) to name the worksheets that is automatically inserted. I have attached an example of my table When the code …

Im not sure what code to use as I am not that experienced with VBA. No matter what i try i cannot get this macros to stop once it reaches a blank cell in E column. Here is the code: Option Explicit Sub PDFTemplate() Dim PDFFldr As FileDialog Set PDFFldr …

I have code snippets, VBA / Excel, and have no idea how to submit them for member review.

I was write code for excel vba xml database values write into text file. when i using without any special characters xml values parsed into their text file without any issues but when i using special characters xml cannot parse special characters (&,- etc) error getting on my macro page. …

I have a project where I have to send data from an Excel spreadsheet to an Oracle database. Here is the code I am using and I need some help. It stops at the second string statement. I am trying to use an Excel range name to Insert or Update …

Hi, i'm a beginner and i need a macro that look for a specific word, then merge that table an go further. I've created a macro but it doesn't go out of the loop. I have this Word: Sub MergeSpecificRowInOneCell() Selection.WholeStory Selection.Find.ClearFormatting Selection.Find.Font.Italic = True Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = …

How do you split a string in vba?

Hi, I have a spreadsheet with data that I need to sort into a more 'usable' format, I want to repeat (/apply) this macro for all the data but am not sure on how to make it loop every 2 cells. Sub Macro1() ' ' Macro1 Macro ' ' Range("C2").Select …

Hi, Good Day, My name is Yogesh, I seeking your assitance/help in making the segregation or extracting of data simple. I extract a report from internet application, with six diffent customer information. I would require only customer names & sell details from the each table. Can it be possible via …

please check this code and tell me what is the problem with this ..... i get error*"operation is not allowed when the object is open"* dim conn as new adodb.connection private sub commandbutton1_click() conn.connectionstring="dsn=localhost;uid=root;pwd=root;" conn.open dim cmd as new adodb.command cmd.commandtext="select sname from stu" cmd.commandtype=adcmdtext cmd.activeconnection= conn end sub

Total VBA novice, trying to do some simple file modifications in excel via access. I need help navigating to the bottom row in excel to do some copy/pasting. Getting an "application defined or object defined error", marked by the "#" below. Please help! Sub MRFDATAIMPORT() Set xlApp = CreateObject("Excel.Application") With …

Hi I have an excel macro question in VBA. I have this code. I want it to go down each cell in row C and run the same if statement instead of just depending on cell C2. I want it to continue to C3, C4, C5, all the way till …

Hi i got a sheet in a work book that i am working on now with form control (dropdown). The code i made changes the color for the text in the entire row, or highlights it, works fine. But i would like to add code to change the cell value …

How can you write a macros that will loop until it finds a blank cell. Then, once the first blank cell is found do a vlookup to a set of data? It will be looping on the same row.

Hi everyone, I'm new here. I don't know VBA and have been tasked with a VBA project for whatever reason. We have a recurring bug wherein a report we receive has semi-fake rows, causing all kinds of hell. The current logic I am attempting to execute should run as follows: …

Hi guys, as title says, i need to find first column with empty cell in every thrid row in my sheet. it looks like this ----------- --------- ------- ------ I need to write at each (third) row, new data from other sheet. that part of code is ok, i checked …

Hi group, I've written some VBA code behind an Excel spreadsheet to check to see if another workbook is open. If it isn't open, I'm having the code open it for me. This works fine the first time the macro runs. However this same spreadsheet has a cell where a …

Hello everyone. I've joined daniweb mainly because I need some guidelines for programming. I currently know some VBA, R and HTML which is not a lot, but I'd like to change that in the nearest future :) I've noticed that probably the best way to learn to program is to …

hi can someone help me? I have an excel file and the columns consist of : ID, Name, ContactNo, SalesOutput Sample record is: ID,Name,ContactNo,SalesOutput 123,Michelle Dela Rosa, 8437, 2 456, Anthony Diaz, 8414, 5 What I would like to achive is auto add rows depending on the value in SalesOutput …

For the past week I have been trying to develop a VBA script to do PCA/SVD based data mining. The data are timetaged numerical quantities. It's been quite frustrating as I am newbie in VBA development. Any help would be appreciated. Secondly, is it possible to find VBA and/or python …

Hi Champs, Im using VBA for Excel. and Im trying to use the code below to move through records and increment their values by one since they meet a certain criteria Sub promotion() Dim x As Range Dim y As Integer Sheet2.Range("c2").Activate Do While y < 1002 y = ActiveCell.Row …

This is a theoretical question but any specific technical knowledge that could help will also be appreciated. I am an IT Assistant with not much knowledge in programming (apart from EasyPattern and super-simple batch files) but have been given an opportunity to start getting into it by having been given …

Hello, I would like to create a macro. I have two worksheets, both containing an ID. Would like to update the price from the second worksheet corresponding to the ID. Any ideas? I am quite new to this so a bit of guidance will be appreciated.

I am trying to create an application using VBA that will create a QR Code based off of some text that has both numbers and letters. I believe that I have been succesful in encoding the proposed data using the Alphanumeric mode of 2Q. I am trying to base this …

i have the following fields in my access application. 1.studentid 2.grade e.g A,B,C..... IN COMBOBOX 3.GRADING SYSTEM E.G A= 4.00,A- = 367 IN COMBOBOX I WANTED IF ICHOOSE A , I GET 4.00 AUTOMATICALLY QUICK REPLY WILL BE APPRECIATED

i have trancript generating application in access. these are the fields 1. studentid 2.grade in combobox(A,B,C---) 3.grading system IN COMBOX(4.00,3.67---) I WANTED IF I CHOOSE A,I BE ABLE TO GET 4.00 AUTOMATICALLY IN GRADING SYSTEM COMBOBOX. quick reply will be appreciated

I I have an application in access 2010 which is mainly for generation of tranascripts. i have the following fields. 1.Grade(A,B,C-----) IN combo box 2.grade points e.g (4.00,3.67......) IN combo box 3.credit hours e.g(3,2,1,0) in combobox I wanted if i choose A(grade) for example from the combobox, i be able …

Hello, I've got a question about vba in excel. I hope you can help me with this issue. In a sheet, I want to loop through column G to check if het value is "Yes" or "No" So for, no problem, but... When a cell in the loop has got …

I am using following code. It creates a macro button on word menu in Add-Ins tab Public Sub ShowToolbar() ' Assumes toolbar not already loaded ' Application.CommandBars.Add TOOLBARNAME AddButton "Button caption", "This is a tooltip", 526, "NameOfASubInYourVBACode" ' call AddButton more times for more buttons ' With Application.CommandBars(TOOLBARNAME) .Visible = …

I'm looking to create a macro to group rows based on cell content. Each new invoice begins with H with rows under beginning with N, the number of N rows varies with different invoices. What i want to do it create a macro that will add one row break between …

I want to create a template file in which I want to create my own styles programatically(in VBA) I have following code Sub Style() Dim myStyle As Style Set myStyle = ActiveDocument.Styles.Add(Name:="Abbreviations", _ Type:=wdStyleTypeParagraph) With myStyle.Font .Name = "Calibri" .Size = 12 .Color = wdColorBlue End With Selection.Range.Style = "Abbreviations" …

I have a table which have some records,i need to loop through selected fields(say 10 to 14 with respect to 10).. if it finds any data from 11 to 14(with respect to 10) the value has to append to the field 10 for each corresponding row, sub fi_macr() dim strsql …

Hi, Can someone help me. I need to create a VBA project in excel using combo box. For example, I have in column A, combo box of ITEMSA and in column B, combo box of ITEMSB. If I choose items from ITEMSA, just the corresponding items that will match will …

I'm trying to call an executable from my VBA code so that I can run it from that code. I can do this using the 'Shell' directive but what I can't do is receive a return value (the output) from that exe file. I'm not sure where to post this …

Good day pals. please i need a VBA code that could make ms excel automaticly tell the maximum point of a curve in a chart. Secondly, another code that would make it automaticly tell the Y-value of the point of interception i.e when two series or range of values are …

Hi All, I met with some people from a private firm that has been hired to automate some data flows from PDF files to Excel and then to SharePoint. I wrote some VBA code for them to brute-force-test and they were impressed with what I had accomplished. The one fellow, …

Hi All, Since most of you are professionals and I'm trying to be a professional at work I thought I would pop this question at you. Have you ever had one of those days where your coding stinks, errors are difficult to find, and no matter how you proceed with …

Does anyone how to hide excel macro worksheet each time excel 2007 starts up? using vba syntax thx

Hi everyone, At my new workplace, I've been learning and making a few scripts/macros in VBA to help out with work processes and so forth. Nothing major, but I've taken an interest in it and really want to take it a step further. A lot of this might be amateur-ish …

Hi All, I'm trying to save an incoming email as a .txt document but I'm having some trouble with the VBA. My procedure is as follows: Sub ConvertToPlainAndSaveAs(Mymail As MailItem) Dim strID As String Dim objMail As Outlook.MailItem strID = Mymail.EntryID Set objMail = Application.Session.GetItemFromID(strID) objMail.BodyFormat = olFormatPlain objMail.SaveAs "C:\Users\Me\Documents\path\to\Test.txt", …

I am using excel 2007. In my file 6 sheets. 4 sheets is data record & 1 sheet is recorder sheet & monthly. Data record sheet name is : FY_2009, FY_2010, FY_2011, FY_2012 & FY_2013. In all above sheet : Part numbers mentioned in column "C2:C60000" Quantity in column "D2:D60000" …

Hi everyone I'm new in VBA and I have a problem with my code, if someone can help my I will be grateful. I have this part of code in Excel VBA an work fine Dim NumeroArchivo As Integer Dim conta As Integer Dim ListArchivAbierto As String NumeroArchivo = Workbooks.Count …

Macro to import excel files into another excel and another macro to automatically plot graph with the data imported from the excel file. Pls assist with a demo sample. Thank alot for coming to my aid

Been fighting with this for a while. Office 2007 and Adobe Pro 10. Have VBA code to step through a directory tree and print .doc and .docx files to PDF Printer (set as default). Code runs fine but when I try to open the file, Adobe says it can't because …

Hi I hope someone can shed some light on the problem I am having at the momment with an Excel 2010 Sheet, the workbook has 13 sheets with formulas and I rotate the 2 values using vba there are other things going on like a link to SQL server that …

Hi All, I am tasked to generate report templates in excel and I am new to excel, VBA and still learning. A little more information on my task, the information for the report will be extracted from different sheets in the workbook which contains a whole list of calculation and …

Hi, I wanted to find out if there was a way to design a macro that takes information from a column in Excel to a text box on a webpage. I have over 600 records that I can input 15 at a time. I would like to run a macro …