Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    3,858

    Is there an Excel VBA solution to load/copy an...

    Is there an Excel VBA solution to load/copy an Excel file to an SFTP?

    I know the particulars such as SFTP Server name, UserAcct, Password and etc.

    Thanks,
    John
  2. Replies
    2
    Views
    662

    I am familiar with Windows Dir(oPath,"*.JPG) but...

    I am familiar with Windows Dir(oPath,"*.JPG) but am having difficulty with Excel 2004 for Mac.

    Excel 2004 does not use wildcards for Mac but utilizes the MacId of the file.

    Here is an...
  3. Replies
    103
    Views
    12,455

    I was quite surprised with this news. As others...

    I was quite surprised with this news. As others have said Hans will truly be missed.

    When I would log into the Lounge, I would first look to see if Hans was on-line knowing that a solution was...
  4. Replies
    7
    Views
    614

    I have an interesting delimma; when I right click...

    I have an interesting delimma; when I right click on it I receive the following error message.

    Is there a fix to the registery that can be made?

    Thanks,
    John
  5. Replies
    7
    Views
    614

    Yes, It is Excel 2003. Regards, John

    Yes, It is Excel 2003.

    Regards,
    John
  6. Replies
    7
    Views
    614

    In Excel's window to open a file, I created a...

    In Excel's window to open a file, I created a favorite and added it to "My Places". How does one remove the favorite?

    Thanks,
    John
  7. Replies
    13
    Views
    9,973

    I found something online: Public Function...

    I found something online:


    Public Function EOMonth(InputDate As Date, Optional MonthsToAdd As Integer)
    ' Returns the date of the last day of month, a specified number of months
    ' following a...
  8. Replies
    13
    Views
    9,973

    Is there a VBA solution for the Excel formula...

    Is there a VBA solution for the Excel formula "=EOMonth(MyDate,0)"

    Where the variable MyDate = 12/13/2009

    The expected results would be 12/31/2009

    Thanks,
    John
  9. Replies
    4
    Views
    571

    Is there a function with in Excel that returns...

    Is there a function with in Excel that returns zero for a undefined computation such as in 100 / 0?

    Thanks,
    John
  10. Replies
    3
    Views
    1,340

    Courtney, Thanks for your response. Your...

    Courtney,

    Thanks for your response. Your suggestion only addresses the backup process of the Time Capsule; pointing to another drive and creating sparsebundles.

    If you recall, TC can also be...
  11. Replies
    3
    Views
    1,646

    Thanks for your suggestion..it worked. ...

    Thanks for your suggestion..it worked.

    Regards,
    John
  12. Replies
    3
    Views
    1,340

    Is it possible to image the Apple Time Capsule...

    Is it possible to image the Apple Time Capsule hard drive?

    I would like to take an image and put it on a USB External Drive. The price of the USB Drives have come down considerably and it would...
  13. Replies
    3
    Views
    1,646

    I have about 1,000 incoming messages and one of...

    I have about 1,000 incoming messages and one of them is unread. Is it possible to locate that one message either by sorting or some other means?

    I have tried paging down through the various...
  14. Replies
    2
    Views
    375

    Works perfectly. Thank you, John

    Works perfectly.

    Thank you,
    John
  15. Replies
    2
    Views
    375

    Is it possible to include multiple substitions in...

    Is it possible to include multiple substitions in a formula?

    Example:
    =SUBSTITUTE(A1,"SwapText_01","") or =SUBSTITUTE(A1,"SwapText_02","")


    Thanks,
    John
  16. Replies
    4
    Views
    544

    Hans, Thanks for the suggestion. John

    Hans,

    Thanks for the suggestion.

    John
  17. Replies
    4
    Views
    544

    I am looking for software that I can use for...

    I am looking for software that I can use for documenting proceedures and thought it would be nice to put it in a format similar to what I have seen with "help topics". I have attached a screenshot...
  18. Replies
    4
    Views
    566

    Hans, I tried your suggestion and it returned...

    Hans,

    I tried your suggestion and it returned a "#Value"; referencing another file. I then tried it within the same workbook; different sheet and received the #Value as well.

    Regards,
    John
  19. Replies
    4
    Views
    566

    I am having a challenge with the criteria formula...

    I am having a challenge with the criteria formula for an advanced filter.

    The file/range where the formula points to contains formulas which return values. My challenge is that data is being...
  20. Replies
    4
    Views
    435

    You probably haven't followed Steve's...

    You probably haven't followed Steve's instructions entirely correctly. See the attached version.


    Sorry, my error as I did not leave F1 blank as instructed by Steve. All is well.

    Thanks Steve...
  21. Replies
    4
    Views
    435

    Set your criteria to only F1:F2 F1 should be...

    Set your criteria to only F1:F2

    F1 should be blank (since F2 will have a formula)
    F2 should have:
    =NOT(ISBLANK(B2))

    Steve

    Hi Steve,
  22. Replies
    4
    Views
    435

    I'm having a challenge with an Advanced Filter;...

    I'm having a challenge with an Advanced Filter; specifically the criteria.

    I have attached a sample file with the expected results highlighted in green.

    Thanks for taking a look,
    John
  23. Replies
    1
    Views
    317

    I have a workbook with a couple of sheets that I...

    I have a workbook with a couple of sheets that I want to add to a new workbook. My challenge is that one of the sheets being copied to the new workbook is keeping a reference to the original...
  24. Replies
    2
    Views
    383

    I have VBA code that copies various files from a...

    I have VBA code that copies various files from a Source location to a Destination folder. When ever a file is being saved by someone and the code tries to copy the file, I receive a message box...
  25. Replies
    4
    Views
    468

    I tried it on my PC, and it worked fine with...

    I tried it on my PC, and it worked fine with spaces in the file name.
    Are some of the files read-only, perhaps?

    Great observation! Now I'm embarrassed....
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4