• How to open an Excel file

    My Excel file got corrupted and now has now a file extension .xlsx.wzzzpin. How can I open this file?

    Job40Auruku5 pointsBadges:
  • How to repair corrupted files

    My MS Word, Excel and PDF files have been corrupted and these files are showing there file extension as "qbnzgel". How to open this type of files?

    tanveerhamza5 pointsBadges:
  • Why won’t my Excel fields link for a subreport?

    I am trying to use an Excel file as a source for my subreport in Crystal 2008. I am able to create a simple report using the Excel file alone, but when I try to use it as a subreport, it will not link. Help!

    AngelaK15 pointsBadges:
  • How to get AS/400 macro to pull data from Excel

    Hello I’m trying to create a macro on the AS/400 that will pull data from an Excel sheet and input data to the screen. I know how to create a macro to run the menu option by using the record macro button but not sure how to get it to access the excel file so it will run through the list.

    dluy688035 pointsBadges:
  • 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:
  • Excel cannot open the file ‘file.xlsx’ because the file format

    Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

    weinmagaul5 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:

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