I keep getting this error when exporting Crystal Reports Ver. 10.0 to MS Excel 2003: Object Library invalid or contains references to object definitions that could not be found. Can this be fixed?
Can tables created in Access or Excel be imported into Oracle?
How to add a cell description to let the user know what information is asked.
Hello I am new here and this is my first post. I am wondering whether is possible to link Outlook 2003 Calendar to a spreadsheet in the same way as you would link 2 spreadsheets. For instance if a new entry is created in the Calendar the spreadsheet would be updated automatically. So far the way I...
I has been awhile since I have used this site. Most of my posted in the past have been with SQL. Now I am in a new industry. So Now I am working on a presentation in the financial world. I have compiled a graph of all the high or top income paying percentages starting for 1913 till 2013 (100 yrs) I...
I put the files of Excel in server that I have been spent a couple of days on it. I would like to keep it for other users to use it but I don't want other can delete it. So, what can we do to put the file in server and not allow other to delete? Please help me.
Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
Hi experts, I want to save a text file from PDF file through VBA (XLS) coding. I want to get the data as text mode from a specific PDF file in Excel Spreadsheet. Thanks, Ananda Debnath
I have 30 people in my group. I need a way that they can each document a problem with a particualr system we all use. I've been doing this with an excel file - everybody just opens the file and enters a new row of data when they find a new issue. Now, we need to do this so often several people may...
Within excel 2003 I have 1245 records in a sheet and I try to add an auto filter and not all items in that column are in the list, why. When I select just a few cells in the column and apply the auto filter the missing items are there but highlighting the whole sheet or just the entire column and...
I have put together a series of macros which autofilter information to create a report on different tabs within a workbook. Having 17 macros all similar it would be handy to have one macro which would systematically activate each Module in turn and therefore require just the one key combination...
I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In column H, I have the date each work order was completed and the dates are formated mm/dd/yyyy. I would like to have a code that will copy the work orders that...
This action only for products that are currently installed. The file is okay, I just need to get shortcut back on desktop.
How do I avoid the extra columns upon Crystal export to EXCEL?
Hello I have a slight problem when end users are trying to export reports into Excel. When they export the report, one or two columns in the report appear to merge together once exported into Excel, thereby making it difficult for my end users to perform spreadsheet data manipulations.
I have a report using SSRS,when export report to Excel file the first column of report gets exported into merged 2 columns.How to solve the problem?
I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance
I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I go about this?
Hi, I have a very small, but massively important Excel document that appears to be corrupt and I am unable to open. I get the following message: The document is corrupt and cannot be opened. Any suggestions? Thanks
Excel has SUMIF and COUNTIF functions, but I don't find a comparable MAXIF function. Can such a function be added into Excel? Any suggestions for sources?