Search results

I will pay in PayPal account Planned to pay for this project

I have made some in the attachment and now I want these things as mentioned below: You have to create a workbook with these sheets: 1- Bond portfolio which contains bond investment transactions with their critical information (identifier, coupon rate, nominal, maturity date, issue date, coupon...

Sir plz help me out with the post http://chandoo.org/forum/threads/problem-using-refreshall.35173/

I recently made a development on file search on excel 2013 but i am getting an error when using it with excel 2007 with the activeworkbook.refreshall Please help me out Check attachment for the code Thanks in advance

Bro thanks a lot you saved my time.

I am getting an error when i make changes to this code: Shell "cmd.exe /c D:" & " && dir /s G:\123\12414.ps > txt.xls" to this: Shell "cmd.exe /c D:" & " && dir /s G:\123\" & textbox1.Value & ".ps" > txt.xls i am just using textbox1 value from a variable Please help me Thanks in advance

Sub M_snb() Dim a As Variant a = InputBox("search here") sn = Split(CreateObject("wscript.shell").exec("cmd /c Dir ""E:\YY\*.jpeg"" /s /a /b").stdout.readall, vbCrLf) Sheets(1).Cells(1).Resize(UBound(sn) + 1) = Application.Transpose(sn) End Sub in this code i want to add a value of "a"...

Thank you all of you done this and sorry vletm

shrivallabha sir how can i include subfolders and can find a file with a input box. and i also need Location of file in C column Sir please help me

I want a vba code altenative to application.filesearch. Which can find from a specific folder and include subfolders. and first a input box will come where the file name is been entered. and the vba code will search from the folder. and the A column will contain the location of folder or...

So bro can you please provide me edited code Could you do that?? Actually i cant uderstand where to to put what

i am sorry

vletm --> grandmother I think all things is missing. can you edit the code according to my needs and then gimme

Bro i dont think that the file will in the specified path and i have a doubt that does it contain n+1 formula applicable inside the text file

Thank you but i have used it but not able to check n+1 by it.

IF command should contain the n+1 value that check is it applicable to the txt file or not

Anyone please help me with it

no bro i tried doing it

No problem Can U solve the problem of mine

No bro the text file will consist n+1 where n<7 n=0,1,2,3,4,5,6,7+1 OK Uploaded file named key.txt which the code will help in finding it, which consists of value n+1 BUT in uploaded file it consists the value 1 which can be written as n+1(where n=0+1 which gives 1)

the code will find a text file in a specified path with the value n+1 Now its ok Did u understand

I need a vba code to be applied on my vba project. Which will find a text file in a specified path with the value n+1. if it exist the program will go on otherwise it will close. Something like this Dim txt As String, FilePath As String, n As Integer FilePath = ThisWorkbook.Path &...

I have made an excel implementation. I have to make a new development in it to make it secure from others. I want the program to check a text file with 1 (or applicable with n+1 formula) if it exist with the value 1 (or n+1 formula) so the workbook will proceed otherwise it will end. Anyone...