Replies

That is perfect. Thank You for you help.

I have been trying to edit the information using VBA, but I haven’t had any luck. Is it possible to edit the information using VB or VBA? If so, can you point me in the right direction? (FYI, I am trying to Synchronize all of my artist, album and genre information with having to go into each song individually)

Also is there any way to return the Bit Rate and Duration?

Outlook and Exchange would be great, but are not an option.

I will check out the controls.

Thanks,

Hi again,

I think that I am clouding the water with my explanations.

Basically, I need to know if I can download files from an Internet website using VBA without any response from the user.

My Apologies for not explaining my dilemma very well.

Thanks,

Please post any responses to Duplicate post on Excel board

Hello,

I am currently assisting with the development of an Excel Workbook for my Firm that will be using worksheets that can be imported into the Workbook on Command. The Challenge is to keep the most current version of the worksheet available to the user.

My Idea is to post the worksheets to an Intranet Website for download. However, the users cannot be relied upon to check the website and download manualy, so I need to automate. I need to accomplish two objectives.

1) The worksheets will be downloaded and stored on the Users computer, So I need to compare the files on the hard drive to the ones on the website to make sure that they are in sync.

2) I need to automaticaly download the ones that are not in Sync to the directory where the sheets will be stored, overwriting the old version.

If anyone can offer assistance, it will be much appreciated.

Thanks,

I did not know that I was not supposed to double post. I’ll know better next time.

Thanks for your response, here is some more info to help clarify.

Here is the set up for the entire

OK, it seems like you’ve tried everything else, so I will put my two cents worth in the pot. Whenever you are working with command bars from the ThisWorkbook object, it must be preceded with “Application.” as in Application.Commandbars(“TOOLBARNAME”).delete. This is true even if the actual code is in a regular module. If it is called by a macro in the ThisWorkbook object, then it must include “Application.”.
Please let me know if this is the correct answer.

Regards,

I have a way to use the Windows File Dialog box. However, like the Word Dialog box, it can only handle one file name. I need to select two files from the interface. If you would like, I could attach a file with the routine that I am using.

I usually develop in Excel and this is a piece of cake with the GetOpenFile function. I just wonder why Word does not have a similar function.

I have already tried a routine similar to this one. The problem is that I need to select multiple files.

Thanks.

Yes, I see what you are saying. But that is not what I am trying to do. I would like to emulate that functionality of the Open File Dialog box. The user will be presented with an interface to navigate to his file and when he selects it, I would like the preview of that particular file to appear on the Userform. The utility that I am building will import an exsisting spreadsheet into my utility, so the file that is selected will always be an .xls file. I just want the user to have a visual of the file that he selected.

Thanks

I am not sure what you mean by use the CopyPicture method. Could you provide a few lines of sample code? or elaborate?

Thanks.