Search results for query: *

I'm not sure if this in the right forum but I couldnt find one that would be more fitting. I built a windows application in VB.NET and was hoping to get advice on deploying it. I work for a financial company that is constantly bringing in agents to work for us. When they join our company they...

Hey All, I receive some excel spreadsheets each month from various vendors breaking down the business my company did with them the month before. I've written macros on them to manipulate them and return only the data my company needs. One of my main problems though is that these companies...

Hi, I've got 4 separate yet related text files that my company uses that I've written macros in excel for to parse out the information from the text file to an excel file. After the file is parsed, the macro grabs the value of a certain cell and tests it against some criteria (thats different...

I have a selectionchange event sub that I've gotten help with in this forum before but this time I've got kind of an interesting problem that I'm not sure if its a bug with Excel or if I'm just doing something wrong. Anyways, heres the problem: Theres certain areas on a worksheet that if the...

I created a little program that uses the selection change event in excel. basically if someone clicks on a cell with data in it in column A then the spreadhseet drills down on that selection and returns a bunch of information based on what the user selected. this works fine except for when a...

I'm trying to set the value of an active combobox embedded on an excel worksheet. Its a 2 column combobox and the first columns a bound column. Is it possible to set the value of a bound control in excel? Anytime I use the .value property I get an error saying that it could not set the value...

Does anyone know how to set the showdropbuttonwhen property for an activeX combobox embedded on a worksheet? I was messing around by trying to mimic the activeX combobox properties box and tried: with combobox1 .showdropbuttonwhen = 1 end with and it shut down my excel. there's a...

Ive embedded a combobox on a worksheet using the combobox in the worksheets control toolbox and I can't seem to populate it. I have an Access table with two fields in it that I want to use to populate it. Everytime I try something I get an error saying that the column property of the combobox...

I'm having a problem in which I'm saving an excel file as a tab delimited text file. In actuality, I'm combining all of the columns into 1 and putting a semicolon in between each column before I save it because I need my text file to be semicolon delimited but the only option in excel is to...

Hi, I've created in addin for excel that uses a userform to pull information from an access database and puts it into excel. i've also created a procedure using the worksheet selection_change event that allows the user to click on a cell that has a company name it (one of the fields returned...

I was able to get the attachmate type library and I now have a reference to it in Excel but now whenever I type in the code to call attachmate: Public System As ExtraSystem Public Sessions As ExtraSessions Public Sess0 As ExtraSession Public MyScn As ExtraScreen Sub doesthiswork() Set System...

is it legal to share the type library to attachmate? i would really like to use VBA when dealing with attachmate but I dont have the type library on my computer and can't seem to find it anywhere. if legal, could someone post it or possibly email it to me so that I can use it? thanks.

I just started using Extra Basic this week and have been searching through this forum for all sorts of answers the past couple of days. I'm trying to be able to use Extra in VBA but every time I type the code in to initailize a session I get an error message that says "ActiveX Component Can't...

I have a database that has a list of customer accounts, customer names and customer account codes. Its kind of complicated but there are all sorts of account codes and most of them are similar to each other. Some say the customer has been with us for more than a year some say more than three...

I have access to a database that lists every customer account for our company. The first field is the account number, the second field is the last name, the third field is the first name and the fourth field is the middle name. All of these fields for some reason have like 20 spaces after the...

I have a subform that has three controls bound to a table. Theres a command button below the subform that opens a new form when clicked. That new form lets you enter information into it and has an insert query that adds it to the underlying table then closes itself. When it closes itself I...

ive got two questions which are both probably really easy to fix but I just dont have the experience yet to know how to fix them. first, ive got a textbox on a form that is bound to an underlying field of type number. everytime i go to that box on my field a zero pops up before i type anything...

hi, I have a form that has several controls bound to a query. I added a new table named address to my database and then I added a couple of textboxes to my form today so that the user could type in the customers address and via a query it would fill into the new address table. the address table...

how do you define a custom list in VBA and then call it? heres my code but it doesnt seem to work. Right now I have that list as my custom list #13 but its not like that on other peoples computers and I want to have a universal custom list. is this possible? thanks for the help...

I have a list in column A on sheet1 and a list in column D of sheet2 with a whole bunch of information between the two. Next to the list on sheet2 is a date from the past 3-4 months. Is there a way in VBA to compare the list on sheet1 to the list on sheet2 and then paste the date from sheet2 to...