Search:

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

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...

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...

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

Yes, It is Excel 2003.

Regards,
John

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

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...

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

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

Thanks,
John

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...

Thanks for your suggestion..it worked.

Regards,
John

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...

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...

Works perfectly.

Thank you,
John

Is it possible to include multiple substitions in a formula?

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


Thanks,
John

Hans,

Thanks for the suggestion.

John

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...

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

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...

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...

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,

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

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...

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...

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....