Search results

Hi, preethi3290! For the Access tables, primary key, foreign keys or any other constrain or relation? Regards!

Hi, preethi3290! Please tell me: a) path of the Access file b) paths of the Excel files c) exact range start (row, col) thru end (row, col / first blank) of Excel files d) Access table structure where ranges will be imported. Preferrabily, upload Access file too. Regards!

Hi, Marc L! Really? I was wondering how to get into @r2c2's bank accounts... Regards!

Hi, Hazra Hadee! Yes, a bit of tags are left but nothing that could not be removed manually. Maybe there are a other online converters that work better, I didn't dig deeply, just tested the topmost. Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted. Regar

Hi, Katybug1964! Thanks for answering. However if you can upload a sample of the three involved files it'd be easier for people to help you. Regards!

Hi, preethi3290! Sorry if arriving late to this conversation makes me post yet answered questions, but I have a few doubts. You have the Excel workbook that you uploaded at post 4. In that workbook you have a little hole in range J32:L36. Despite of this which is the exact range that you want to...

Hi, Nagin! Firstly a clarification. What you have in worksheet Input is just a worksheet with a design that looks like a form but it's still a worksheet (basically cells, rows & columns) with a few controls that simulate a recordset edition (used by userform's DataControl controls). Precisely...

Hi, Mahantesh! Code provided by shrivallabha does the job or folder creation. Please note that MdDir function is in the part of the If...Then...Else construction that is executed when it (the temp folder) doesn't exist. You should adapt that code, surely removing both message boxes and embed it...

Hi, Amit Punia! If you right click on any ActiveX control, and select View Code, you'll always get a code like this: Private Sub <control_name>_<event>(<parameters list>) End Sub That's what's called code for the main event (usually Click) or that control. From VBA editor you can add new...

Hi, Baconbo! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, glad you could solve it by yourself and thank you for sharing with the community. Regards!

Hi, jb! When I advised you of this it was because I've yet detected some a-bit-weird things about the way borders have been set for "all" boxes. There wasn't an uniform way, some of them have all borders set, others have all but bottom, and I assumed (didn't and won't check) that it was because...

Hi, ThrottleWorks! And if I use Y2B for watching old series/movies, short tutorials on how-to-something, lots of photography stuff, besides pranks, the slo mo guys, older fps-russia, a science guy that I don't actually remember...? Would I be of any help? Regards!

Hi, Eloise T! You now say... but in the 1st post you said... <bold red is mine> We can... but what are we supposed to do? Follow 1st or last requirement? Assuming David Copperfield is whispering at my ears, try this: Option Explicit Sub AnyIssueWithDates() ' constants Const ksFormat...

Hi, Eloise T! I tested it on a dozen of rows with different date formats and it worked. Please upload a sample file with dates in col G from row 3 in advance where it doesn't work. Thanks. Regards!

Hi, Mandy Lott! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, have you searched in this site for similar problems? I think that this topic has been treated many times. When posting code please do it between...

Hi, Eloise T! Give it a try: Option Explicit Sub AnyIssueWithDates() ' constants Const ksFormat = "mm/dd/yyyy" ' declarations Dim lRow As Long, iColumn As Integer ' start lRow = 3 iColumn = 7 ' process With ActiveSheet Do While Len(.Cells(lRow...

Hi, iRasim! C8: =SUMAPRODUCTO(($A$2:$A$5=$B8)*($C$2:$F$5=1)) -----> in English: =SUMPRODUCT(($A$2:$A$5=$B8)*($C$2:$F$5=1)) D8: =SUMAPRODUCTO(($A$2:$A$5=$B8)*($C$2:$F$5<>1))-----> in English: =SUMPRODUCT(($A$2:$A$5=$B8)*($C$2:$F$5<>1)) Copy down. Regards!

Hi, Hazra Hadee! Tried with online converters like this? http://www.webtoolhub.com/tn561393-html-to-text-converter.aspx Google it as "html to plain text". Regards!

Hi, Andrew Quirl! The code is placed in "Competitor Data" worksheet object, so in this instruction: With Me you're telling to refer to that sheet. Create a new module, move the code to it, and change that previous sentence to: With Activesheet Then the macro will act on the actually...

Hi, Isaac Garcia! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, please define "highest values". For Joe you only take 100 but for Jane you take 84.3373 and 79.0698 but not 66.3366. Which is the criteria? Regards!

Hi, jb! Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted. Regards!

Hi, bkanne! Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted. Regards!

Hi, Katybug1964! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, have you searched in this site for similar problems? I think that this topic has been treated many times. Regards!

Hi, bkanne! Give a look at the uploaded file. This is the code behind the button: Option Explicit Sub CaranDAche() ' ' constants Const ksWS = "Sheet1" Const ksStates = "StatesTable" ' ' declarations Dim rng As Range Dim I As Integer, J As Integer, K As Integer...

Hi, sandysharma! Try with function WORKDAY. Regards!