Search results

I created a drop down list in three cells for date, month and year using data validation. But I need these cells to display by default DD,MM,YYYY. what's the way to do it. thanks in advance

i am creating xml file in excel using macros but the code asks user to save...... Filename = Application.GetSaveAsFilename( _ InitialFileName:="myrange.xml", _ fileFilter:="XML Files(*.xml), *.xml") but i want to save it at default path and attach to mail.... *the dialog box to save...

I want to use your code for deleting all inserted pdf in my worksheet but some how its deleting only one object only...... Public Sub DelPdf() Dim oo As OLEObject Dim ws As Worksheet Set ws = ActiveSheet On Error Resume Next For Each oo In ws.OLEObjects 'Please check the progID shown for...

I got the solution for the problem:- vFile = Application.GetOpenFilename("All Files,*.*", Title:="Find file to insert", MultiSelect:=False) If LCase(vFile) = "false" Then Exit Sub Set oleObj = ActiveSheet.OLEObjects.Add(FileName:=vFile, Link:=False, DisplayAsIcon:=True, IconFileName:= _...

@shrivallabha thanks for reply !!! i want to delete a particular file say the user attaches 5 files in the excel. they should have name design1 from upload tab 1 and design2,... from upload tab 2 so that he could delete individual files. how can i upload my file here so that the...

I recorded following macro but it uses the object name "Object 89". How to change name while inserting this pdf:- ActiveSheet.Shapes("Object 89").Select ActiveWorkbook.Names.Add Name:="design1", RefersToR1C1:="=""Object 89"""

I am trying to create an application where user can upload a file say .pdf and delete the same. "how to change the attachment name in name bar so that I can refer it in my code." At present the counter changes every time I attach a file for eg. I insert a pdf xyz it gives it name "object 5"...