• 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:
  • Switching custom views in Excel when filtering

    I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it to...

    Tsbarr15 pointsBadges:
  • Switching views in Excel when filtered

    I have several macros that switch views for a very large spreadsheet. I also have filtering available for the various columns. However, whenever the view is switched, the filtering is turned off. If filtering is on, I would like the filtered view to not change. Is there a way to keep the filtering...

    Tsbarr15 pointsBadges:
  • How to change config to download all fields to Excel than Inbox

    Using menu path Plant AnalysisExportTransfer to XXL in MCBA to download all switch drill down fields but currently am brought to SBWP. How do I change it to allow down load to Excel?

    Janwong5 pointsBadges:
  • Excel Date format () dd-mmm-yyyy error from exported crystal report

    I am exporting a crystal report file to excel and date field TRADE_DATE is coming out strange. i.e PARTY_ID TRADE_DATE CX () 16-Jul-2003 CX 29-Jul-2003 CX 09-Dec-2003 Some trade_date fields are in Custom Type "dd-mmm-yyyy" format ( which is the correct format) but some are in Custom Type "()...

    Shakeel4540 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