• Lotus Notes External Table Look Up

    My company uses LN 6.5 and I am trying to design a database with multiple tables. I have been told that there is a function that allows you to look to an external table, such as in Excel, to view data. The data modifications take place in Excel, but are viewed in the database. How would I...

    Kj71005 pointsBadges:
  • How to save a document as current date ?

    I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please

    Data Mgt5 pointsBadges:
  • Is it possible to find out the name of an excel worksheet

    I need to import details from Excel but the worksheet names are not always what is expected. Is there a way to determine the worksheet name using sql? Query used to import where sheet name = data SELECT * INTO tmp_test2 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel...

    Smf170 pointsBadges:
  • import the data from iseries to excel sheet

    i read some instruction of Thierry Schmitz using timestamp. i am very much interested on this. please provide me any example of this. i am posting the process also. I prefer the following solution, working on request from the user : 1) the main excel sheet shows Timestamp of both Available DB from...

    Mup12345 pointsBadges:
  • Combo box and VBA

    The two possible selections in an Excel combobox: Debt & Common Stock. Let's say that the combobox resides in cell B3. If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use of...

    Nkd5 pointsBadges:
  • Add to Excel spreadsheet from System i

    I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.

    ljjk1225 pointsBadges:
  • Excel-Macro Help

    I'm creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I've created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the...

    Forresterdanielle885 pointsBadges:
  • Pivot Tables – I need more than rudimentary calculations

    Does anyone know of a site that exchanges calculation information for Pivot Tables???

    Firewoman15 pointsBadges:
  • 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

    Carourke15 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:
  • Deactivate Transfer Data To iSeries in EXCEL

    How do I deactivate the Transfer data To iseries link in EXCEL but still the Transfer Data From iSeries ACTIVE in Excel

    ESands5 pointsBadges:
  • How to search particular data in range of data and everytime save it in a cell

    How to search particular data in range of data and everytime save it in a cell in Excel using VB code

    VBA5 pointsBadges:
  • Switching custom views in Excel when filtering

    I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it to...

    Tsbarr15 pointsBadges:
  • How to change config to download all fields to Excel than Inbox

    Using menu path Plant AnalysisExportTransfer to XXL in MCBA to download all switch drill down fields but currently am brought to SBWP. How do I change it to allow down load to Excel?

    Janwong5 pointsBadges:
  • How to add another row header to Excel Report using Visual Basic

    HI, I want to add another row and column header to a Excel Report using Visual Basic..

    Jothi155 pointsBadges:
  • Shading on Click and Drag

    When I click and drag to paint a range of cells, the shading doesn't show up. Is there a way to change my preferences and darken the shading?

    Foreverstargirl5 pointsBadges:
  • Trouble with pf transfer to excel

    I want to transfer an externally defined data file from the as400 directly into an excel file format, then send the file via email. I have email already set up. My problem is getting the file translated correctly for excel. I do not have client access. I have used cpytopcd for spool files, but...

    zbbwoc95 pointsBadges:
  • Shift Differential

    How can I write a formula for shift differential if 06:00-14:00 is normal working, 14:00-22:00 is $1.00 more an hour and 22:00-06:00 is .90 more an hour? (A5 Work Hours ) (B5-Sunday start) (C5- Sunday End) (D5- Monday Start) (E5- Monday End) etc. Thanks you to any one that can help.

    Bradyman69920 pointsBadges:
  • how to save crystal report in excel format ?

    hi i wanna to save crystal reports as excel form so can anyone help me

    Romanticknight5 pointsBadges:
  • I am a student trying to convert a excel spreadsheet to a Access database.

    My questions: How do I convert data from an excel spreadsheet to a Access Database. How do I convert a access form to excel - Using the form as a front for data capturing. How do I link multiple users to a access database - making allowance for data to flow simultanously into the database.

    Joshua55 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