Upload files in excel

Hi Roy,

I have had a quick scan around about how to use the save as function but most of my findings refered to creating a new workbook and using saveas to choose where to save it. I want to upload pdfs and word docs is this possible and could you kindly point me in the right direction or explain how I go about doing this?

Many thanks,

Andy

Sorry to sound daft but where or what is the saveas helpscreen?

thanks roy I will speak to you tomorrow.

Andy

Thanks for the options, I will try them out tomorrow and let you know how I get on.


cheers,

Andy

Right I have finally got round to doing this, I was wondering rather than uploading the file to a server or folder etc is there a way that people could click a button to upload a file and then select the file location as you would when saving a file normally.

BUT**** then just copy the string to the cell next to this button e.g. cell R20 and then when they click a button at the bottom which emails a csv file to HR it will also attach the file at the end of this string to the email?

Therefore I don't really need to upload it anywhere merely select a file to be attached to an email.

I found this and tweaked it and it works perfectly thanks to j-walk!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

one slight issue I have is that this code is only letting me select a folder, where as I need to select any type of file within that folder.

Does anyone know what I need to add / change / remove from the code?

What I want to do is allow users to select a file by clicking on a button then the file browser will popup. When they select a file it will return the file path to the cell "PDESC". Later on this file path will be used to attach the file to an email in the email script.

Currently as you said the code I have allows you to select a folder but not a file within a folder and so it only returns the directory path, I need to return the full file path.

Also to cofirm, in my email script if I use the cell "PDESC" as the file string for the attachment, will it work and attach the file? The file could be in any format.

Hi Roy,

That works perfectly as I intended and is much more simple than the other solution I had.

All I did was remove the msgbox at the end and set the cell I needed to = fn

Why might you want to add parameters to the getopenfilename?

Also will I now be able to use that cell with file path in to attach a file to an email?

Thanks again roy!