Search:

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

Page 1 of 15 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    9
    Views
    605

    I didn't get the help I needed on this thread. ...

    I didn't get the help I needed on this thread.

    But I did go out and experiment. For future readers:

    1) I formatted a thumbdrive as NTFS.
    2) I loaded an actual folder tree onto that thumbdrive....
  2. Replies
    9
    Views
    605

    Oh yeah, they're really different. A shortcut...

    Oh yeah, they're really different.

    A shortcut is a file, and it's mostly about navigating through Explorer. You click the shortcut, and it takes you somewhere else. So you could have a project...
  3. Replies
    9
    Views
    605

    Thanks riffraff. This is getting closer to what I...

    Thanks riffraff. This is getting closer to what I need.

    It sounds like you're saying that the symlink would be stored in the file system on on the device and not on the hard drive of the PC where...
  4. Replies
    9
    Views
    605

    Thanks, but that's not it. (But I do use this...

    Thanks, but that's not it. (But I do use this workaround for other purposes :)

    I'm thinking something like how iTunes works (but I have multiple programs with this issue).

    I have a portable...
  5. Replies
    9
    Views
    605

    Symlinks on portable media

    I know there are a variety of harder and softer links. I'm flexible about what to use, so be specific if you can.

    I have data on portable media. And I want to put links from one spot on that media...
  6. Replies
    4
    Views
    249

    Bingo. Sorry about that. I just copied my example...

    Bingo. Sorry about that. I just copied my example from the first post.

    I am good to go ... although I'm always interested in reading alternative solutions.
  7. Replies
    4
    Views
    249

    I think the first one suits my purposes best. ...

    I think the first one suits my purposes best.

    It's not quite working though.

    Following the examples in my first post, I created a Word document containing:

    €™ '
    €œ “

    Here's the first...
  8. Replies
    4
    Views
    249

    Word: Batch Find and Replace

    I'm using Word 2013 on Windows 8.1.

    Is there a way to set up something like a hash of items I'd like to find and replace that I could use on multiple documents?

    For example, I am scraping data...
  9. Replies
    8
    Views
    272

    Thanks MartinM: this workaround will do what I...

    Thanks MartinM: this workaround will do what I need.

    But I'm intrigued by Rory's suggestion. This definitely works for 2 digits. But I'm not sure how to get it to work for 3 digits. For example,...
  10. Replies
    8
    Views
    272

    Thanks Rory: yes, I use a fixed-width font in...

    Thanks Rory: yes, I use a fixed-width font in Excel. So is there a placeholder that will work?

    MartinM: Yes, of course I could left-align the cells ... but the whole reason for asking the question...
  11. Replies
    8
    Views
    272

    Sorry ... that looked good in the composition...

    Sorry ... that looked good in the composition window, but not so good when posted.

    My columns will be centered.

    I want the digits to line up like this:

    3a
    4

    But what I get is the 4...
  12. Replies
    8
    Views
    272

    Custom Format Placeholder

    I'm using Excel 2013 on Windows 8.1.

    I'd like a placeholder that will show a blank to the left of the decimal, but to the right of the digits.

    What I want is to be able to line up 3a and 4 over...
  13. Replies
    23
    Views
    1,140

    I haven't forgotten about this ... just swamped...

    I haven't forgotten about this ... just swamped with a different project.
  14. Replies
    23
    Views
    1,140

    Oh gosh ... I missed a big problem. This...

    Oh gosh ... I missed a big problem.

    This spreadsheet is used for grades. It gets wider through the semester. The named ranges I have pre-defined expand as I add grades to their interiors, always...
  15. Replies
    23
    Views
    1,140

    This is a big help, and I'm learning a lot. ...

    This is a big help, and I'm learning a lot.

    Here are some of the issue I've come up with.

    1) The code fails badly if there's a blank cell in the middle of column B. The general plan is to have...
  16. Replies
    23
    Views
    1,140

    1) The current exportHTML macro exports 2 named...

    1) The current exportHTML macro exports 2 named ranges from each sheet as individual HTML files, so 6 worksheets in my workbook yields 12 files on my desktop.

    2) Your SortPart macro runs, but I'm...
  17. Replies
    23
    Views
    1,140

    Fair enough. But I don't know how to do that....

    Fair enough. But I don't know how to do that. Thus the thread.
  18. Replies
    23
    Views
    1,140

    Reply to Maudibe: This isn't quite right. I don't...

    Reply to Maudibe: This isn't quite right. I don't want to permanently delete the information in those cells. All I want to do is export an HTML file in which those values are blanked.

    Reply to...
  19. Replies
    23
    Views
    1,140

    Try this. It's an xlsm based on the xlmt.

    Try this. It's an xlsm based on the xlmt.
  20. Replies
    23
    Views
    1,140

    I've attached another file. It's an xltm from...

    I've attached another file. It's an xltm from Excel 2013.
  21. Replies
    23
    Views
    1,140

    I only included a stub spreadsheet because the...

    I only included a stub spreadsheet because the real one is large. I figure the solution I need doesn't need all that detail.

    I am not wedded to this suggestion, but I think this is what I would do...
  22. Replies
    23
    Views
    1,140

    Modifying a macro

    I have two Excel macros that I often run consecutively. I need to filter the results in the second one.

    The first does a sort over a named range:


    Application.Goto Reference:="Sort_Block_1"
    ...
  23. Replies
    5
    Views
    247

    Thanks a bunch. I'm actually parsing through...

    Thanks a bunch.

    I'm actually parsing through a matrix that's written out as a vector. And I can replace the count() with a large integer, since what I'm counting up has to all fall within a...
  24. Replies
    5
    Views
    247

    Need confirmation ... I believe I have solved...

    Need confirmation ...

    I believe I have solved this problem by changing the count(A:A) bit to count(A2:A$786434) for an entry in row 2.

    Am I missing anything that anyone can see?
  25. Replies
    5
    Views
    247

    Promising (seems OK at the top). But ... it...

    Promising (seems OK at the top). But ... it returned a #REF! from row 262,600 downward.

    I think I know where the problem is, but I'm not sure how to address it.

    Because there are 786,435 rows...
Results 1 to 25 of 360
Page 1 of 15 1 2 3 4