• Access to Excel and Word files on a PC through thin client

    I have a PC and thin clients in our bank. How can I access to Excel and Word files on PC through thin client?

    Sanjumaur5 pointsBadges:
  • MS Excel 2007 load data into database

    I am using MS excel 2007 and would like to upload data into DB2 database. I could do this before on my older version of Excel. How do I do this with MS Excel 2007?

    Geyes15 pointsBadges:
  • New to macros – extracting data

    Hello, I'm just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box (course...

    Oistins2610 pointsBadges:
  • VBA Exporting to text file

    I am trying to make a VBA to copy multiple cells from excel to notepad in this sort of format: Interface GigabitEthernet1/0/1 Switchport access vlan 990 shut But all I seem to be doing is copying the top line over and over again. Here's the code I've been using: Sub exprtToText() Dim ff As Long,...

    Dozii35 pointsBadges:
  • Multiple Names in Excel 2007

    I have a Excel sheet with hundreds of names and the same person may be repeated twice How do I create a formula so that I can like it to a new sheet and it only show a persons name one time?

    Maine325 pointsBadges:
  • VBA format a cell based on range contents

    I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. 'assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As Worksheet Set wsOT = _...

    VbaNewb1315 pointsBadges:
  • Converting an Excel 2013 file to a flat file in notepad for SQL Server 2008 R2 export/Import Wizard

    I am a student. I have to convert an Excel 2013 spreadsheet with 7 tabs of different table information. I have to then import it from my host computer into SQL Server 2008 R2 which is located on my virtual machine. Please help me and if you need more information, then let me know. Thanks in advance!

    Ronnibelle5 pointsBadges:
  • VBA copying a range from Excel and pasting to a text file

    Do you know how to copy from excel and paste to a text file using VBA?

    TBone555 pointsBadges:
  • Paste from Microsoft Excel cells to Microsoft Access table successfully but…

    When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

    Lpjedpp5 pointsBadges:
  • Upload invoice numbers to the concerned PO in AS/400

    How to I upload invoice numbers to the concerned PO in AS/400?

    rajik45 pointsBadges:
  • Script to extract files information from FTP server

    Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string "abc". The...

    Aiko2720 pointsBadges:
  • Search for duplicates in a collumn and delete the row on which it occurs

    Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would rather avoid...

    Harleq20 pointsBadges:
  • Linking Information in two seperate Workbooks

    I need to create a Workbook that has certain cells accessible for people to enter in their information and then have the ability to pick from a drop down list that will auto populate a name beside the job number chosen. I have managed to do this using V lookup however the main source Workbook opens...

    CleanEnergy5 pointsBadges:
  • Select documents from a Notes View and paste into Excel

    I'm looking for code to select documents from a particular view and then paste it in a particular template of a Microsoft Excel spreadsheet. Is this possible? And if so, can anyone offer me some sample code?

    Domino Ask The Experts435 pointsBadges:
  • Problems using VLOOKUP in Excel 2003 spreadsheet

    I have an Excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a...

    Ironsprings5 pointsBadges:
  • Linking cells in an Excel spreadsheet

    I have an Excel spreadsheet that has 350 rows with 31 columns of information and I need to print each row separately. I only need the information from 23 of the columns to be printed on each page. I created a new spreadsheet listing the 23 column names and then in the cell underneath it, I linked...

    Teicneoir220 pointsBadges:
  • Outlook 2007: Where does it store opened attachments temporarily

    One of my good friends (mistakenly) double-clicked a Microsoft Excel attachment from an Outlook email, saved it, closed Excel and the email but now we can find the email. Does anyone know where the file might be hiding? Would it be in a temporary folder? Thanks so much.

    ITKE366,645 pointsBadges:
  • How can I find an Excel formula that helps me change text?

    How can I find a formula that helps me change letters in typed words without the daunting task of retyping them again? For example, I typed (in a table) 100 words ending in -d, and I want the same words just without the -d or with -s instead. Or can I join letters to form different words? Copy and...

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

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