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...

Hello Can someone help with the code below which i have lifted from the web to bring up the Save As form when the Save As button has been clicked on. At work that button has been changed to default to something else and i want to get it back to the Windows Save As form. This code works but won't...

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...

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...

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...

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...

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

Hello all Not sure how to resolve this one but hoping someone could help. My line of code is.... If cl.Value <> "" And cl.Value <= cl.Offset(0, 4).Value If this is true then a popup occurs with certain data in it. In some cases, but not all, cl.value would be -0.77 and cl.offset would be...

Hello all, My procedure has an array in 'list' and takes each 'ID' from this 'list' and then searches through the results (histarray) until correct data is returned and drops into my spreadsheet cell. Problem is that when the procedure is run it brings my results back in rows that i do not...

Hello all, Grateful for any advice on the following...I have a UDF 'GetHighPoint' which goes to an internal database and pulls back a list of data (results stored in high = Qry1.Data) and from this list the excel function MAX will find the highest value, thus the spreadsheet only sees one...

Hello I'm trying to control the 'flaky' sendkeys to print a number of documents in VBA by using the kernel32 dll and the 'sleep' method set to 1sec gaps between each object. This is all being done in a client site product that uses vba. My code is Private Declare Sub Sleep Lib "kernel32"...

Hi all, Having problems on something that i initially thought was simple, recalculating a bunch of values based on the excel functions when i press a button. I have tried various ways but it never works. I have at the mo.... Private Sub Workbook_Open() Application.Calculation =...

Hi Guys, I have basic line of code itemid1.bringtofront end sub This brings itemid1 to front when double clicked, but i have itemid2, itemid3 and so on. How can i give all these objects a generic name so that when i double click any item it brings it to the front. Grateful for the help

Hi guys Created a link via a button from an in-house application to excel which works fine. But for it to work excel must be referenced from within the application otherwise it fails. Doing this manually is OK just select the project. But we have numerous PCs to test on so wanted to do this...

Hi all Very basic question. Using the control toolbox and the combo box function in excel. I have written the code - Private Sub Workbook_Open() With comList .Clear .AddItem "Media" .AddItem "Banks" .AddItem "Pharmaceuticals" End With End Sub Which seems to work as no...