• MS Access Tools References

    Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library...

    Rjwilcox45 pointsBadges:
  • Parameterized Query Syntax

    Thank you Mr Hatmaker for sharing the "Parameterized Query with excel." I have watched the videos on youtube (beyond excel) describing the function and I have a few questions.1-I am looking for the syntax for "contains". I am searching for the syntax to place in the criteria field that would return...

    YulData5 pointsBadges:
  • Have an Excel macro download data to the iSeries

    Is it possible to code an Excel macro to download a spread sheet to the IFS (on the iSeries) and then to start an iSeries job to process the downloaded data?

    aderene180 pointsBadges:
  • Wildcard Characters in Microsoft Excel

    I have a formula to search for a code and return results. The problem is that within the code there are wildcard characters. How do I make wildcard characters searchable text?

    Shultzie5 pointsBadges:
  • SSRS Excel Reports

    Hi, I have exported my SSRS report to Excel. Everything seems to be fine regarding the alignment of columns etc. However, additional row or two appears colored below the complete table of the report. Can you please help me on removing this?

    Souras5 pointsBadges:
  • MS Office Excel 2007 cannot be open by MS Office Excel 2003 (even after installing compatibility pack)

    Cannot open the EXCEL file using MS Office EXCEL 2003 (after installing the Compatibility pack) that was saved by MS Office EXCEL 2007. The error message: This file is not in a recognizable format. If you know the file is from another program which is incompatible with Microsoft Office EXCEL, click...

    Phlim35 pointsBadges:
  • PDF format file change to Excel

    My friend got one PDF file and contain some table based data. How can we convert that file to Excel format?

    Tonycheng5 pointsBadges:
  • What formula is needed for this below in Excel?

    What Excel Formula's could I use? First # is starts with 1  back slash 2400. 2400 stays the same only first # changes. Example below: [table style="border-collapse: collapse; width: 65pt;" border="0" cellpadding="0" cellspacing="0" width="86"> [col style="width: 65pt;" width="86">[/cOLIST]...

    Jreifenstein001185 pointsBadges:
  • Specify the read only attribute in my Perl code so I don’t have to click on read only

    I have created a perl script that read from an excel file that is located on our windows server, the goal is to automate the perl script to run once a week and read the first 5 columns of the row that matches the current date and then write the data to a .txt file. A bash script will then open that...

    Guylevy5 pointsBadges:
  • How to repair and recover corrupt MS excel file?

    How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please help me.

    DredSelpy5 pointsBadges:
  • Damaged Excel file

    Today I cannot open several Excel files they all say cannot open the file because the file format or file extension is not valid. The files which do open all the tabs have disappeared except one which is full of garbage characters. The files that do open also say the data is delimited.

    jon77775 pointsBadges:
  • Input to Rumba macro

    How can I vary data in a Rumba macro (Excel)?

    BSAfromMA5 pointsBadges:
  • Excel 03 opens as Read Only always

    We have a user that is only able to open Excel 03 files in Read Only. No other MS Office does this to her. It even happens to Excel files she has created and files that she receives in emails. Any ideas would be helpful since we are at a loss. Windows XP Pro SP2, MS Office w/Outlook 03. Thanks

    Littlejuanito7420 pointsBadges:
  • Is it possible to take data from Excel to IE?

    I have a list of numbers, that need inputting into IE, that then follows a process such as…Number from Excel > Copied into a box in IE and enter press > loads up a page, you then select and open the correct tab that opens in another IE window > drop downs selected > notes entered >...

    loobiedoo15 pointsBadges:
  • Problems oprning Excel File

    I have been working with an Excel 2003 workbook since January 2008 and from last week began having difficulty opening the file. Whenever I attempt to open it, I get an error window with the following messages shown in bold below: [Excel found unreadable content in 'filename.xls'. Do you want to...

    EB35 pointsBadges:
  • Error message when exporting Crystal Reports to MS Excel 2003

    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?

    Mzdoreen5 pointsBadges:
  • Import Microsoft Access tables into Oracle

    Can tables created in Access or Excel be imported into Oracle?

    Micheline foxxe10 pointsBadges:
  • Cell description in Microsoft Excel

    How to add a cell description to let the user know what information is asked.

    joseangel2795 pointsBadges:
  • Microsoft Excel Graphing

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

    CompEng1,240 pointsBadges:
  • Don’t delete Excel files in server

    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.

    Rathana15 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