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
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
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
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
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
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
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
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
how can a copy just the last character from one cell to another?
Answer Question | November 3, 2008 7:51 PM
Microsoft Excel, Spreadsheets
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
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