• Macro to Email an Excel file with an Outlook Template

    I have an Excel macro that creates a PDF file from Excel. I want to set up the macro to eMail the PDF using a template rather than a blank Outlook eMail so that I can use a standard message and format.

    Bam495 pointsBadges:
  • Editing excel file after converting it from pdf file?

    At first I convert the pdf file to text file using acrobat reader. after that i open the file through excel.  But i didnot get proper output of my file as the pdf format. the pdf format contains picture & tables also.

    Papuli5 pointsBadges:
  • Total Balance for Concatenated Unique ID in Access and Excel

    Hi, I have two spreadsheets that I import in to MS Access to compare. To get a comparable Unique Identified, I concatenate the data in three columns to one unique reference. I then want to find the total balance for each identifier, which normally have around 8 entries each and then compare it...

    Roballen885 pointsBadges:
  • Excel 2007 freeze pane problem

    Dear Sir, Is there any method in Excel 2007 to enabling freeze pane option in protected Sheet of Excel 2003. Regards Furqan Ahmed

    Mobilink115 pointsBadges:
  • Convert pivot table to normal excel sheet

    Hi, I have a pivot table and I want to convert this to a normal excel sheet. Theer are 3 records in the pivot table and now I want these 3 records as 3 column heads in the excel sheet. As a example there is project name, user name and description as records in the pivot table and now I want...

    EEEC20 pointsBadges:
  • Operating DOS through excel(VB or macro).

    Cheers. I m new to IT.I wish 2 operate DOS through excel. For example , in DOS we write some command and then press enter, then dos displays the information concerned with that command. Is this possible to do this, i.e writing command in DOS and pressing enter jst by writing a programme in...

    Begginer65 pointsBadges:
  • Using AS400 COBOL or CL Program to Call an Excel File and Pass Parameters Back and Forth from 400 to Excel Back to 400

    [html xmlns=""> I am beginning my investigation to figure out how to use either a 400/COBOL program or a CL program to call an excel spreadsheet that requires three parameters to a calculation and to return a value back to my 400/COBOL program of CL program so that I then can use that value in my...

    400Programmer185 pointsBadges:
  • Excel R1C1 referencing

    I have an excel spread sheet created via Crystal Reports export as a data only 2000-2003 excel (xls). Within this spread sheet are cells containing formulas with R1C1 referencing. When I open the spread sheet, the formulas are not calculated. I have changed cell referencing to R1C1 via the Office...

    BTod45 pointsBadges:
  • Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables?

    Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables? This would likely be done via a web browser interface such as Joomlah.

    Restart15 pointsBadges:
  • excel file from rpg as400 printer file

    I need to take an AS400 Printer file and create an Excel file.

    Junglemary5 pointsBadges:
  • Help me get a bat file to kill an exe with an if statement

    anybody help me get a bat file to kill a exe with a if statement . TASKKILL /F /IM "test.exe" solves but another supporting exe which monitors the test.exe kicks in and relaunches the exe again. I need to run this as a scheduled task daily once and kills until test.exe is killed.

    Shiv120 pointsBadges:
  • Exporting Contacts in Outlook 2007 in an Excel Spreadsheet

    I just tried to export my contacts into an excel spreadsheet. I followed the instructions but when it imported, all it imported was the title line, you know first last title company email website phone fax cell address city state zip. However NONE of that information imported over. None. What do I...

    Diva535 pointsBadges:
  • Advanced Macro’s in CA/400 – Using file as input

    I want to create macros for 2 reasons 1. Testing - use a file as input run menu options to test that nothing has been broken ie Customer Master Entry screen needs 5 pieces of information and populates this information into 3 or 4 back ground files. If I could input the 5 fields from a file in a...

    Seanzz5 pointsBadges:
  • Automated export/import between Microsoft Outlook 2003 and Microsoft Excel 2003

    I need to keep track of my activities in a excelfile and am looking for a way in wich my appointments (in my Microsoft Outlook 2003 calendar) automaticly get imported in specifed fields of the Microsoft Excel file. This is part of a monthly report to account for my time, and how much time I spent...

    Nizw120 pointsBadges:
  • Proper Excel 2007 macros to identify table

    dear sir/madam i have a table such as the left table and want to extract a table like the right one please give me the proper macro. best regards. hamid [table style="border-collapse: collapse; width: 300pt;" border="0" cellpadding="0" cellspacing="0" width="400"> [col style="width: 63pt;"...

    Hamidirani575 pointsBadges:
  • AS/400 to excel

    How to download an AS/400 file in an excel format. I want to create a tool for this in my system. Please give your guidance.

    GanRek5 pointsBadges:
  • Export Crystal Reports to Microsoft Excel format

    how can I export crystal report to an excel file

    Yyt5 pointsBadges:
  • How do I sort an entire state customer list by only the zips I work with?

    how do I sort an entire state customer list by only the zips I work with

    Mayabel025 pointsBadges:
  • uploading an excel spreadsheet to the as/400

    I've seen a developer with an Excel spreadsheet on the iseries server, how do I upload an Excel spreadsheet to the iseries and populate it with data so I can then download the finished product to my PC?

    Chuck3105 pointsBadges:
  • Visual FoxPro 6.0 troubles exporting large files to excel

    I have large databases that need to be sent to customers in a manifest.  So i export it from FoxPro six to excel 5.0 and save it in my documents then attach it to an e-mail. The trouble i am having is exporting a large database.  FoxPro does not export the whole thing when i export it. It stops...

    0 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