Hi Macros......................., I am preparing an excel sheet with validation it should not allow the special characters in a coloumn. Suppose we entered specail character in between the word, the cell should format like red color. pls help urgent.....
Thanks Sai..... On 28 October 2011 05:51, <excel-macros@googlegroups.com> wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > > - access query to run into > excel<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#13347e777f93f01e_group_thread_0>[1 > Update] > - Want to learn Match and Offset - > formulas<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#13347e777f93f01e_group_thread_1>[1 > Update] > - Sending data from Excel to > Access<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#13347e777f93f01e_group_thread_2>[1 > Update] > - Need your support > (Re-arrange_the_products)<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#13347e777f93f01e_group_thread_3>[3 > Updates] > > access query to run into > excel<http://groups.google.com/group/excel-macros/t/413e20999906f6f6> > > Sara Lee <lee.sar...@gmail.com> Oct 27 07:16PM -0400 > > hey > > is there a macro to run access query inside excel 2007. and excel data > should refresh with any change in access query data. > > > > Want to learn Match and Offset - > formulas<http://groups.google.com/group/excel-macros/t/16f9d08f50c36ae7> > > "STDEV(i)" <setiyowati.d...@gmail.com> Oct 28 04:15AM +0700 > > for all Excel functin please visit this site: > > http://www.excelfunctions.net/Excel-Index-Function.html > > http://www.excelfunctions.net/ExcelMatch.html > > http://www.excelfunctions.net/Offset-Function.html > > http://www.excelfunctions.net/Excel-Array-Formulas.html > > > [image: excelFunctions.net.GIF] > > > ~siti > --------- > forget some usefull Excel Keyboard ShortCut ?? > go and download here: http://www.box.net/shared/h0k1ds7gg3frypr67t1h > > > > > > > > Sending data from Excel to > Access<http://groups.google.com/group/excel-macros/t/2f9f8bc0ef61df07> > > Pascal Baro <bpascal...@googlemail.com> Oct 27 09:11PM > > Hi cyberspace, > > I'm still in the process of learning excel. I'd like to send data from > excel 2003 to access 2003. I have downloaded an access template on the > msdn site and i'm using this to learn. So far, I'm able to retrieve > data from Access and SQL Server Denali through sql queries. > > You can find an access and an excel file. The vba code is in the excel > file using Microsoft Active X data objects 6.0 library. > > Below is the code located in the excel file module "Sending2Access" : > > Option Explicit > > Sub Send2Access() > > Application.ScreenUpdating = False > Application.Calculation = xlCalculationManual > > Dim cn As ADODB.Connection > Dim rs As ADODB.Recordset > Dim r As Long > > Set cn = New ADODB.Connection > Set rs = New ADODB.Recordset > > cn.Open "Provider=Microsoft.jet.OLEDB.4.0;data source = > G:\code_access\access templates\PurchaseOrders.mdb;" > > rs.Open "Suppliers", cn, adOpenKeyset, adLockOptimistic, adCmdTable > r = 2 > > Do While Len(Range("A" & r).Formula) > 0 > With rs > .AddNew > .Fields("ContactTitle") = Range("A" & r).Value > .Fields("Address City") = Range("A" & r).Value > .Fields("PostalCode") = Range("A" & r).Value > .Fields("StateOrProvince") = Range("A" & r).Value > .Fields("Country") = Range("A" & r).Value > .Fields("PhoneNumber") = Range("A" & r).Value > .Fields("FaxNumber") = Range("A" & r).Value > .Fields("PaymentTerms") = Range("A" & r).Value > .Fields("EmailAddress") = Range("A" & r).Value > .Fields("Notes") = Range("A" & r).Value > .Update > End With > > r = r + 1 > > Loop > > rs.Close > Set rs = Nothing > cn.Close > Set cn = Nothing > > Application.ScreenUpdating = True > Application.Calculation = xlCalculationAutomatic > > End Sub > > The data in the table where I'm trying to send the excel data to is in > the access file with this message. > > Hope to get some help for this > > cyberuser Pascal > > > > Need your support > (Re-arrange_the_products)<http://groups.google.com/group/excel-macros/t/4aa85109087c50c7> > > Sam Mathai Chacko <samde...@gmail.com> Oct 26 07:47AM +0530 > > xlstime, that is the most hilarious statement I have ever seen. You > might > want to reiterate. > > Excel 2007 has the macro enabled file and the non-macro file apart from > a > few other formats. To use VBA, you'll have to save the file as a macro > enabled file, and the extension is .xlsm > > Any file saved in .xlsx format cannot contain VBA, except that it can > be a > place holder while it is yet not saved. > > Regards and Happy Diwali to all, > > Sam Mathai Chacko (GL) > > > -- > Sam Mathai Chacko > > > > > xlstime <xlst...@gmail.com> Oct 26 08:15AM +0530 > > Sorry Sam you are completely !!!!!!!!!!!!!!!!!!!!, > > > i mean excel 2007 (Excel workbook not support vba) so save ur file in > excel > 2003 or excel macro enable 2007 format > > > > -- > ......................... > > > > > MURALI NAGARAJAN <muralin...@gmail.com> Oct 27 07:30PM +0530 > > Thanks haseeb.. > > > > On Wed, Oct 26, 2011 at 12:35 AM, Haseeb Avarakkan < > > > > You received this message because you are subscribed to the Google Group > excel-macros. > You can post via email <excel-macros@googlegroups.com>. > To unsubscribe from this group, > send<excel-macros+unsubscr...@googlegroups.com>an empty message. > For more options, > visit<http://groups.google.com/group/excel-macros/topics>this group. > > -- > FORUM RULES (925+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- ThanX, Chudheer Kumar -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
