Re: $$Excel-Macros$$ BeforeSave not working

2015-05-04 Thread Vaibhav Joshi
was macro was enabled on your system? On Tue, May 5, 2015 at 1:14 AM, mburkett wrote: > One more oddity. I opened the file on another computer on our network and > it worked perfectly. Both have the same rights so there must be some > setting within Excel? Ideas? > > > On Monday, May 4, 2015 at

$$Excel-Macros$$ Repeat/Continue Action till error/not found

2015-05-04 Thread Sundarvelan N
Dear Friends, Please help me to repeat/Continue the below action till it reach error OR not found . Cells.Find(What:="physician", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).A

$$Excel-Macros$$ Help with VBA + Oracle

2015-05-04 Thread Diego Venuzka
Hi! I'm trying to connect a Excel file into a Oracle Database, for make updates in some tables. But i get the same error, again and again, in the last 4 hours. The error is attached. What i've done: - Installed the ODBC driver in the Control Panel - Checked the "Microsoft Activex Data 2.7" option

Re: $$Excel-Macros$$ BeforeSave not working

2015-05-04 Thread mburkett
One more oddity. I opened the file on another computer on our network and it worked perfectly. Both have the same rights so there must be some setting within Excel? Ideas? On Monday, May 4, 2015 at 1:49:16 PM UTC-4, mburkett wrote: > > I need it to do the macro every time the file is saved. Also

Re: $$Excel-Macros$$ BeforeSave not working

2015-05-04 Thread mburkett
I need it to do the macro every time the file is saved. Also I tried your code and tried saving and closing the file. In both instances, it didn't run the code. Could there be some setting I am missing in security ect? On Monday, May 4, 2015 at 1:22:12 PM UTC-4, Vabz wrote: > > Change 1st line t

Re: $$Excel-Macros$$ BeforeSave not working

2015-05-04 Thread Vaibhav Joshi
Change 1st line to.. Private Sub Workbook_BeforeClose(Cancel As Boolean) Cheers!! On Mon, May 4, 2015 at 10:32 PM, mburkett wrote: > I have some very simple code that I put in the workbook's BeforeSave > event. When I click save the code doesn't run. Any ideas? I've never used > these private

Re: $$Excel-Macros$$ Exact Search excluding fractions

2015-05-04 Thread Vaibhav Joshi
when you do filter, in criterion put is equal to... also when you do search thru Control plus f ( ctr + f) click on options & tick on match entire cell content .. On Sat, May 2, 2015 at 12:52 PM, Zafar Iqbal wrote: > Dear Experts, > > I am trying to use (SEARCH and Vlookup) formula to filter ou

Re: $$Excel-Macros$$ formula required

2015-05-04 Thread Vaibhav Joshi
Author need formula & i guess this is already answered for similar question.. On Sun, May 3, 2015 at 7:37 PM, Rajesh Agarwal wrote: > please provide me the formula. > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

$$Excel-Macros$$ BeforeSave not working

2015-05-04 Thread mburkett
I have some very simple code that I put in the workbook's BeforeSave event. When I click save the code doesn't run. Any ideas? I've never used these private subs so I may need to change a setting??? Here is the code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Re: $$Excel-Macros$$ Re: Exact Search excluding fractions

2015-05-04 Thread Ganesh N
Dear Mandeep, Can you please explain how you did this ? or can you give the password for the respective code. Thanks & Regards, Ganesh N On Mon, May 4, 2015 at 12:08 AM, Mandeep Baluja wrote: > Check this Out. > > Regards, > Mandeep Baluja > Email :-mandeep.bal...@snapdeal.com > mandeep.bal...