Re: $$Excel-Macros$$ .Refresh Background:-False
see if it helps
CODE:
With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _
"ODBC;DSN=PP;UID=ris;PWD=ri;DBQ=PP;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F"
_
), Array(";CSR=F;FWC=F;PFC=10;TLO=0;")), Destination:=Range("A1"))
.CommandText = sql1
.Name = "Query from PP"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
on error resume next
.Refresh BackgroundQuery:=False
End With
On Fri, May 6, 2011 at 9:58 PM, Kojovi Aka wrote:
> Forumers,
> I am having problems with *.Refresh Background:-False* statement in 2
> different codes that I inherited and has been running successfully until
> today.I am using Excel 2007.
> Has anything changed with regards to the use of this statement?
> Please help. One of the codes is reproduced below. This code has been
> running fine as is until this morning.
> Thanks
> sobavia
>
> CODE:
> With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _
>
> "ODBC;DSN=PP;UID=ris;PWD=ri;DBQ=PP;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F"
> _
> ), Array(";CSR=F;FWC=F;PFC=10;TLO=0;")), Destination:=Range("A1"))
> .CommandText = sql1
> .Name = "Query from PP"
> .FieldNames = True
> .RowNumbers = False
> .FillAdjacentFormulas = False
> .PreserveFormatting = True
> .RefreshOnFileOpen = False
> .BackgroundQuery = True
> .RefreshStyle = xlInsertDeleteCells
> .SavePassword = False
> .SaveData = True
> .AdjustColumnWidth = True
> .RefreshPeriod = 0
> .PreserveColumnInfo = True
> .Refresh BackgroundQuery:=False
> End With
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com
P Before printing, think about the environment.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
$$Excel-Macros$$ $$Excel - Macros$$ Help me to Generate report in a button Click and sent to the Manager
Dear All, I am attaching an Excel with some hypothetical data. Please help me to : - Take out the data by filtering the Managers name and paste it in a New Work Book. - Sent it to the respective managers E-Mail ID. - All the above actions should get done in a button Click. Awaiting for you valuable response. Bunch of Thanks in advance.! Thanks&Regards, *Sreekanth M *Mobile:08420642256 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Report Generation.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Please Help
*Thank you so much. I am very grateful to you. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı On Sun, May 8, 2011 at 6:59 AM, STDEV(i) wrote: > > try to use this UDF (user defined function) > Function UniqueList(Dat As Range) >' List of UnSorted Unique Values ' >'-' >Dim Cel As Range, vArr(), n As Long, Tx As String >Tx = ", " >For Each Cel In Dat > If InStr(1, Tx, ", " & Cel & ", ") = 0 Then > Tx = Tx & Cel & ", " > End If >Next Cel >If Len(Tx) > 0 Then Tx = Left(Tx, Len(Tx) - 2) >If Len(Tx) > 0 Then Tx = Right(Tx, Len(Tx) - 2) >UniqueList = Tx > End Function > > > > On Sat, May 7, 2011 at 3:50 PM, karan 1237 wrote: > >> * >> LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT >> SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT >> FRONT >> *Hi Experts, >> >> I want like this. Please help. >> >> Thnx in Advance. >> >> >> * >> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ go back to the last visited page
HI, Please see if it help.. On Sun, May 8, 2011 at 4:01 PM, Rajesh K R wrote: > Hi Experts > Is it possible to create two buttons one for forward & other for > backward and move to sheets in the order what we used after login just > like we do in a browser.Pls check the attachment > > Regards > Rajesh Kainikkara > . > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Book1.xlsm Description: Binary data
Re: $$Excel-Macros$$ HELP SECOND MAIL
sorry for confusing will cut short all the steps . i will send the recorded code , i have prepared it using Macro recording can anyone please edit that code will send today end of the day. Thanks for your help in advance. Regards, Prathima On Mon, May 2, 2011 at 1:49 PM, Mahesh parab wrote: > Hi > > it would be great if u could explain some steps; it seems confusing, keep > it as simple as you can; > which is the first step, what are the 6 vlookups ? which workbook contain > base data of your pivot. > > > On Mon, May 2, 2011 at 10:07 AM, Prathima R wrote: > >> Hi Experts, >> >> >> Due size constance i am sending in two zip folders please check second >> mail for excel files dump. >> >> (This is Second mail please check this one as well -- thanks >> for cooperation) >> >> This report is sent on daily basis please help in this concern if it is >> automated >> it could be very much thankful really wonderful thing . please find the >> attached sop and zipped folder which contains all the raw data . >> >> Please kindly help in this concern if it is possible . >> >> it has 6 v lookups and two pivot tabs. >> >> Thanks for your help in advance. >> >> Regards, >> Prathima >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Macro to monitor another Macro
I think, it is time you to study error handling procedures. Example. ON ERROR GO TO RESUME RESUME NEXT Go Ahead. Regards, Kishan Reddy, K On May 9, 1:15 am, hanumant shinde wrote: > Hey guys, > > its been 2 days but not even single reply. is it too tough or its not at all > possible. > i am not asking u to develop a macro n give it to me. just gimmi some hints to > proceed. > > i hope this is fine with you guys.i m relying on you guys a lot. > > Thanks > > - Original Message > > From: hanumant shinde > > To: Excel Group > > Sent: Sat, 7 May, 2011 1:37:54 AM > > Subject: $$Excel-Macros$$ Macro to monitor another Macro > > > Hi Guys, > > > lets say there are 2 workbooks wkbk_run and wkbk_monitor. wkbk_run has > > macro > > which runs automatically and sometimes it throws OLE error for which we > > need > >to > > > MANUALLY click OK button. i want wkbk_monitor to monitor that wkbk_run and > > whenever that OLE error occurs it should click OK automatically. i know > > there > >is > > > some API to click OK button but i dont know anything about it. > > > is it possible to create such a macro to monitor another macro. > > there are N numbers of Macros like wkbk_run so i cannot keep that code in > > all > > the workbook. so i want another macro to monitor all the macro which runs > > automatically. > > > so it will be like monitor macro will run when 1st macro starts running and > >that > > > will stop running when last macro gets over. > > > thanks guys. > > > please let me know if is it possible? > > > -- > >-- > >- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Delete raws having data above the specified period
There is no sample data in the attached file. Regards, Kishan Reddy, K On May 8, 5:22 pm, Rajesh K R wrote: > Hi Experts > > I need code to find the cells in column "A" having date above the date > specified in "C1" then select the entire column and delete it. Then > loop until all the data above the specified period deleted. > > Regards > > Rajesh Kainikkara > > Test(1).xls > 15KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Auto Refresh Data
Hi All, I am having one database which is link to the external data (Internet)... I need the VBA code where the data will automatically refresh after 30 seconds / 15 Seconds, but it should not be a loop it just a macro automatically running after 15 sec. Example : My data is refreshed at 11:44:15 time and I wanted macro to be automatically run at 11:45:30 and again after 11:45:45 then 11:50:00 and so on... Please suggest something. I am having one problem using loop here because while macro is running in background I can't able to work on other files and I wanted that macro to be run at background and I should able to run on the files. Is there any way to do it.. Thanks & Regards, Anil Bhange IP - 512320 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Hi
Please send some cheats for excel Sent on my BlackBerry® from Vodafone -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Access Problem
Hi Yogesh, My guess is that the SQL generated by MS Query for your specific data connection is wrong. Normally in SQL the '*' is used as an 'ALL' so that you would have SQL like the following: SELECT * FROM Thats the basic select statement. If the syntax is wrong somewhere the SQL cannot be processed by MS Query, and you will see an error similar to what you have described. Are you able to post the SQL that MS Query is generating in its attempt to get external data? I can probably correct it if it is not too complex. Cheers The Frog -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Need Macro help to copy paste the each column data in one column
Hello team, Could you please help me for the below scenario: Need a code to copy paste column data under one column and keep the same description. A B C bangmysore jan 645 978 feb 645 mar978 it should be realigned like below: no of rows and column keep adding need to looping. AB C bang jan 645 bang feb bag mar 978 mysore jan 978 mysore feb 645 mysore mar thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Need macro help to copy paste each column data under one column
Hello Team, could you please help me with the below file. explained the problem in the attached file. Thanks, Vinod. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel question1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ go back to the last visited page
Hi The xlsm file is not open in my computer will u send the code inside it. Regards Rajesh Kainikkara On 5/9/11, rajan verma wrote: > HI, > Please see if it help.. > > On Sun, May 8, 2011 at 4:01 PM, Rajesh K R > wrote: > >> Hi Experts >> Is it possible to create two buttons one for forward & other for >> backward and move to sheets in the order what we used after login just >> like we do in a browser.Pls check the attachment >> >> Regards >> Rajesh Kainikkara >> . >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Regards > Rajan verma > +91 9158998701 > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Access Problem
Yogesh, I think it is the problem with heading row (field Names). There are certian convensions which has to be followed while giving field names in access. In that case you can review (rename) the column names in such a way that they will not include any special characters and lengthy names. If you still face the problem, please attach the file to locate the problem. Regards, Kishan Reddy, K On May 8, 4:20 pm, Yogesh Gohil wrote: > Hi Guys, > > Some time when i want to import any data in Access then i get an error "* is > not a valid name. Make sure that it does not include invalid characters or > punctuation and that it is not too long.*" can Any one suggest me how to > remove this error. > > Thanks > Yogesh Gohil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Auto Refresh Data
try using Application.OnTime method http://www.ozgrid.com/Excel/run-macro-on-time.htm http://www.cpearson.com/excel/OnTime.aspx On Mon, May 9, 2011 at 1:17 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi All, > > > > I am having one database which is link to the external data (Internet)… I > need the VBA code where the data will automatically refresh after 30 seconds > / 15 Seconds, but it should not be a loop it just a macro automatically > running after 15 sec. > > > > *Example : My data is refreshed at 11:44:15 time and I wanted macro to be > automatically run at 11:45:30 and again after 11:45:45 then 11:50:00 and so > on…* > > > > Please suggest something. > > > > I am having one problem using loop here because while macro is running in > background I can’t able to work on other files and I wanted that macro to be > run at background and I should able to run on the files. > > > > Is there any way to do it.. > > > > Thanks & Regards, > > > > Anil Bhange > > IP - 512320 > > > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: delete workbook if password is not entered
Could you please attach the file or highlight which line you are
facing the error.
On May 6, 11:33 am, "Kabir:-)" wrote:
> Dear Mr. Golden Lance,
>
> When i m copying the code and executing in the new workbook, the following
> error is showing. Kindly help me.
>
> *Compile error : syntax error*
>
> Regards,
>
> Saroj.
>
>
>
> On Thu, May 5, 2011 at 10:17 PM, GoldenLance wrote:
> > Thanks for highlighting my mistake C.G.Kumar. My apologies.
>
> > Please find the entire code sought by reader.
>
> > Sub TPWD()
>
> > Static lngWrongPasswordCounter As Long
> > Const strPWD = "Password"
> > Dim strUserPassedPassword As String
>
> > strUserPassedPassword = InputBox("Please enter password")
>
> > If strUserPassedPassword = "" Then Exit Sub
> > lngWrongPasswordCounter = lngWrongPasswordCounter + Abs(strPWD <>
> > strUserPassedPassword)
> > If lngWrongPasswordCounter >= 3 Then
> > With ThisWorkbook
> > .ChangeFileAccess xlReadOnly
> > Kill .FullName
> > .Close 0
> > End With
> > End If
>
> > End Sub
>
> > On May 5, 12:03 pm, "C.G.Kumar" wrote:
> > > Hi Sam,
>
> > > The reader has sought for code to delete file if Password doesn't matches
> > in
> > > three attempts. You have provided code to delete file without prompting
> > for
> > > password match by oversight.
>
> > > Hope you will be amend the same.
>
> > > Regards,
>
> > > C.G.Kumar
>
> > > On Thu, May 5, 2011 at 1:58 AM, GoldenLance wrote:
> > > > With ThisWorkbook
> > > > .ChangeFileAccess xlReadOnly
> > > > Kill .FullName
> > > > .Close 0
> > > > End With
>
> > > > On May 4, 5:35 am, Bob wrote:
> > > > > Can someone help with the code to delete a workbook if password is
> > not
> > > > > entered within 3 tries. Thanks so much!
>
> > > > --
>
> > ------
> > > > Some important links for excel users:
> > > > 1. Follow us on TWITTER for tips tricks and links :
> > > >http://twitter.com/exceldailytip
> > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > > > To post to this group, send email to excel-macros@googlegroups.com
>
> > > > <><><><><><><><><><><><><><><><><><><><><><>
> > > > Like our page on facebook , Just follow below link
> > > >http://www.facebook.com/discussexcel-Hide quoted text -
>
> > > - Show quoted text -
>
> > --
>
> > ------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel- Hide quoted text -
>
> - Show quoted text -
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ go back to the last visited page
Please see attached file Chilexcel 2011/5/9 rajan verma > HI, > Please see if it help.. > > > On Sun, May 8, 2011 at 4:01 PM, Rajesh K R wrote: > >> Hi Experts >> Is it possible to create two buttons one for forward & other for >> backward and move to sheets in the order what we used after login just >> like we do in a browser.Pls check the attachment >> >> Regards >> Rajesh Kainikkara >> . >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Regards > Rajan verma > +91 9158998701 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Book1_solucion Chilexcel.xlsm Description: Binary data
Re: $$Excel-Macros$$ How to use Vlookup in macro
thanks sir,but can u tell me that how to use in many columns, i means how can i define column name because i have many columns in that i have to apply vlookup request,can u to plz send me the solution in excel file it will be very helpful for me.one more thing iwant to ask u that i want a macro for sumproduct also so it will be very helpful if u can send me both formula in macro will solve mu problem. thanks in advance On 5/8/11, rajan verma wrote: > Dim LookUp_value as variant > Dim LookupVector as range > Dim ColNum as Integer > Dim ans as Variant > 'Assign the Values to Variables > > Ans=WorksheetFunction.Vlookup(Lookup_Value,Lookup_Vector,Colnum,0) > > > > On Sun, May 8, 2011 at 4:45 AM, STDEV(i) wrote: > >> It would be easy for anyone in the group to respond, if you can send a set >> of sample data. >> >> >> On Sat, May 7, 2011 at 1:47 PM, maulik desai >> wrote: >> >>> Hi All, >>> >>> I have excel database sheet >>> I have created some excel output sheets (around 35 excel sheets) which >>> gives me output data with the help of Vlookup fuction. >>> But the problem is in every 3 months I have to change the database month >>> name & because of that I need to change the vlookup range also in output >>> sheets manually (need to open each sheet &change the new file name in >>> that) >>> >>> Is there any way that whenever I changed the file name of database ,the >>> same new range also updated in output sheets automatically. >>> >>> Thanks In advance. >>> >>> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Regards > Rajan verma > +91 9158998701 > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & Regards, Maulik Desai 9967363926 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to use Vlookup in macro
thanks sir,but can u tell me that how to use in many columns, i means how can i define column name because i have many columns in that i have to apply vlookup request,can u to plz send me the solution in excel file it will be very helpful for me.one more thing iwant to ask u that i want a macro for sumproduct also so it will be very helpful if u can send me both formula in macro will solve mu problem. thanks in advance On 5/8/11, rajan verma wrote: > Dim LookUp_value as variant > Dim LookupVector as range > Dim ColNum as Integer > Dim ans as Variant > 'Assign the Values to Variables > > Ans=WorksheetFunction.Vlookup(Lookup_Value,Lookup_Vector,Colnum,0) > > > > On Sun, May 8, 2011 at 4:45 AM, STDEV(i) wrote: > >> It would be easy for anyone in the group to respond, if you can send a set >> of sample data. >> >> >> On Sat, May 7, 2011 at 1:47 PM, maulik desai >> wrote: >> >>> Hi All, >>> >>> I have excel database sheet >>> I have created some excel output sheets (around 35 excel sheets) which >>> gives me output data with the help of Vlookup fuction. >>> But the problem is in every 3 months I have to change the database month >>> name & because of that I need to change the vlookup range also in output >>> sheets manually (need to open each sheet &change the new file name in >>> that) >>> >>> Is there any way that whenever I changed the file name of database ,the >>> same new range also updated in output sheets automatically. >>> >>> Thanks In advance. >>> >>> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Regards > Rajan verma > +91 9158998701 > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & Regards, Maulik Desai 9967363926 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
