Search results for query: *

Oh - I see it now. Thanks so much.

Hi - I have gone through all the menu items and can't find any options to export. I went to the Business Objects support site and found articles about exporting but none so simple as how to get started. Is exporting possible in Crystal Reports 8.5 and if so, what are the steps to get there...

I used macropods solution to separate the numbers into 4 columns of 2 numbers each and then sorted them by the last column, then the next to last column and so on. They really don't have to be in 4 columns (1 would have been fine) but I wasn't sure how else I would get them sorted in that...

I have a list of numbers in varying length(less than 9 digits). What I want is to add preceeding zeros to make each number 9 digits long. Then I want to take only the left 8 digits and sort the numbers by the last two digits. I can add preceeding zeros with a custom format but then when I use...

Thanks for your reply. That worked - I just had to change a couple of things. This didn't work for AR: =LOOKUP(AQ2150,$AN$2150:$AN$11686,$AK$2150:$AK$11686) because I think that's a one row lookup. The columns don't line up so it needs to be able to look in the whole column insead of on the...

I have 4 columns with about 13,000 rows. Col A Col B Col AK Col AN 10020 122.4 10020 10020 26 112 10021 10021 24.5 10022 10021 26 12.94 10023 10022 45.6 10024 J0270 K1254 Columns A, B and AN are codes and column AK is fees. The...

Thanks for the contribution esquared - but I think that takes the number in reverse and sorts it in numerical order from there... ? What I need to do is sort a number like this: 123600 by 00 and then by 36 and lastly by 12. Thanks again -

Both of those worked. Thank you so much -

Does anyone have an idea on how to sort numbers in terminal digit sort? That's where you sort a list of numbers by the last two digits and then the two before that and then the two before that as in the example below: 123498 123598 123698 123499 123599 There will be 6 or 7 digits in the...

Not yet. I was lucky in that the person I sent the CD to was able to hear the music/sounds with the presentation on his XP machine. So I think it has something to do with the programs/configuration you have loaded. I'm wondering if converting the sound file to an .mp3 would work. I'm...

Thanks a bunch Karl and mrees. ESquared and SQLSister - I know - that IS a lot of fields. I didn't even realize it at first until Excel had a problem with it. Then I took a closer look to see how many fields were there. I didn't create these tables though, it's a purchased package. And I...

Is there a way to do a select statement to get the first 147 fields of a table (and then another one for the second 147 fields) without typing all the field names? I'm importing them into Excel with DTS and can't do it all at once since Excel limits me to 256 columns. It would also be ok if I...

From what I can find on the internet, it looks like PowerPoint uses Media Player (it came out before Windows Media Player), go to run, type in mplay32 to open it, to play the sound files. If some other application - like RealPlayer - has disabled it, then the sounds won't play. Perhaps another...

I inserted a .wma file in PowerPoint on my Win2000 machine and then saved it with Pack and Go and the Viewer. I unpacked it and burned all the files to a CD. It plays fine on all my 2000 machines at home. The machine I'm making it for is an XP. Once I was able to go to the XP machine and test...

I added this: Worksheets(vArrSh(sh)).Activate after each For statement and now they all Bold. Thanks to all. :-)

I was having a problem getting some sheets (several sheets selected at once) to duplex print on a consistent basis. I have asked about this before and got a fix for it as seen in this: thread68-829039 I think my user keeps switching printers (trying to get multiple things done at once) and...

Oh sure. At home it worked every time. Now I'm at the office and not every total row is bold. I think it may have something to do with the active sheet. I have 3 loops and before each one I activated the first sheet it would affect. The total row on that sheet is bold but the ones that follow...

Tony and Geoff - Thanks so much - you are always there with thoughtful answers (and you are right so much of the time I can't help but think the error is still with me). But I tried both the lines below (one at a time) and only the total row on sheet A turned out Bold each time. Every time I...

I'm successfully finding the last row - at least that's what the MsgBox tells me. The problem is that the first row is being deleted instead of the 31st row (which it is finding). Sub testDelete() Dim LastRow As Long LastRow = ActiveSheet.Cells.Find(What:="*", SearchDirection:=xlPrevious...

Honestly - I'm not sure how it is doing the selection. I'm sure I got that from recording it first. And if I do define the range then I'm not sure how to re-word the syntax. I don't think it's the following because I just tried it: With Range(A36:H36).Borders(xlEdgeTop) .LineStyle =...