• Issues with 2007 MS Office Server SP1

    Are there any known or has anyone had issues with 2007 Office Server SP1?

    Daizy35 pointsBadges:
  • Excel 2007 Freeze pane problem

    AOA SIR, I am using Office 2007. I have protected sheet which were created in office 2003. When ever we have open this proted Workbook In Excel 2007 the freeze pane option is disbaled. Please help me out to Solve the Above mention Issue. I Will thankfull to You.

    Mobilink115 pointsBadges:
  • Overwrite previous record with VBA code

    I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked. Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code

    Battler5 pointsBadges:
  • Working with Excel in ActiveX DLL

    I have a OCX file that is registered on client's PC and called from ASP to perform the Excel manipulation (copy charts and paste into PPT). I tried to register the OCX on server and called using <Object> tag, did not work, still looking for the OCX on the client. Created a new DLL file...

    Dfree5 pointsBadges:
  • Create and FTP a PDF

    create and ftp a pdf file from spooled file that has more than 132 columns

    Jwwillis5 pointsBadges:
  • Return zero when there’s no data

    I am trying to write a query that I can use to generate an Excel chart to show activity in our database. I have it returning rows for each minute over the previous two hours (no problem). The problem comes when I plot a line chart. If there's no activity in a given minute, there's no row returned,...

    DanM5 pointsBadges:
  • Validation in Excel

    Can a cell have a validation rule from a list and also have the ability to free type in that cell? This is in Excel 2003.

    Mart8025 pointsBadges:
  • After exporting charts from SQL Server Reporting Services to MS Excel, images appear poor

    I have a problem with my charts. After exporting from SQL Server Reporting Services to Excel, my charts look "ugly.” Quality is low, images are blurry, etc. Is it possible to change settings somewhere?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to export Lotus Notes document to OpenOffice Writer document?

    Hi! Idea is very simple, click on Action Button (code must be in LotusScript) when opened LN document, and then by clicking this Action Button all LN document data exports/converts/migrates on OpenOffice Writer document. Can anyone know how to do that? Tnx ;)

    LotusScript245 pointsBadges:
  • 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:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following