• Retreiving data from within square brackets, there may be more than one in each cell (spreadsheet owner refuses to change it grrrr)

    I have a spreadsheet with a column containing data in the following format Column G Row 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D] Row 2 [1T400133] Row 3 [303640]*VF Row 4 [240700]*RN I would like to create a UDF that will retrieve the data within the brackets and create a column on...

    Harleq20 pointsBadges:
  • how can i limit the data size while entering to the database ?

    how can i limit the data size while entering to the database from Excel sheet using vb6?

    Shwetha20 pointsBadges:
  • Saving form calculations to tables

    I have a simple calculation on the input form a-b. It is calculated on the form but I cannot figure how to save it to the table

    Rv49495 pointsBadges:
  • Lotus Notes External Table Look Up

    My company uses LN 6.5 and I am trying to design a database with multiple tables. I have been told that there is a function that allows you to look to an external table, such as in Excel, to view data. The data modifications take place in Excel, but are viewed in the database. How would I...

    Kj71005 pointsBadges:
  • Installation and updates

    Howdy folks, Tryin to keep things going around here....need some advice. I have Win2003 servers and Active Directory.....single domain....approx. 100 client computers.....one location. Am upgrading all computers from Office XP to Office 2003. My project: Install Office 2003 and all updates remotely...

    TheVyrys0 pointsBadges:
  • How to save a document as current date ?

    I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please

    Data Mgt5 pointsBadges:
  • Is it possible to find out the name of an excel worksheet

    I need to import details from Excel but the worksheet names are not always what is expected. Is there a way to determine the worksheet name using sql? Query used to import where sheet name = data SELECT * INTO tmp_test2 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel...

    Smf170 pointsBadges:
  • import the data from iseries to excel sheet

    i read some instruction of Thierry Schmitz using timestamp. i am very much interested on this. please provide me any example of this. i am posting the process also. I prefer the following solution, working on request from the user : 1) the main excel sheet shows Timestamp of both Available DB from...

    Mup12345 pointsBadges:
  • MS Project 07 Automated Communication

    I am a project coordinator attempting to improve communications among resources assigned tasks in Project Server 2007. I would like to automate some of the issues and escalation of same - workflow type. What are the best tools for collaboration with this product? I'm semi new to MS Project and, of...

    Sissy10 pointsBadges:
  • Combo box and VBA

    The two possible selections in an Excel combobox: Debt & Common Stock. Let's say that the combobox resides in cell B3. If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use of...

    Nkd5 pointsBadges:
  • Excel 2003 – How to sum up a chart with percentage

    I have created a worksheet to track when letters are sent out. I have a column (1) for the name of the recipient and a column (2) for the date the letter was sent. How do I track what percentage of the letters have been sent? I would like a graph/chart, either bar or pie, that will tell me how many...

    Milelle5 pointsBadges:
  • VBA Auto Protect

    How can I make the worksheets in Excel automaticaly protected on date

    Georgesal00110 pointsBadges:
  • Excel-Macro Help

    I'm creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I've created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the...

    Forresterdanielle885 pointsBadges:
  • Pivot Tables – I need more than rudimentary calculations

    Does anyone know of a site that exchanges calculation information for Pivot Tables???

    Firewoman15 pointsBadges:
  • CSV data into Excel 2007

    Here's the issue. I have a .csv file that I want to import into Excel. This .csv came originally from Access. It has things like access database color values in it. I want to be able to do the following: 1. Change each "chr" value into it represented ascii equivalent. Example: chr(58) is a ":"....

    SHAPOW45 pointsBadges:
  • adding text to function results

    I am using a count function to create a total number (COUNTA(A1-A400) I want to add some test to display with the results so it reads 350 units. I have tried to nest the TEXT command but get an error

    Carourke15 pointsBadges:
  • Integrating Lotus Sametime with Microsoft Office

    Does anyone know how to integrate Microsoft Office with Lotus Sametime 7.x? What tools should we use and where can I find them on the Web?

    Domino Ask The Experts435 pointsBadges:
  • Deactivate Transfer Data To iSeries in EXCEL

    How do I deactivate the Transfer data To iseries link in EXCEL but still the Transfer Data From iSeries ACTIVE in Excel

    ESands5 pointsBadges:
  • How to search particular data in range of data and everytime save it in a cell

    How to search particular data in range of data and everytime save it in a cell in Excel using VB code

    VBA5 pointsBadges:
  • How to create dsktp shortcut to VB userform created in Word

    I created a userform through VB in Word. I need this form to be accessed via a desktop shortcut icon where only the form is visible when the shortcut is initialized. I created this form in Word. Please help. TY

    Jmitzner5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following