Search results

Hello! Please advise me on the below scenario. Plan: I would like to prepare a questionnaire in Excel using VBA, One question for one sheet, probably 20 sheets will be there. When the user start the test, a timer will be running on "A1", if the time value > 60(1 Minute) then it will go to the...

Hi could you please give your sugesstion.

Colud you please advise me.

The email template link: http://db.tt/qY7vuFk4 Sample attachment link: http://db.tt/vGuA67Rq

Hi All, I have an email template that i got at Chandoo.org. It is working very well. Thanks for all your support of all Chandoo's:). And i need a help on that. When i attach some files it gets the path of the file name and the same has been attached while sending the email. The attached...

Hi Dhamo, Yes it's working fine. Thank you Dhamo. Regards, Vargeesh

Hi, I used the below code to display the current username while opening the workbook. Private Sub Workbook_open() MsgBox "Hello " & Environ("Username") & "!", vbInformation, "Welcome Note" End Sub It's working fine. But it gets the userid instead of...

Of course Deb. I will do google search. Thanks for your advice. The code is: http://www.2shared.com/document/KDM-RKuk/Fiepath.html

Yes Deb, I found just before.. Here is the code. http://www.2shared.com/document/KDM-RKuk/Fiepath.html Thanks for you..

Hi Ded, Thanks for your answer. Since I am not much aware of it I asked the question. If there is solution please let me know Thanks, Vargeesh

Hi, I used to send emails from excel using outlook. When I send emails it displays a security prompt to send or not send the message. It is okay when I send up to five messages. But at the time of 100 emails for each email I need to confirm the security prompt. It will be helpful if I...

Hi Deb, Thanks for your suggestion. Please find the below link. http://www.2shared.com/file/j5nCijSr/FilePath.html The code you have mentioned searches a file alone. But I need to get all the file path within a selected folder irrespective of file extensions. Regards!

Hi Luke, When I execute the below code it thrown an error like "Run time error'445': Object dosen't support this action". And it was highlighted on Set fs = Application.FileSearch Sub ListAllFiles() Dim fs As FileSearch, ws As Worksheet, i As Long Set fs = Application.FileSearch With fs...

Hi, I ran the below code to get the file path. By selecting the file it retrieve the file path. Sub GetFilePath() FilePath = Application.GetOpenFilename("Excel Files (*.xls), *.xls") If FilePath <> False Then Range("F5").Value = FilePath End If End Sub But I wish to...

Luke it works well! To change the from address: .SentOnBehalfOfName = abc@abc.com My code is: With OutMail .SentOnBehalfOfName = cell.Offset(0, -1).Value Thank you so much for your assistance from flower to fruit. With Thanks, Vargeesh M

Hi Luke, Now I am able to send the emails using excel. Thanks for your kind advise. And one thing, when I send the emails I need to send from a different account. Which means from generic email Id. So, I have to change the "From" address when there is a need. I tried with the below code...

Thank you so much Luke! It works well. And I need to add "CC" in my email. Please advise me. Thanks!

Hi, I have 200 pdf documents and the name of the documents is from 1 to 200 in a folder(Names of the docements like 1, 2 , 3, ... 200) I need to send each of the documents in 200 separate emails to the same receipient with the same message body but with the different attachment. Can you...

Hi Narayan/elhamdkh, Thank you for your reply. I didn't mentioned any path in my code. The macro is running fine, If i choose under Developer > Macros. But what i have done is, I have created a new Tab using File > Options > Customize Ribbon > New Tab and then New...

Hi, Good evening to all. Can you please someone give me a solution for the above. Thanks!

Hi, I had created a macro file and saved on my desktop. It was working fine. After i copied the file to my hard disk and tried to run the macro. It was thrown an error message stated that [Cannot run the macro "C:UsersVargeeshDesktopFormatting_Template.xlsm'!selectfile. The macro may not...

Hi Krishna, Thank you for your help krishna. It is working:). Regards, Vargeesh

Hi, I am running a macro coding in an excel file. In that excel file Column "A"(Old date) has past date. Also there are three blank columns named as:- Column B = "TODAY" Column C = "AGEING" Column D = "AGEING > 7 DAYS". When i run the macro it should write the formulas In...

Thank you so much SirJB7. It's working. In addition to that i want to include the below code also. http://www.2shared.com/document/De048EOU/finalformatting.html Please advice me. Thanks!

Hi, I have an excel file name as "Format" in which "Sheet1" has a command button. When i click the command button it should open the Open dialog box using the below code: Application.GetOpenFilename("excel(*.xls), (*.xls)") Then I will select an excel file and it should copy the...