• Image storage in Microsoft Excel

    I'd like to know the code or procedure to use in Ms Excel that will help me to lookup a photo into a cell. I've observed some customised banking software which is able to display the picture and signature of a client whenever his unique account number is entered. Could I use excel to perform the...

    Snowolf5 pointsBadges:
  • Menu Driven Macros

    I have a database within Excel 2007. There are quite a few macros in it. I want others to be able to use the database and certain macros, but I want the options to be in a menu type layout not on the bar. I know this has to be possible, but I don't even know what it would be called to look it up....

    Cindyhale5 pointsBadges:
  • Deleting Excel Worksheets with macro

    I am using excel 2000 and have workbook that uses macro to delete several worksheets and then save the workbook under a name in one of the cells. All works fine but for each worksheet a quiery pops up to ask if you want to delet this sheet. How do I delete sheets in the macro without having this...

    Rbloxsom5 pointsBadges:
  • file format or extension invalid

    after using Excel 2007 for several months with no problem, I had to reformat and reload windows xp professional. then I installed Excel 2007 and now I can't open the xlsx files created by Excel 2007. I get the error in the above title box. Any help will be welcomed. Gervis.

    Cornfused15 pointsBadges:
  • Is there any way to update Actual results in Quality Center from an Excel?

    Is there any way to update Actual results in Quality Center from an Excel?

    Ilm5 pointsBadges:
  • Excel 03 won’t release cell

    We've had a couple of users run into issues with Excel 03 not releasing a cell as if were in EXT mode. Problem is that when we press F8 it won't release it. ESC hasn't helped and it locks up the workbook so the only way to close it is through Task Manager. Running Windows XP Pro SP2 with MS Office...

    Littlejuanito7420 pointsBadges:
  • Critical Path

    I created a project plan and everything looks normal but when I want to view for a critical path (using Gant Wizard Chart), I don't see any critical paths. I am wondering what went wrong

    MSProject5 pointsBadges:
  • Excel to Lotus Notes Form

    I have a Excel workbook with alpha numeric text in a group of cells. I try and copy the text from those cells directly from Excel into a Lotus Notes 7 form and find that I cannot because Notes is treating the paste as being an object and not text. The cells in Excel are text formatted.... How do I...

    Sjh7475 pointsBadges:
  • Executing DTSX from VB.NET 2003

    We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

    BClawson10 pointsBadges:
  • STRPCCMD with blank in path

    I am trying to start an Excel spreadsheet with a blank in the path. ex: STRPCCMD 'START K:\My Documents\GL\Monthend.XLS' I've tried all sorts of QUOTE scenarios but have not hit on the right set. Thank you MIS

    MurrayInfoSys940 pointsBadges:
  • How to run a query in PS Query using Microsoft Excel macro

    Hi, I am working on a macro in Excel that can automate the running of a query in people soft PS Query application.Result should also be save in Excel format at given path. Here is what i exactly want to do 1. Put all query name under column A.(not entire query only its name) 2. Run macro 3. query...

    Sh3210 pointsBadges:
  • Excel to Access conversion

    When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?

    QAMAN15 pointsBadges:
  • Microsoft Excel hyperlinks to Lotus Notes

    I created a hyperlink in MS Excel to an E-mail address (I use Lotus Notes). When I follow, the email is created with the correct subjsct line however the text line is blank i.e., simply not there, even though it appears in the "text to appear" diologus box. Does anyone know why this is?

    LostinDenver5 pointsBadges:
  • Upgrading from excel 2003 to 2007

    After upgrading our laptops from Office 2003 to Office 2007 somehow the permissions in the IFS have changed and certain groups can no longer save Excel documents with system i data. They get a "cannot save" message. Any idea where to look? Netserver etc.?

    Kbordner5 pointsBadges:
  • Can Windows Explorer ‘File Types’ settings be amended by Group Policy?

    To enable our reporting software to correctly export to Excel 2007 (WXP SP2 operating system) we need to change the following Windows Explorer 'File Types' setting: Open windows explorer and navigate to the XLS file type and enable the "browse in same window" option, see path: \Tools\Folder...

    Redtyke130 pointsBadges:
  • Excel 2003 ranking with VLOOKUP

    I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy Heart 46% 24%...

    Jha9005 pointsBadges:
  • Excel 2007 Crashes

    I am using Excel 2007 working in a workbook that has forms for each census year. In the form I put the data for the family name that I am researching, these forms might be several hundred lines to several thousand lines each. Size of each census year may vary. There is quite a bit of formatting,...

    Mwellis15 pointsBadges:
  • Excel cell referencing

    What is absolute cell referencing and how is it beneficial in excel

    Xxrerexx10 pointsBadges:
  • ExcelSource file – metadata validation

    I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output columns...

    Mayre5 pointsBadges:
  • Does Apache POI-XSSF support Excel 2007 runs under Java 1.4?

    Hi Guys, Is Apache XSSF POI supports java 1.4 to upload the Excel 2007. Thankx.

    Ansipar288315 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