$$Excel-Macros$$ Advanced Filter Not Working Properly

2013-11-05 Thread Hilary Lomotey
Hello Experts, i need your expert advice, have recorded a macro using advanced filter, when you debug and run it it works flawlessly, however when i can it in a user form, it doesnt work properly, any ideas how to salvage this? .thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

RE: $$Excel-Macros$$ Calculate cogs avg basis in Excell

2013-11-05 Thread Kashan Abbas
Dear Group, Please reply .Is it possible in excell or not . From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Calculate cogs avg basis in Excell Date: Tue, 5 Nov 2013 00:30:48 +0500 Dear Expert. In attached sheet i have transaction sheet where

$$Excel-Macros$$ Querry-serial no

2013-11-05 Thread Nemi Gandhi
A excel sheet is attached. Please provide me solution to it. Thanks -- Nemi Gandhi 98204 92963 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-05 Thread Basole
hi Sandeep,try it now with the attached I added a function that checks if the file path exists, the module 1 also added to check the file type Access (mdb) or (accdb) for use with the provider Microsoft.ACE.OLEDB.12.0. If there is any related error, it is recommended to download the file:

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-05 Thread Sandeep Kumar Baranwal
Hi Basole Thanks a lot for your guidance and help. It's really appreciated. So far, I have not come across any error. Will try this VBA code on some more systems. Will let you know if I come across anything related to this or otherwise. Could you please suggest on the courses or study material

RE: $$Excel-Macros$$ Querry-serial no

2013-11-05 Thread Ravinder
PFA, r u looking for this...? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nemi Gandhi Sent: Tuesday, November 05, 2013 11:23 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Querry-serial no A excel sheet is