• 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.

    Pupun5 pointsBadges:
  • Excel compute time

    We have an Excel spreadsheet that volunteers use to document their time working. The time in an out is based on 12-hour time (am/pm). I would like a formula that would use the in and out time to compute number of hours worked. Anyone know how to do this?

    XMac110 pointsBadges:
  • Reports to be pulled from iSeries

    Hi. I have a query regarding pulling the report from i series, am working on I series when i pull the report into txt format in notepad,when  i copy and paste it into excel it displays unwanted rows with blanks and some special characters and word like particulars would be splitted like parti cula...

    Ausboi095 pointsBadges:
  • Excel: Hyperlink to Lotus notes with message field populated

    Hello I have a spreadsheet which just has email addresses on it.  When I click on them they open a new email in Lotus Notes.  I want to know if there is a way to make it so that when I click on the hyperlink the message field is populated with a template letter which can be edited by the user...

    Hosteen5 pointsBadges:
  • Performance files to Excel

    I know how to run performace tools on Iseries but how can I download the Iseries performance files into Excel and create a graph on the data? Thanks

    DudleyShaw15 pointsBadges:
  • Lotus Notes 8.5 documents to Excel worksheet

    Exporting documents to Excel worksheet.  Going well, but need to have the Excel sheet open in landscape.  What would be the commands for that?  This works fine so far: currentprocess = "formatting the spreadsheet" wsheet.Name = viewname wsheet.Cells.Font.Size = 10 wsheet.Rows("1:1").RowHeight =...

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

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