Export from SAP to Spreadheet
How would one going about exporting a report (ZREP_EXPEDITE)in SAP to a certain spreadsheet that you built.

Answer Question   |  February 28, 2012  6:44 PM
SAP MM, Spreadsheets

Read/Write Excel spreadsheet in Forms6i but no excel
Hi!  I’d like to know if I there’s a way to read/write a spreadsheet without to install Excel. I’m working en Forms 6i and I’m performing a programmed task, so a file csv doesnt’ work for me, the application must access and generate the Excel file automatically.  Please, help me. Regards, thanks in advance Paola

Answer Question   |  May 13, 2010  11:35 PM
Microsoft Excel, Oracle Forms 6i, Spreadsheets

How to make excel rows/columns writable by only specific people
I have two users working on the same spreadsheet, both should be able to write to only their specific part of spreadsheet, i.e. user2 should not be able to overwrite what user1 has previously entered. I know NTFS permissions, will operate on the file level, but I guess I’m looking to restrict it to a [...]

Answer Question   |  March 11, 2010  9:49 PM
Excel 2003, NTFS permissions, Spreadsheets

Is there an attribute assigned to a spreadsheet that identifies that a Macro was created and can this be reset?
With the Macro security set at medium, if a Macro was ever created for a spreadsheet, you are prompted whether or not to Enable or Disable MACROS. If a MACRO was never created in the spreadsheet, you are not prompted at Medium security. If you delete all the MACROS from the spreadsheet and save the [...]

Answer Question   |  June 11, 2009  8:00 PM
Spreadsheet macros, Spreadsheets

Export adding .00
When I export a table into a spreadsheet my id fields now add a .00 to the end of the number. They don’t appear this way in the actual table though. How can I prevent them from exporting this way?

Answer Question   |  December 31, 2008  4:39 PM
Spreadsheets

Match a date to a number
I have a list of dates (A) on the left inside next to each date i have numbers (B). I have another list of dates (C) which is shorter with the same dates. I’m trying to match the numbers to dates (C) based on the first dates (A). 1 0.6 10/20/08 10/20/08 2 1 10/21/08 [...]

Answer Question   |  December 16, 2008  4:32 AM
Spreadsheet functions, Spreadsheets, VLOOKUP function

SpinButton linking to an occupied cell
Can a spin button be linked to the cell that it is located in? I have about 100 spin buttons that I need in this sheet and don’t want to individually link each one! Thanks!

Answer Question   |  January 11, 2009  12:00 AM
SpinButton, Spreadsheets, VBA, Visual Basic for Applications

Formatting a spreadsheet row with color
hello, I would like to know if there is a way to color (shade in) a row when one specific cell has a value in it. For instance if I am entering in data and column I is for refunds, when that i blank i dont want the row to be shaded, but if there [...]

Answer Question   |  November 10, 2008  11:55 PM
Conditional formatting, Spreadsheet formulas, Spreadsheets

Copying a portion
how can a copy just the last character from one cell to another?

Answer Question   |  November 3, 2008  7:51 PM
Microsoft Excel, Spreadsheets

How would you calculate, using the spreadsheets statistical functions, the cheapest option at the fastest speed with the least downtime?
i have 5 tables each including speed, price, download limit, average downtime and the average uptime. i was asked by my teacher to calculate all these so i get one number, to find out which is the best value for money for someone to go for. i just need to know what do i calcute [...]

Answer Question   |  October 29, 2008  10:11 PM
Excel functions, Excel macros, Excel statistical functions, Microsoft Excel, Spreadsheets

adding text to function results
I am using a count function to create a total number (COUNTA(A1-A400) I want to add some test to display with the results so it reads 350 units. I have tried to nest the TEXT command but get an error

Answer Question   |  April 2, 2008  3:34 PM
COUNTA, Microsoft Excel, Spreadsheets, TEXT