Search results for query: *

Hello I am trying to work out a method to concatenate the data within a number of group and outline branches to a single cell. As an example to make it a little more understandable...the data is arranged in the group and outline as 1 1 1 2 2 3 2 3 3 4 5 The way i want...

...If ' ' OpenFile.lStructSize = Len(OpenFile) ' OpenFile.hwndOwner = hWnd '' OpenFile.hInstance = app.hInstance ' sFilter = "XML File (*.xml)" & Chr(0) & sLike & "*.xml" & Chr(0) ' OpenFile.lpstrFilter = sFilter ' OpenFile.nFilterIndex = 1 ' OpenFile.lpstrFile = String(257...

Hello I am trying to use the RaiseEvents in Excel VBA to send variables from one class module to another. Below is what I have so far. cls1: Event itsdone(Company As Variant, Number As String) Run code here 'This next line gives me the variables from the procedure Enditall mycompany...

Hello I am trying to convert a dynamic array to a string in excel vba and then send the results to the message box. From my code below, i have the dynamic array and the CStr function for the string but cannot work out how to get all my results from the array out into one message box only...

As i said before its a test. What will happen when this goes live is that the company name will be used as the search criteria, if that name is in the spreadsheet then it will retrieve a message to confirm this if not then another message will state that the company has not been found...

Hi Skip Yes you are right they will have the same values. As a test i am trying to find the company in the spreadsheet and then pull back that company name in the message box, when this gets released though it will retrieve an id for the user.

Hello all I have some code below which works via the right click menu of an internal application. Whatever is right clicked (such as company name) takes the focus to the spreadsheet and then finds this name in the excel spreadsheet and returns a piece of information back to the internal app via...

Hi all I have some code that performs a Do...Loop that takes a piece of data from a table, finds relevant information from a back end library and then writes it to an output table. My problem is that as there are 300 different data items the code takes around 10 mins to complete. Is there a way...

Hi all I am trying to union two ranges containing numbers which i then want to sum. In the ranges which start from F7 there will always be a gap to the next range, it will start from F9 or F10 or F11 and so on and so forth. But the answer to my sum formula always gives me the value from F7...

Sorry for late comeback on this one, but still no joy with tsuji's suggestion. Anyone have any ideas? Thanks

All Posted my code below which is the MS Smart Tags options used in Excel. I have been trying to get the XML to work whereby it will take the url, and on opening the browser resize it to the appropraite settings. This is the first time i have attempted javaScript so finding it tricky to get to...

Thanks Andy for the response it works now, much appreciated. Cheers

Andy Thanks for the reply but still the same error. When i change the website to something more direct like www.microsoft.com for example it works but not when i have the full url that i need. any ideas cheers

hi all, Quick questions probably as i have the error message that a semi colon is expected and an error occurs in processing my resource file. The message also retrieves the first URL line as to where the problem is occuring. <FL:smarttaglist xmlns:FL="urn:schemas-microsoft-com:smarttags:list">...

Hello all I am unable to get an internet connection on home PC. I have an internet connection through a router, which works when connected to my laptop though. Problem seems to be with IP address. When i do 'ipconfig' the ip address is 0.0.0.0 but 127.0.0.1 works. My TCP/IP connection is set to...

values are first row always set to 2, first col set to 2 and then adds one after every loop etc. Where i can see the problem is that 'Set therange = thisworkbook.sheets("Data").Range(Cells(firstrow, firstcol), _ Cells(LastRow, firstcol)) will only work without the error if you ahppen to have...

Skip thanks again, here is the full procedure the values for the first col, first row, and last row are what i am expecting. When select therange is used it grabs the appropriate data.

Thanks for the reply Skip, but i tried this and still get object or application defined error.

Hi all, I have taken and amended Loomah's first and last row from the FAQ section. Thus I have: But keep getting an error message of 'Object required' on the line 'set therange' which I do not understand in this context. Can anyone help Best regards

Hi Thanks for the posts. Skipped through the code and added values to the watch window. This gave back what i was expecting to see i.e the correct values from the sheet. I also formatted the values just to make sure. I did not know of the CDbl function before, I am testing a larger batch of...