Search results

Sory for delay.. Actly i was in Other Activity.. Please provide alternate option for problem #1. I have uploaded 1 File on my Web site for problem #2. http://www.istiyakshaikh.hpage.com > Downloads > Lock problem.xls Plz suggest Regards !$T!

Hi.. There are two problems i m having. 1. I have added advance control (Calendar Control) in my form. when i m opening that form on my pc it is showing that calendar but when i m opening that form on another's pc it was blank. i think that might be going on due to advance control not...

Ok,,,, SirJB7 Thanks For Your reply.. plz let me know if any alternative. Regards !$T!

Hi SirJB7 I m using Excel 2003 It is Showing Run Time "438" Object doesn't support this property or method.. Regards !$T!

Hi dan_I i have upload file on my website http://www.istiyakshaikh.hpage.com > Downloads > PDF Export Any query plz let me know. regards Istiyak

Hey Chandoo, m lucky man... you had replied.. Will play and get back to u if any query... Regards Istiyak

Hi Dan_i i already type the same thing as u mentioned. bt still awaiting for solution. Regards Istiyak

Can we negotiate VBA on any error while VBA is executing. Regards Istiyak

I m using 2003 at my office and my other office using 2007. The query is that when i m designing something in 2003 and open it at my other place in 2007 it will looking mismatch..... (not at proper place as i already set up good in 2003). while i m coming back and checking it in 2003 it is...

Heeyyyy SirJB7,, I m also using the same method to learn and impliment the VBA... Kalpesh,,, good hint for you from SirJB7 Cheerrrrsssss !@@@# Regards Istiyak

Hey...,,, Congo Narayank991, Congo for your achiement as discussed above U R the next Excel Ninja I really get a good solutions from u.... never Forget u dear... Best of Luck from !$T! Regards !$T!

Wel COme

Hi Narayan and SirJB7 I Got very fantastic on above from the given link http://www.fontstuff.com/vba/vbatut07.htm Thanks for your help as well... Regards Istiyak

Can we add a Calendar Control In Forms..??

HI Luke & Xld Thanks buddy for your help. some problems have solved but some is steel there. I have entered 1 Calender Control with ( visible = False ) property.... While i m opening this excel sheet in another place where design mode turn off. it shows that Calendar directly to Viewer...

Namaste Team, I need VBA which do something on given topics. 1. Set location on SHEET1 and CELL A1. 2. Auto enable mecro 3. Auto Enable Design mode of Form COntrols. So user can start work directly, they don't have to do anything else Any idea plz let me know. Regards Istiyak

hi Narayank991 Thank a lot dear its working fine.....its something like HTML link to go on the same page but another location.. Appriciated.. Regards Istiyak

HI kalpesh If u are saying about Excel file then ...... Just protect a sheet and a workbook Nobody will change data in ur file. If any thing else plz specify.. Regards istiyak

HI Manoj Try the given code Open excel > press alt+f11 > then paste the give code Sub Manoj() Range("A5").Select Selection.Copy Range("A6").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Any query plz...

HI Shabeer {} this brackets are used for Array formulas. When u press ctrl+shift+enter together after formula it will come automatically. Any query plz let me know. Regards Isityak

Namaste Team. Plz examine the given formula and revert with the solution. =if(a1=b1,hyperlink(a1,"Check"),hyperlink(b1,"Check")) While i am clicking on it, it is going on a1 even the condiotion is false (Naturally when condition false it should go on b1). Suggest what to do.? Regards...

Hi SirJB7 i m not talking about the raising error.,, I m talking about the given line Actual line .SaveAs CurDir & "" & dirName & "" & sh.Range("A3").Value Proposed line .SaveAs thisworkbook.path & "" & dirName & "" & sh.Range("A3").Value (Hope u will understand) Plz let me know...

Hi SirJB7... Thanks For your reply... Bt the problem is that the given link is not working.. Plz upload a fresh link. Regards Istiyak

Hi SSraghunathan,,..// I m already working on it. When i will do it, then will share it with you.... Exactely you are from which org.... Regards Istiyak

Namaste Team... I want to creat 1 employee master file where i have to enter every details of employee with their photo. I am able to enter every data in database sheet with the help of mecro but having not idea to copy past image with help of mecro. Note : Image should be on fix location...