Search results for query: *

Hi! Just as the subject tells you. How do I use another delimiter than comma, I want to use the pipe "|". Input #1, date1, loggen, date2 'address2, lngItemIndex = lngItemIndex + 1 Set lvItems = UserForm1.Controls(dynamicbox).ListItems.Add lvItems.Text = date1...

Hi! I have had this problem a couple of times and managed to solve it by some tedious work. Now it's gotten really complicated... Our IT -department, controls all installations and updates and we are currently running excel 2003. We are supposed to have the same installations and everything...

Hi! I have gotten so much help here! And I have come a long way programming VBA with all the help I get! Now, in a thread from yesterday I learned a really nice way of using regex. I put that piece of code in a function in MODULE 1. Public Function regexsolution(mystring As String) 'Dim...

Hi! I have a textbox consisting of a lot of text both numbers and chars. Now in order to make the text dynamic i use replace on the text with certain variables, for example: If the user needs the date 14 from now. I let him/her write #date14# and the program then searches the textbox for this...

Hi! I have a lsitbox which in turn stores logs. These logs can be added, amended and deleted. Works like a charm. But sometimes my users want to delete the logs and they click one time to many... Which in turn results in that there is no selecteditem, and hence no index which give me an error...

Hi! How do i even do to change the alt tab icon? Im using excel 2003. I have looked into the matter but it's way beyond me using those api's... I have added code to get a minimize button and added the userform to the windows taskbar. This was done with code I found on the net.. But I can't...

Hi! I have a an excel 2003 woorkbook with some sheets. In one of the sheets one of the columns consists of comboboxes with 4 different values. I have a userform where i look up the correct row, and then add the same text as in the comboxbox. But somehow it does not count as if i had choosen the...

Hi! Im using excel 2003. I do NOT have acess to the rich textbox ;(, and I can't add it to our system because of security measures. So I use a textbox to get save data to textfiles, works nice! The data in the textbox often contains multiple rows. Example: Hi! We are informing you of...

Hello! Im trying to use Xpath to do collect some data from a page i save, RESULTS ON THE PAGE DIFFER. I save everything(the html source) into my "C" Variable. Thing is that, I can parse that like a LOOONGGG string(I do it with the mid() function and some ohter), but now I want to use the more...

Hi! I have started to create a sub which should populate bookmarks in a word template.. Seemed pretty damn easy.. But nono.. It's harder than i thought.. It just throws me a runtime error 424 "object needed"? Why is that.. I have double checked and can confirm that there is a bookmarknamed...

Hi! I have a listview. As you can see i update it on click. Is there a way to update it when i use the up- and downarrows to change my selection in the list? It should change as the selected index changes.. Been looking but I can't seem to find a solution.. :( Private Sub ListView1_Click()...

Hi! My problem first, im getting stuck in an endless loop while reading data into my recordset. Plattform: Excel 2003 Okay so im working with this textfile. I need to read it, manipulate it and save it back with the new info. After some thinking I think that using ADO technique is the best...

Hi! Been doing some wonderful coding thanks to you guys here on the forum! So if you read any of my other posts you can see I'm in the process of learning everything there is about creating .ini files, reading and writing data to them and ordinary tex files aswell. Now I have this log file...

Back again and on fire ;) I ahve searched everywhere and come up with this codeee This is what i have stored in a textfile 2011-06-30,Testing to read this string,2011-07-01 I use the code below to read it into a listview with three columns. Problem is that in the first column it only...

Hi! Im trying to create a really really simple way of reading a textfile into a listview. Almost there but I have a problem... I ahve looked through on the net and this was the simplest way of reading a textfile into a listview in separate columns. PRoblem is that when running this code, I...

Why is this not working? Im working in Excel 2003. I thought I could set it to a different listbox depending on the value of my page variable? Do I need to somehow set my dynamic variable as a listbox control? Dim logfilepath As String Dim dynamicbox As String Select Case page Case Is = 1...

Hi! A problem I never expected has occured... :( I am using excel 2003. In my application i create .ini files and read them on occasion. Now Im trying to connect my application via API to another program. In order to access that programs api I added that programs reference library. BUT this...

Hi! Im working in excel 2003. I use a function to populate a listview control. It's reads every cell and put it nicely into the listview. BUT when i try to filter what items to populate the listview with I end up with an empty list view. I do already filter it in the code im going to...

Hi! The IT-department at my job decided to drop some controls and have not licensed a few others. OUR SYSTEM EXCEL 2003 IM NOT ALLOWED TO RUN ANYTHING AS ADMINISTRATOR What this mean is: I can no loner use the following controls Microsoft Listview Control 6.0 (SP4) - Not avaiable any more...

Hi! I'am using excel 2007, and im trying to write to an .ini file dynamicly. And now I need sum guidance on a couple of things. The purpose of the file is like this: I want to be able to store new configurations, and then choose them from a dropdown. This is my pseudo code: First a...