filepath

Hi, I want to add a logo to a VBA userform in Excel. However I want the userform to be able to be run on any computer. When I insert a picture using the image control in the VBA Editor, it asks for a file path to find the picture to insert. This is problematic, as the picture won't be on...

I have created a form in excel via VBA It is having a textbox. I want to drag an file path in to the textbox by droping the file in the textbox. Can any body help ?

Sorry I have to restart part of my old thread. Could someone please edit this part or the whole code.. MyFile = ThisWorkbook.Path & "\Book2.xls" I want myself to enter the whole path myself like 'C\Macro and Excels trix\.. etc and not "thisworkbook.path & \book2.xls" Thanks pedie;) Sub...

Hello all, I am not to sharp at this but here goes.. I have a large excel sheet that as a large number of references to other sheets the references mainly look like... =\Site\General\CSD Self Reliability\2008-2009\Week 10\[Filler11_Wk10.xls]Wkly Downtime Sum'!T11 So this is...

I am trying to email the activework I have open using the code below: Set myOlApp = CreateObject("Outlook.Application") Set myitem = myOlApp.CreateItem(olMailItem) myitem.SentOnBehalfOfName = "S&Co - SAA Modelling" myitem.To = recip myitem.Subject = "Portfolio Modelling Request Completed"...