Search results for query: *

Hello all, I have a Fujitsu Siemens LOOX N560 PDA runnnig windows mobile 5.0 and I want to connect a serial device to it. The LOOX has a USB connector but no serial connector. The cable with this connector is not available anymore (as far as i can tell). I have tried using a USB to serial cable...

click on the VBA box on the windows toolbar can't think what it is called but I mean the toolbar with the start button. Then press escape. This should pause the code so that you can see what you have done. Andrew It may have hit every branch on its way out of the ugly tree, but hey! It works...

Thanks Skip, Absolutely Perfect. Andrew It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on that)

hello all, I have a problem with conditional formating that I need some help with. I have two workbooks with the same layout. I want to be able to compare the differences between them by highlighting any cells that are different by changing their colour. The data is in the range ("b7:o29") I...

John Thanks for your help. The IT department came round to look at the machine and found out the other computer sharing the IP address. They blocked the IP address that mine was finding and forced it to pick up a new one. Unfortunately the same error occured. They then put in a new network card...

Hello everyone. I have a workbook with multiple sheets and I want to create one pivot table using the data from all the sheets in it. I can create pivot tables on the individual sheets easily enough but not my 'super' pivot table. I get an error message when I try to select multiple sheets in...

Tony That first bit of code is exactly what I want. Thank you very much for your help Andrew It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on that)

Tony X is my constant which comes from my for..next loop. for X = 1 to lots sheets.add ActiveCell.Formula = ThisWorkbook.Worksheets("ORIGINAL DATA").Cells(2, 2).Formula + X next x Andrew It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on...

Hello everyone What I want to do is copy a list of values from one sheet to another ( range("b2:b52901")) but I want to add a value to it depending on the value from a for..next function ex x=0 x=1 x=2 sheet1 sheet2 sheet3 1 2 3 2 3 4...

Hello I am having a problem with my windows 2000 computer which is causing me to want to break it - please help me!! The problem occurs when I want to use the network it is connected to. I obtain licences through flexlm for the software that I run. After about five minutes of use an error...

My friends PC has gone wrong!!! On start up the 'safe mode' normal mode menu appears. Selecting normal from the list carries on the boot and then returns the system back to the 'safe mode' ' normal mode' menu. I have tried all the options available in this menu and it always loops back. There is...

Thanks for the help. I have been back to the code and there is a with statement With shtTemp.UsedRange .EntireColumn.AutoFit Code end with I have used this again to reset the range if averaging code has run then With shtTemp.UsedRange .EntireColumn.AutoFit...

Hello Everyone I am trying to use intersect but cant get the code right. What I have is to rows of data from a1 to m2 row 1 acts as a header row to as the data I have inherited a program which uses intersect to pick up the information required in the range c1 to m3 using the following code...

Thanks PHV With these small changes I have managed to cut the macro time from 12 minutes to 0.025 Seconds (Or so my timer tells me) Andrew It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on that)

Problem solved!! It wasnt activating the workbook I wanted to. I put in the line wkbtemp.activate between the with and found line and now it works fine. Andrew It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on that)

I have a macro that creates an increasing number of sheets as it runs. At each step it searches through these sheets to see if a certain one has been created in the workbook. Several workbooks are used in this macro and the code cycles though depending on the workbook. I want to speed up this...

try this With worksheets("Milestones").querytables("milestones") do until .refreshing=false x=x+1 loop end with I know from you code that the sheet name is correct but not sure about the querytable name you will have to change that to suit. X=x+1 is simply there to give it something to...

whoops forgot you need this bit as well sub waitfor Dim sPrgm As String sPrgm = extract$ 'extract was the name of my program RunUntilFinished sPrgm End Sub Andrew It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me...

I had a similar request a while back, my macro ran an outside C++ program and would continue even though data was required from the c++ program and fall over. The best solution that I found (Probably somebody will recognise it as more than likely I got it from here) is... PUT IN DECLARATIONS...

No luck with ny of those. Thank you all for your help, I have rewritten all of my code now but it would still be useful to find out a way of opening a file like this. Thanks again. Andrew It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on that)