Recent content by lvr5555

hai lee, Thanks for the quick reply, I am working now, i am past the school days but never used in the school :).So thought some one could help me with any ideas. Regarding the file, I have saved the file in my local folder, so I just need to call every time and check each line for the entered...

Hai all, I need some help with java script. I am fairly new to js, so can you please help me out. Here is my issue.. I am writing a java script where it need to check for some thing from a .txt file. i have a .txt file where it has the following data(P.S it has comma seperated values) The...

Guys got it. it is running i have changed to the variables i gave thanks a lot

Thanks a lot for the reply's mintjulep and gavin. Both of ur codes work. it does save mith the variable i have given . but gavin in the above message u gave me that: Basically in your existing code you can replace text such as With ActiveSheet.QueryTables.Add(Connection:= _...

any ideas please....

Thanks Gavona, this input box helps. but see i want to replace the date i give in the input field with the ones i have in the macro(see above i.e i nee d to change the date 10 times) so that it will run the macro for that date and saves the whole workbook for that date. if i add the code u...

I am not stuck, the marco i did runs but the problem is on how to run the marco for daily. i need to change the date every day. so some thing like a prompt asking for a certain date would help. please see the code below. Sub t() ' MsgBox "Please change the dates 10 times (6 times for the...

Thanks, PHV. As i have mentioned in the previous message i have the option of changing the date manually, but as this needs to done daily so i want to omit this and do some this automatic. like when i run the macro it pops a promt asking for certain date and it replaces the dates in the macro...

Thanks for the quick reply mintjulep. Actually i looked for some forums as u mentioned but no luck, can u foward me some link if u have any. thank u.

hello mintjulep, i hope he next message helps. :)

And actually here is my overall scenario. I have to do some changes in the excel daily, so the files i extract daily have a certain date like 1 sep 2008, 2 sep 2008. so i import these files and do some coulmn and row changes and rename the sheets accordingly like a 1 sep 2008 to sheet 1, b 1...

Thanks it works. Here is my issue, I have some code in the macro and now i have added the msgbox. so when i run this macro it just shows the msg box and runs the macro as usual. but what i need is after i run the macro it should show the msgbox and it should open the macro though the vba and...

Please need help in VBA. When i run a macro how can i open a dialog box with some data. need urgent. thanks