Productivity Software Tag Directory

Browse Alphabetically:

Featured Productivity Software Questions

  • PDF save as TXT file (VBA)

    Hi experts, I want to save a text file from PDF file through VBA (XLS) coding. I want to get the data as text mode from a specific PDF file in Excel Spreadsheet. Thanks, Ananda Debnath

    AnandaDebnath280 pointsBadges:
  • Updating a shared list

    I have 30 people in my group. I need a way that they can each document a problem with a particualr system we all use. I've been doing this with an excel file - everybody just opens the file and enters a new row of data when they find a new issue. Now, we need to do this so often several people may...

    SomeDudeinTX20 pointsBadges:
  • Office 2003 excel filter

    Within excel 2003 I have 1245 records in a sheet and I try to add an auto filter and not all items in that column are in the list, why. When I select just a few cells in the column and apply the auto filter the missing items are there but highlighting the whole sheet or just the entire column and...

    Mhill10 pointsBadges:
  • One macro to systematically run F5 key on up to 20 other macros

    I have put together a series of macros which autofilter information to create a report on different tabs within a workbook. Having 17 macros all similar it would be handy to have one macro which would systematically activate each Module in turn and therefore require just the one key combination...

    AsHappyAs75 pointsBadges:
  • VBA Copy and Paste using dates

    I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In column H, I have the date each work order was completed and the dates are formated mm/dd/yyyy. I would like to have a code that will copy the work orders that...

    Bbourque965 pointsBadges:
  • Have Excel shortcut erroneously deleted now cannot transfer file back

    This action only for products that are currently installed. The file is okay, I just need to get shortcut back on desktop.

    donlewter5 pointsBadges:
  • Extra columns on export to EXCEL

    How do I avoid the extra columns upon Crystal export to EXCEL?

    Bozotheclown10 pointsBadges:
  • SSRS Excel export

    Hello I have a slight problem when end users are trying to export reports into Excel. When they export the report, one or two columns in the report appear to merge together once exported into Excel, thereby making it difficult for my end users to perform spreadsheet data manipulations.

    BBoy5 pointsBadges:
  • Export report to Excel

    I have a report using SSRS,when export report to Excel file the first column of report gets exported into merged 2 columns.How to solve the problem?

    Pionerka15 pointsBadges:
  • SQL Export to Excel file column?

    I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

    Shamilh10 pointsBadges:
  • Exporting data from SSIS to Excel

    I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I go about this?

    WindowsServerATE335 pointsBadges:
  • Corrupt Microsoft Excel 2003 file

    Hi, I have a very small, but massively important Excel document that appears to be corrupt and I am unable to open. I get the following message: The document is corrupt and cannot be opened. Any suggestions? Thanks

    NicolPar5 pointsBadges:
  • Microsoft Excel Graphing

    I has been awhile since I have used this site. Most of my posted in the past have been with SQL. Now I am in a new industry. So Now I am working on a presentation in the financial world. I have compiled a graph of all the high or top income paying percentages starting for 1913 till 2013 (100 yrs) I...

    CompEng1,230 pointsBadges:
  • MAXIF formula in Excel

    Excel has SUMIF and COUNTIF functions, but I don't find a comparable MAXIF function. Can such a function be added into Excel? Any suggestions for sources?

    TomGlass20 pointsBadges:
  • Microsoft Excel Graphing

    I need a line that is able to move. I want to grab it with my cursor and move it up and down on my bar graph. The bar graph is showing the zero to the max percentage of the percentage of income brackets for each year from 1913 to 2013. So there are 100 vertical columns (bars). The series of the...

    ITKE351,850 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • How to create an Excel spreadsheet from an Oracle database

    I currently have a table in a Oracle database and I need to create a complex Microsoft Excel spreadsheet structure from that specific table. Should I use SSIS to do this? Is there another way to create it? Appreciate the help.

    ITKE351,850 pointsBadges:
  • How to save the exported Excel files from Oracle Forms 6

    Hi, I am using oracle forms 6.0. I generate multiple excel files from oracle forms and am using ole2 to export the data into excel. But i dont know how to save those files into the local machine. please someone help me. Thanks in advance

    Rajanoracle10 pointsBadges:
  • How to export an AS/400 physical file to Microsoft Excel?

    how to export as400 physical file to excel

    Reskind5 pointsBadges:
  • Data Transfer from AS400 to excel

    i need to download data from As400 to Excel using TTO option. How to download the description of the fields instead of field names. I have tried with the COLHDG & TEXT keywords in the DDS of the PF. But, the records are getting downloaded with the filed names only. Please revert to me ASAP if...

    Saranyahere5 pointsBadges:

Browse Alphabetically:

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