• Macro to select a range in Microsoft Excel and paste in Lotus Notes

    HI ALL, I have created and Macro which sends a mail to many in that i need to upgrade as mentioned below Recipients Email Address STUDENT # GRADE COUNTRY 123@dd.com 000123 1ST GRADE United Kingdom 321@dd.com 000321 2D GRADE United Kingdom 213@dd.com 000213 3RD GRADE United Kingdom For each mail id...

    Balu07835 pointsBadges:
  • Predefine a named range for an exported SQL Server Reporting Services report

    How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Microsoft Excel – I need to find rows that match a user entered entries and sum results of column b

    I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem, but if the sum does not equal 24...

    Ksaep0420 pointsBadges:
  • Conditional Formatting – Excel 2003

    Hello, I would like to know how to setup a conditional format for the following example. Ex. Column 1: Company Column 2: Begin Date Column 3: End Date Column 4: Exceed Date if >3 (Calculates Column 2 & 3 in Days) Conditional Format for Column 4: if days exceeded 3 and "eguals the company in...

    Lhunter5 pointsBadges:
  • Using Excel 2003: Adding days to a cell that contains both a text and numeric entry.

    Can a formula be written that allows days to be added to a cell that contains both text and numeric information? For example, Cell A1 has NAME 1/3/09. I want to add 30 day increments to the 1/3/09 date in adjacent cells. Can it be done? If so. how? Thanks.

    Bpbp5 pointsBadges:
  • Excel 2003 – who has shared document open?

    If person #1 is editting a workbook and person #2 tries to open it, person #2 will be notified that the document is in use and asked if they want to open it 'read only'. Is there a way to identify 'who' has the document open?

    Moker15 pointsBadges:
  • What permissions are necessary to allow an SSIS script to read an excel file in a SharePoint Library?

    I am developing a datamart to feed Performance Point dashboards/scorecards. To deal with managers who do not have a database source, I will have them submit an excel 2003 file to a SharePoint document library (by email). the excel file will have a consistent format. I am developing an SSIS script...

    Dannl10 pointsBadges:
  • can’t open ifs doc

    I have an excell spread sheet on the IFS, I have a drive mapped. I can see the spreadsheet (it's small). When I click on it to open it will sit there saying it's downloading but then I get the error "Can't Open File". It has worked in the past this just started happening. Thanks

    Johnd0155 pointsBadges:
  • Shortening the generation time for a SQL Server 2000 report

    I have 516 different functions in SQL Server 2000 that are used for different calculations. These functions will operate on more than a thousand Microsoft Excel files. Each Excel file has 960 rows, and generating the report took over four hours. Is there a way to shorten this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to export data from AS/400 into Microsoft Excel

    Hi, Plse tell me ,what is the problem. I try to export data from As400 into Excle.I wrote a macro in the excle sheet.I run a progrme it gives error massege ['Excel is not recognized as an internal or external command operable programe or batch file. thanks & best regards, Nadeeshani.

    NADEE12320 pointsBadges:
  • Pivot table error when sourcing data from Access

    Pivot table error when sourcing data from Access reads: Invalid bracketing of name 'mdb.'.

    LittleKro5 pointsBadges:
  • How do I enter a defined variable into a FormulaR1C1 statement?

    I’ve defined the variable ‘Year’ as shown below, and I use it a number of times in my script. However, I’d like to use it in the “FormulaR1C1” command as well (shown below). How would I enter the syntax, so that it references my variable 'Year'? Currently I’ve manually entered the...

    Crawjo15 pointsBadges:
  • Problem in CCSID converting

    I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in these DB files...

    Proturborandza25 pointsBadges:
  • I need to up load an excel file to sql server db with vb

    I need to upload a excell file to sql server. I made a Stored procedure with the openrowset but if i run de stored procedure works, but embebed in visual basic or in crystal repor an error appears.Somethig about serverliked or server trusted i don't rememeber. does somebody an idea? thanks in...

    Xs4010 pointsBadges:
  • Problem MS Queries Refresh in excel file located on client network

    I am having a problem refreshing the Ms Queries in an excel file located on client network, when connected through vpn. It is showing an error window such as "ODBC Microsoft Access Driver Login Failed" Disk or network error.

    Pavin5 pointsBadges:
  • CPYTOIMPF and EXCEL defaults

    I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result. Example of data...

    Sbarnes5 pointsBadges:
  • Query/physical file headings

    Hi, I have a query that creates a file. I transfer the file to my C drive as a cvs file that I send out to a vendor. He would like headings on the file.....I can't seem to find out how to do this.....I know this is a silly question but how can I get the column headings on the file? If I import into...

    Rmason335 pointsBadges:
  • I want data from AS400 PF to my windows system in form of XL sheet.

    I want to create a pgm in any of the high level language supported by AS400. I want that when this program is run, an XL sheet is created and all the data in a specified PF should come in this XL sheet. If I am right, then every XL sheet has a limit on the number of rows it can accomodate. If...

    AbhishekRam5 pointsBadges:
  • Microsoft Access 2007 Data Input & Report

    I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 V V With the 3 pieces of information...

    PD15 pointsBadges:
  • How to export an AS/400 physical file to Microsoft Excel?

    how to export as400 physical file to excel

    Reskind5 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