Recent content by money99

Thanks Geoff. It opened the document in 97 with the "take focus on click" property set to true. Vas

This is the line that fails and it is the only line assigned to the button. What it did was to automatically open a new workbook with the worksheet pasted. Workbooks("FEED2.1.xls").Worksheets("FormSheet").Copy Regards Vas

Hi there. I developed a small macro where the user fills in data on a worksheet and at the end he could press a button which copied the workbook onto the clipboard. I made this at home using office 2000 but when I took it back to work where office 97 is still used the copy method failed. Is...

Hi there. Thanks for the code. Exactly what I needed and couldn't get my head round. Nevertheless when the user opens the browser and then decides to close it or not to load a pic the whole thing crashes cause sFile is false and I need to get it safe.

The code I'm using right now is the following. Dim picpath As String Private Sub CommandButton1_Click() picpath = Worksheets("Sheet1").Range("G5").Value Image1.Picture = LoadPicture(picpath) End Sub Cell G5 contains the path to a bmp on my pc including the...

I'm using the Image1.Picture to load a bitmap at the image1 object. I want the user to input the path (or even better specifiy the path by browsing) and then load it(either automatically or by hitting a button). Right now I am declaring the path in cell and then trying to load a pic by using a...

Hi there. I'm trying to make the browsing for pics in excel faster for the user. I want to use a fixed space (like the image from the Visual Basic toolbar) and then in run time when the user wants to input a pic he will double click on the image space or a button. The problem is I dont know how...

Is there a way of pasting a vb form into an excel sheet or cell still containing all the selected items?