Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search
Tech Support Guy Forums > >
(!)

Keebellah Keebellah is offline  is a Trusted Advisor with special permissions.

Trusted Advisor

Visitor Messages

IMPORTANT! READ THIS FIRST!
This form is to write a personal message to another user. DO NOT ASK FOR TECH SUPPORT HERE. To ask your tech support question, please go to the forums or read our welcome guide for new members. Thanks for your cooperation!
Showing Visitor Messages 1 to 10 of 17
  1. raceform
    19-Dec-2012 07:32 AM
    raceform
    Hi Keebellah
    Thanks for reply I have posted a file with what I attempt to achieve
    Regards Steve
  2. Teacherless
    02-Jul-2012 11:21 AM
    Teacherless
    Hi Hans, sorry for delay, just been out to get a new internet modem, my connection is much better now. I think what I will do is send you my complete 2003 wb so that you can see exactly what is what. If you sell it, we go halves on the profit. It is a diamond pricing calculator, really useful to jewelers. As you will see,it has 30 sheets, 24 of which contain data bases and conversion formulas. Before I send it you must tell me if you have the means to open the password protected vba editor. If you haven't then let me know.
    Regards, John
  3. tennisfrk159
    22-Jun-2012 09:05 AM
    tennisfrk159
    Hi Keebellah,

    Again...thanks for your help!

    -tennisfrk159
  4. slurpee55
    10-Apr-2012 11:40 PM
    slurpee55
    Hi! It has been a long time - I have been unemployed since Jan. of 2011 and don't have a new version of Office (I have been using LibreOffice instead, but I don't really like it much.) The lack of a newer version has meant that I haven't been able to assist people on here much. I miss it, but oh well....
  5. satibab
    22-Mar-2012 01:19 AM
    satibab
    Hi mate need a formula for a an excel sheet...
    If I type firstname lastname in cell A, cell B should auto populate with firstname.lastname@abm.com (ex: satish babu in cell A = satish.babu@abm.com in cell B).... This formula did not work anyother suggestion (=LEFT(A1,FIND(" ",A1)-1)&"."&SUBSTITUTE(A1,LEFT(A1,FIND(" ",A1)),"")&"@XYZ.COM")
  6. Zack Barresse
    12-Mar-2012 02:24 PM
    Zack Barresse
    Hello Hans, I just saw your note from January! Sorry I missed it. I like your function. As little overhead as the constants carry, since they are loaded at time of compile, I don't mind just concatenating what I need together, and would use less resources during run time. Why did you not just use the String() function, why the loop?
  7. rweb
    01-Mar-2012 08:43 AM
    rweb
    Hi Kebelah,

    You helped me on a macro find and replace back in december. Now i want to reverse column c to show the sku and not the number id. i have attached a link to the original post below
    http://forums.techguy.org/business-a...ml#post8195167

    please advise
  8. vinotech
    23-Oct-2011 09:23 AM
    vinotech
    Hi Hans...
    I hope yo are well... would yo need me to post the attachment here,
    http://forums.techguy.org/business-a...cel-macro.html
  9. Ziggy1
    25-Mar-2011 10:44 AM
    Ziggy1
    hi Keeellah,

    Can you look at this post, I don't have time right now....

    http://forums.techguy.org/showthread...2&goto=newpost
  10. vinwin06
    05-Jan-2011 02:49 AM
    vinwin06
    Hi Hans,

    Hope you have a great new year.

    I need your help in one of my older post called Combining 30 text files into single text file. In this thread you have given one VB script file for removing header in the output file. I have clarification that whether i need change any coding that because for running that Vb script file for the month of December i am getting error that "Kmart_1211.txt" does not contain any data. Actually i check file also it having only December month data.

    I think the problem is because of the year. The output file have the data of December 2010 (1210), But if run the VB script now it will consider as 2011, i think this is the confusion.

    http://forums.techguy.org/business-a...ext-files.html

    Please help me on this.

    Regards,

    Vinoth S

About Me

  • About Keebellah
    First Name
    Hans
    Location
    Oegstgeest, The Netherlands
    About Me
    Real name: Hans
    Grew up in Central America (Costa Rica) age 1-17
    Studied math in Barcelona and Geology in both Spain and the Netherlands
    Worked for almost 13 years in several African countries for the United Nations Development Programme (UNDP) as a Geologist
    Started using a computer in 1983
    Play a little tennis and volley-ball, ride bicycle

    In IT since 87.
    Interests
    Programming, Tennis
    Occupation
    Application Engineer, Reports Manager
    Experience
    Advanced
    Computer Specs
    Quad core, 6 MB Ram Windows 7 Ultimate 64-bit x64 1TB + 500GB HDD + 1.5TB Ext HDD
  • Signature
    Cheers,
    Hans
    It's all in the code... and may the code be with you! If it isn't . . . start debugging! (Time zone: Western Europe)

Statistics

Total Posts
Visitor Messages
General Information
  • Last Activity: 23-May-2013 12:30 AM
  • Join Date: 27-Mar-2008
  • Referrals: 1

Friends

Showing Friends 11 to 15 of 15

Contact Info

Instant Messaging
Send an Instant Message to Keebellah Using...
This Page
http://forums.techguy.org/members/390077-keebellah.html
WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑