• Spool File Report to Excel/Data File

    I need to take a report from my Spool File and get the data into Excel. I try it the iSeries way with the PrinterOutput but it's dirty. no headers. is there another way to dump it into a temp file whil in the AS400 and then export that out to Excel and have a cleaner report that is in cells?

    Jaymz69765 pointsBadges:
  • Date Range in Excel Macro

    Hi, I just want to know if its possible to do a macro wherein I can select the dates to be read in my report. For instance, I have a Table (below) where column A is the Date, column B is the name of Agents, Column C is the Section and the Column D is the Error Category. A window will pop-up where...

    Eron09135 pointsBadges:
  • Existing macros attached to custom toolbar buttons

    I have an Excel spreadsheet that contains several macros that are attached to custom buttons on a custom toolbar. When I open this spreadsheet in Excel 2007 none of the macros are attached to the buttons, how can I attach these macros to the correct buttons. Can I have this toolbar showing at the...

    Tad9575 pointsBadges:
  • Refresh Excel file on a different server with SSIS package

    I am trying to refresh an excel file that is on different server. is there any script that can be creatted with SSIS pacage that can do this. any help will be appriciated. Thank you in advance.

    Tocken10 pointsBadges:
  • VB for Excel

    I have an Excel Workbook (Template) inkl VB Modules and Forms. I want to export the Modules & Forms so that it can be stored at one place, but accessible from several Workbooks (different Periods etc) of the same type. How do I do this?

    OWE9995 pointsBadges:
  • Microsoft Excel report generation from Oracle Forms 10g

    what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.

    Somnath895 pointsBadges:
  • Why are my Word and Excel documents automatically zipping in Microsoft 2007?

    Why are my Word and Excel documents automatically zipping in Microsoft 2007? When I save a document, is there a specific way to name them that will prevent this?

    Celticgirl5 pointsBadges:
  • Sending Email in Excel using Macro

    Hi, I want to create a button in excel wherein once you click that button a message will pop-up and ask "Are you sure you want to send notification to your supervisor?" Yes/No. If yes is selected a New Outlook Message will appear where recipient's email address is already given and the subject is...

    Eron09135 pointsBadges:
  • SSRS Report Export to Excel

    When exported to Excel, some data is hidden from view by the row heigth. Rows must be expanded to view. Please suggest me a nice solution so that if the data is more than the single line, it has to expand the row height.

    Radhikavarshit5 pointsBadges:
  • How to call Microsoft Excel from Oracle Reports/Forms 6i

    how to call excel from oracle report/forms 6i plz tell me the step by step process how can we do it my e-mailid is lightmobeen@yahoo.com if any one know the process plz send me mail sonsist of code,me very thankful to u for this

    Exporacle20 pointsBadges:
  • Inserting Hex values into Excel

    Im new to Excel and am trying to Concatenate a number of cells together and sperate them by a single character represented by a Hex "4F". The combined cells will then be written to a file on my PCs C drive by way of a script. I will Transfer the file to a Mainframe PDS. Ive used HEX2DEC and its...

    Marsh218335 pointsBadges:
  • rows don’t line up or text does not appear with excel 2007

    I have instances where the rows (left freeze panel) do not line up ( and right panel)!!! sometimes the text does not appear on the screen, OR looks like it writes over itself. Happens when i do a control f to find text usually but not all the time. Anyone else having this problem?

    Peasandcarrots5285 pointsBadges:
  • Can ACCESS forms be used in EXCEL?

    Can forms created in ACCESS be used in EXCEL (via VBA)

    Jgenterprises10 pointsBadges:
  • Unable to Refresh Pivot Table if Datasheet in Excel 2007 is not open.

    I have several Pivot Tables linked to several like spreadsheets, respectively.  When I refresh a Pivot, I get an error that excel is unable to open the file (that the table is linked to). If the file is open, I can refresh.  My problem is each spread sheets contain huge amounts of data. Is there...

    Skb195510 pointsBadges:
  • Output to Excel using Regina Rexx

    How to read input from Notepad seperated by tab and put output to an Excel file each word in each coloumn using Regina rexx and not mainframe rexx

    Mydream5 pointsBadges:
  • Excel error message upon opening a document

    I receive a mesage that states "a document with the name - same name as the one opeming- is already open. You cannot open 2 documents with the same name, even if they are in different folders. To open 2nd document, either close the document that's currently open or rename one of the documents. This...

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

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