Search results for query: *

I wish I could be more specific. I talked to a member of our technical staff, and the issue involves the Windows 2000 operating system and a stored procedure. That is all we know. Our third party consultant is talking to Crystal Decisions to resolve it. Thanks for your interest.

We are having difficulties in our office getting the Windows 2000 Operating System to work with Crystal Reports 8.5. Looks like we will be changing to Windows XP. Curious to know if anyone else has experienced this problem. Many thanks.

I have an application that prompts users for instructions via a dialog box and listboxes, then adds a worksheet with specific formatting (a different form for each scenario). My problem is this... The dialog box opens when the file opens, and the user can make a selection. But...if the user...

Thanks, Skip. That's exactly what I wanted. The row height idea was explored, but since the user is preparing these materials for the Board of Directors, and sometimes she must put shading in the blank rows for cosmetic reasons, the row height option does not work for her. Many thanks for...

This is for display purposes only, and a macro I am creating for another user. The spreadsheets usually have a heading, and then a list of data that has been extracted from another source, so I need to be able to select a cell, and then have rows inserted between rows of data below that. My...

The following macro inserts a blank row after each row of data. I need to be able to run this macro from any point in an Excel worksheet. How do I get it to recognize the selected cell as the starting point? Dim x As Integer x = 2 Do While Cells(x, 1) <> &quot;&quot; Cells(x...

Can anyone offer thoughts on how to make the printarea property work for a noncontinguous range? Dim r1, r2, r3, r4, r5, r6, r7, r8, r9, myMultipleinRange As Range Set r1 = Sheets(&quot;in&quot;).Range(&quot;l274:l500&quot;) Set r2 =...

I have a user-defined function that calculates fees. It was stored in the workbook, and in C:\program files\microsoft office\office\library. I do not want to update both sources, so I deleted the module in the workbook. The function does not look to the library. I get #Name? for each UDF...

Thank you, Skip - You are very kind to look at this for me, and it will most certainly be of significant help to my peers. I appreciate the help immensely, and will proceed to work through your latest fine example.

Skip - The problem I am having seems to be with the sByte formula. sByte = Mid(txt, i + Len(DVALUE), 1 While the sample text appears to have one character between DISTRIBUTION VALUE: and the number, this can actually be any # of characters, depending on the numerical value in the string...

Skip - How do I get 10,991.47 from the third transaction? It just reads VALUE, not VALUE: The fourth txn result you have posted is perfect. I am getting #value. You guys are way ahead of me, but I will work on this tomorrow on the train and see if I can interpret all of your code. Thank...

I haven't had a chance to read through this in full... I will test it out tomorrow... But I will be downloading multiple transactions from our intranet. Each transaction has explanation text in which I need to extract the distribution value. Then I need to get a total for the value from each...

Anything I can get to work. I am a beginner, so when I see the syntax spelled out in a logical way, it really is a gift. I have tried both...but I get #Value. I am still testing the functions with message boxes. I will come back to you though. Stand by!! Thank you!! One glitch is that...

This is AWESOME! Thank you ever so much. I will try it out on my laptop on the way home tonight! I really appreciate your efforts on this.

The following function looks for the text &quot;VALUE&quot; and then extracts the numbers in the text that follow it. Examples: Bonds FEDERAL NAT'L MTGE ASSN 25,000 PAR VALUE DTD 10/1/1999 8.5000% 11/15/2013 TAXPAYER ID: 04-2222222 SSB-TRUST CUSTODY DISTRIBUTION VALUE: 8,529.44 STATE STREET...

I am using the union operator to join noncontiguous ranges. I want all of the data to print on one page wide. Even if I set the page setup default to &quot;fit to one page wide by one page tall&quot;, I get each range on a separate page. What am I doing wrong? TIA Private Sub...

Has anyone run into problems with sumif{arrays} formulas returning #NA if the data range you are referencing is too large? If so, how did you work around it? I have about 1,000 rows of data and I am getting inconsistent results. Many thanks.

Brilliant! I think that's just the ticket. Thank you!

That worked. Thanks!

Ok acron, I'm with you now, but how do I delete the code in the BeforePrint event in the email?