Search:

Type: Posts; User: KenCriss; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    427

    Using Wildcards in Substitute function

    I have tried to use the Substitute function to replace part of a file. I need to do this in VBA with a UDF or something.

    I want to search for this string (the characters between < employeeid ><...
  2. Re: If Chip Pearson's website ever helped you, please jot a note...

    Wow! Just saw this and so sad to hear. Condolences to the family. Can't say how much Chip's site has saved me over the years. So easy to follow and great examples. RIP Chip!
  3. Replies
    2
    Views
    230

    Re: VBA function naming

    Try putting an underscore in it

    Function TT_22221(a As Double) As Double
    TT_22221 = WorksheetFunction.Log10(a)
    End Function
  4. Replies
    4
    Views
    184

    Re: Loop With If Then Statement

    Maybe baseValue is returning something other than a number?
  5. Replies
    2
    Views
    155

    Re: Help Importing Text File

    What format is the text file in? Fixed length? Delimited?
  6. Replies
    0
    Views
    199

    File/Directory search issue

    Hello coders - I am using the following code to search for files. ListFiles() does a great job if you don't want to search subdirectories. However, if the user does want to search subdirectories...
  7. Re: Populate Userform with spreadsheet data, then Edit it

    The .Locked property was the issue. thanks for the help!
  8. Populate Userform with spreadsheet data, then Edit it

    I am sure there is a way around this but I have not figured it out.

    I am populating a Userform with data from one of the sheets in the workbook. I want the user to be able to edit the textboxes...
  9. Saving a UTF-8 files without Byte Order Mark (BOM)

    Hi folks - I use the code below to save a regular text file as a UTF-8 file. The code works great...except the application that needs the file does not allow the BOM (byte order mark) to be at the...
  10. Re: How to traverse folders and files on SharePoint with Excel VBA

    Thanks for all the ideas. I keep trying to find what they replaced it with for 2010 but have not found any answers yet. I will answer back if I find anything.
  11. Re: How to traverse folders and files on SharePoint with Excel VBA

    I am using Excel 2010, but the "seed" file definitely opened...but maybe it opened not as a sharepoint file but as a "downloaded" file for lack of a better term. It definitely blew up on the line...
  12. Re: How to traverse folders and files on SharePoint with Excel VBA

    For some reason I am getting an "Object variable or With block variable not set" error on this line.


    Set swsFiles = wb.SharedWorkspace.Files


    Anyone know why?
  13. Replies
    9
    Views
    357

    Re: INDEX/MATCh or some other combination?

    Yes, I tried the Pivot too and I agree that is much faster/easier.
  14. Replies
    9
    Views
    357

    Re: INDEX/MATCh or some other combination?

    that worked! Had to throw an ISNA in there to handle those with missing years, but it did what I expected. Thanks again.
  15. Replies
    9
    Views
    357

    Re: INDEX/MATCh or some other combination?

    If my salary is in column G why is the indexing on column G? I would have thought the index would be on SSN which is in column B...?
  16. Replies
    9
    Views
    357

    Re: INDEX/MATCh or some other combination?

    I'll try that. Thanks!
  17. Replies
    9
    Views
    357

    INDEX/MATCh or some other combination?

    I have rows and rows of salary information. Many rows person. SSN is the employee key. On a separate tab, I want a single row per employee with the salaries in linear display so that SSN is in...
  18. Replies
    2
    Views
    762

    Re: Return values for SaveWebFile

    I'll try it. thanks!
  19. Replies
    2
    Views
    762

    Return values for SaveWebFile

    Found this piece of code which works well for downloading files from the web but am wondering if anyone know the return values...



    Function SaveWebFile(ByVal vWebFile As String, ByVal...
  20. Re: Maintaing Text Qualifiers on CSV file passing through Excel

    Joe - I have used parts of this code to export data from excel. This is overkill for what you need, but it is pretty handy....
  21. Replies
    2
    Views
    259

    Re: Splitting a text field into an array

    Thanks! That got me close enough that I could use it.
  22. Replies
    2
    Views
    259

    Splitting a text field into an array

    I need to read a line from a text file that is 1072197 characters long. I need to split it into an text array that consists of every 80 characters and then put it on a worksheet. I know I have done...
  23. Replies
    2
    Views
    637

    Re: A registered XLL not working

    Perfect! :biggrin:
  24. Replies
    2
    Views
    637

    A registered XLL not working

    We are collaborating with another office and using some add-ins (xlls) that they produced. We can get the XLL's registered - - however when using some of these spreadsheets that call functions...
  25. Replies
    1
    Views
    276

    Re: Calling a Sub or Function in my Project

    Never mind. I figured it out. I have to add my project under Tools/References. If I had thought about it for a minute before asking I would have figured it out. Oh well. Maybe it will help...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4