• VBA: Unprotect sheet, Update Stocks on Excel sheet, Reprotect sheet

    I was trying to update some stocks and commodities links on a protected sheet by creating a button to update but before the update occurs the sheet becomes protected. If I disable the re-protection of the sheet it will updated the stocks and commodity prices but the columns width doesn’t adjust...

    abcmustafa10 pointsBadges:
  • VBA code to transfer data from iSeries to Excel

    Hi everyone, could someone provide VBA code to automate the Transfer of data from the iSeries into an Excel 2003 Spreadsheet. Currently we have to manually use the iSeries Excel Add-In. All fields are left default except the Library/File field where we enter PRODDTA/F56EXT. The data then transfers...

    Mblair.au25 pointsBadges:
  • How to get STAAD output (Member End Forces) to Excel by using VBA

    How do I get STAAD output (Member End Forces) to Excel by using VBA? I want to get all member end forces from staad -- .ANL file to Excel. Can anyone tell me the coding for that?

    harshabec5 pointsBadges:
  • Arabic letter is appearing as symbol from AS/400 to Excel sheet

    I have a problem in extraction. When I try to extract a file contain a Arabic letter from the AS/400 to Excel sheet, the Arabic letter appear as a symbols. Is there is anything should I do to solve this problem, considering that the Arabic letter on my PC is working fine.

    osamah170 pointsBadges:
  • Change English numbers to Arabic numbers

    How I can change English numbers to Arabic numbers?

    Mark475 pointsBadges:
  • Default password user report in Excel spreadsheet

    How do I export the anzdftpwd (default passwords) user report to an excel spreadsheet

    DCORDERO4720 pointsBadges:
  • Auto populating Excel fields from an Access query

    How do you auto populate an Excel report leveraging data computed in Access - is there a link function?

    Brigita5 pointsBadges:
  • How to restore Excel files following format?

    I have a document in Excel, opened it and took a few records kept. A day later, open it, and instead of letters only the symbols. I search in Google this problem, found just what you need to try to restore the original document without my changes.

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

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