• How to run AS/400 commands through Excel macro

    I need to run AS/400 commands through Excel macro. Please help on this. This is repetitive task, has to run every time entering and giving common fields.

    hemasekhar5 pointsBadges:
  • Exporting .bqy keeping colors

    I have huge .bqy files in Experion to export to Excel, over 200,000 rows. Usually I do .txt then .xls but the .txt export does not carry the colored cells in the .bqy, that I need to keep for further analysis.  When exporting as HTML file it keeps the colors, but allows only 65,000 rows to be...

    xixaxixa12345 pointsBadges:
  • Size option gone in Excel 2010

    All of my charts were 11 x 17. That option disappeared now all my charts are too small.

    RichardCarlisle5 pointsBadges:
  • Finding the exact location of macro in Excel

    I have added sheets and then when I'm pasting the temporary macro the output is coming as false then. What is the solution regarding this? Its really urgent. This a Main File. http://justpaste.it/itkk This temp macro file which I have calculated from Excel sheet those code should be pasted in check...

    zaka20125 pointsBadges:
  • Lotus Notes unable to open xlsx.zip attachment with Excel

    My Lotus notes isn't able to open xlsx.zip attachment with Microsoft Excel. What should I do?

    Mcguyver5 pointsBadges:
  • Sparklines in Word or Excel

    Has anyone ever used sparklines in Word or Excel (both Office 2003 versions? What tool(s) did you use? What did you find best to use to summarize large numbers of data points (>25,000)? Thanks for the assistance.

    Labnuke9932,960 pointsBadges:
  • Opening two Excel files at the same time

    Two weeks ago I find out a problem with an Excel file. And this is very weird trouble. I can open the file both under File-Open and by doubleclicking on its icon without problems. BUT if I try to open a second file while the first is opened I can not do it. How can I open two excel files normally...

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

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.