Search:

Type: Posts; User: fdegree

Page 1 of 3 1 2 3

Search: Search took 0.02 seconds.

  1. Re: Programatically Change Number Values In A String

    Thank you for that suggestion. It looks like it should work. But, after a lot of research, I learned about Regular Expression (regex) and created this code, where the Rnge was defined earlier in the...
  2. [RESOLVED] Programatically Change Number Values In A String

    I am using VS 2008, and coding in VB.Net for an Excel 2007 Add-In.

    I am looping through a range of cells and programatically changing the value within the cell. I have the code to accomplish this...
  3. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    That's exactly what I am looking for. Such a simple solution that never occurred to me...as usual.

    THANK YOU!!! Sorry for not putting it all out there in the beginning. I'm sure I made this more...
  4. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    Thank you for your input. I truly do appreciate it.
    In an attempt to keep things simple, I probably complicated it by only providing what I thought would the bare minimum needed. It appears I am...
  5. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    Thank you for helping....

    Your above code does exactly what I want, using VBA.
    However, when converting to VB.net, the " Selection " object is not recognized.
    The formula part, I think I got...
  6. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    Thank you!

    I'll work with this and see what I come up with.

    One thing I have noticed.... UsedRange ....seems to return any cell that has data in it. But, what I'm looking for is the code that...
  7. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    Thanks for responding Chris...

    1) the User has an Excel workbook open and a certain worksheet....Sheet1
    2) the User selects any Range of Cells
    3) the User clicks a Button on the custom Ribbon...
  8. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    When I assign the cell range through code and the formula through code, it works just fine. As follows:



    Dim rng As Range
    Dim cel As Range

    rng = ActiveSheet.Range("A1:A10").Cells

    For...
  9. [RESOLVED] Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    I am using VS 2008, and coding in VB.Net for an Excel 2007 Add-In.

    After the user selects a range of cells, they can open a form where they are asked to enter a custom formula into a text box....
  10. Re: VB.Net To Find Excels Total Page Count

    I got it to work!

    I used Pete's recommendation:

    sht.PageSetup.RightFooter = "Page &P of " & PgCnt


    I tried this after Pete made the suggestion, and it gave the same results as I...
  11. Re: VB.Net To Find Excels Total Page Count

    Here is something even more puzzling...

    I added this code:


    Dim WrkShtPgCnt As Integer

    If .pagesetup.pages.count > 1 Then
    WrkShtPgCnt =...
  12. Re: VB.Net To Find Excels Total Page Count

    This is called from a button click event on a custom ribbon.
    It's copied from your example, so it is almost identical.



    Dim xlWB As Excel.Workbook
    Dim j As Integer
    ...
  13. Re: VB.Net To Find Excels Total Page Count

    I can't figure out what I'm doing wrong, but I continue to get the exact same results as I described above in post 10.
  14. Re: VB.Net To Find Excels Total Page Count

    This has been very helpful...I'm making progress. There is one problem I'm having with vbfbryce's code.

    If there is a worksheet with more than 1 print page, each print page is given the same page...
  15. Re: VB.Net To Find Excels Total Page Count

    vbfbryce -- that is working perfectly to count the number of print pages, in the workbook, that are located after the TOC...Thank You! But, it does not change the total page count in the...
  16. Re: VB.Net To Find Excels Total Page Count

    Thanks for the input, it is truly helpful. I see where that can determine the page count. My vision was to try and find Excels internal total page count, and offset it with code.

    Maybe this...
  17. [RESOLVED] VB.Net To Find Excels Total Page Count

    I have a workbook that has a Cover Page, and various other worksheets, prior to the Table Of Contents. The first worksheet after the TOC is assigned the page number of "1". I'm using this VB.Net code...
  18. Re: Placing Text From A .txt File At The Cursor Position

    Thanks for sharing...I sincerely appreciate it.
  19. Re: Placing Text From A .txt File At The Cursor Position

    Yes, I would be curious to see the code...THANKS!
  20. Re: Placing Text From A .txt File At The Cursor Position

    Thanks for that suggestion. Maybe I'll play around with this idea.
  21. Re: Placing Text From A .txt File At The Cursor Position

    Thank you for that information. That's unfortunate, I was hoping to make this feature more customizable for the user.
  22. Re: Placing Text From A .txt File At The Cursor Position

    Thank you for that suggestion...

    That code modification is placing the text in the active cell, and it will place the text immediately after any content of the cell, which is certainly an...
  23. Placing Text From A .txt File At The Cursor Position

    Using VB.net to create a custom Ribbon in Excel. I am trying to get the text content from a .txt file, and place it in a an Excel cell, without losing any existing content of that cell. So, I think...
  24. Re: How To Prompt For Overwriting .txt Files

    Thank you! I thought I tried changing <True> to <False>, and didn't see any difference in the behavior of the results. But, I must have been missing something, because it now overwrites the text...
  25. [RESOLVED] How To Prompt For Overwriting .txt Files

    I am using VB.net to allow the user to create buttons on the custom Ribbon. These buttons will insert commonly used notes into their report, so the user will not have to rewrite them every time. My...
  26. Re: How to Import A Picture Into An Excel Worksheet Using VB.net

    THANK YOU...THANK YOU...THANK YOU!

    That worked. Here is the exact code that is working for me:

    Dim CVRSheet As Worksheet
    CVRSheet =...
  27. Re: How to Import A Picture Into An Excel Worksheet Using VB.net

    Thanks westconn1...

    When I try to transpose the VBA code .net, here is what I have:

    Dim CvrSheet As Worksheet
    Dim TOCSheet As Worksheet
    CvrSheet =...
  28. Re: How to Import A Picture Into An Excel Worksheet Using VB.net

    Thank you 3com for the input. I was truly hoping to simply copy the image from "Sheet1". But, since I was unable to figure that out, I kept working at it until just now finding a solution...

    I can...
  29. Re: How to Import A Picture Into An Excel Worksheet Using VB.net

    I have continued to work on this, and here is what I have so far...

    I recorded a Macro to see how that code looked, and here is that Macro:

    Sheets("Sheet1").Select
    ...
  30. [RESOLVED] How to Import A Picture Into An Excel Worksheet Using VB.net

    I want to insert a picture into cell A1 on a worksheet that is labeled "TOC". This picture can be grabbed from one of 2 places:

    The image is currently on the worksheet labeled "Cover"...so I can...
  31. Re: How To Programmatically Change The "First Page Number" Value In The Page Setup Di

    I figured it out.


    Dim xlWorkSheet As Excel.Worksheet

    xlWorkSheet.PageSetup.FirstPageNumber = ...Whatever value you want it to be
  32. [RESOLVED] How To Programmatically Change The "First Page Number" Value In The Page Setup Dialog

    I have some VB.net code that is generating a table of contents, and depending upon the length of the table contents, determines the page number of the first sheet after the table of contents. In...
  33. Re: [RESOLVED] How To Call Excel Function From VB.net -- Decimal Increase and Decre

    Excellent information from both of you!

    I sincerely appreciate it.
  34. Re: How To Call Excel Function From VB.net -- Decimal Increase and Decrease

    Thank you! That also work beautifully!

    Does any one have any thoughts about:
    What is the likelihood of Microsoft changing the ID numbers in future versions of Excel? Which would obviously make...
  35. Re: How To Call Excel Function From VB.net -- Decimal Increase and Decrease

    Thank You! That worked perfectly! This is exactly what I was looking for.

    It creates 2 questions in my mind though:

    How do you find the ID numbers of each control?
    What is the likelihood...
  36. [RESOLVED] How To Call Excel Function From VB.net -- Decimal Increase and Decrease

    I'm using VB.net to create a custom ribbon in Excel. Among other things, I'm trying to place some of our most used functions on this menu, so we don't have to keep bouncing between ribbons.

    One of...
  37. Replies
    0
    Views
    782

    Having Trouble With Merged Cells In Excel

    I am using VS 2008, and coding in VB.Net. I have created an Excel 2007 Ribbon Add-In.

    I want a button click event to perform a loop through each cell, in each row, of the active worksheet....
  38. Re: Having trouble converting this VBA code to VB.Net

    I understand. Thanks for your suggestions
  39. Re: Having trouble converting this VBA code to VB.Net

    I may be mistaken here, but I think the first version with Ribbons was Excel 2007. Also, I think, the Ribbon Add-In I'm creating for 2007 will work on any newer version...it certainly is working...
  40. Re: Having trouble converting this VBA code to VB.Net

    I think I understand what you are saying.

    Am I wrong in thinking that the ribbon add-in won't work for anything older than Excel 2007, because of the ribbon design changes that occurred in the...
Results 1 to 40 of 87
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width