• How do you convert Excel file to XML

    How do you convert an Excel file to a Macro File XML

    DavidWilliams695 pointsBadges:
  • Delete characters in Microsoft Excel cell

    Hi experts, Can anyone tell me how to delete certain / specific characters inside a Microsoft Excel cell? Basically - I have a name that's surrounded by brackets. I want to remove the brackets. How can I do that? Thanks!

    ITKE435,850 pointsBadges:
  • Rename Microsoft Excel worksheets using C#

    I recently created a Microsoft Excel workbook that has name sheets (like sheet1, sheet2, etc.). Would I be able to rename these sheets dynamically using C#? Thank you.

    ITKE435,850 pointsBadges:
  • VBA: Set bold on specific text in Microsoft Excel string

    In Microsoft Excel / VBA, can I bold specific text in my string that would go into my cell? What formula should I use?

    ITKE435,850 pointsBadges:
  • VBA: Call FM SAPWL_STATREC_READ_REMOTE failed

    Hi Experts, We monitor the response time of different SAP and Customer programs before and after any release change. We use the workload statistics in transaction STAD and export the data into Excel manually. We would to automate this process by using Excel VBA Script and download the workload...

    walidde20 pointsBadges:
  • How to best protect Microsoft Excel database

    I currently have a Microsoft Excel database that's been performing a few different macro functions and it needs to be sent out to various people. But I don't want them to see how the macro works. What would be the best way for me to protect that? Can I password protect it?

    ITKE435,850 pointsBadges:
  • Create Microsoft Excel document in ASP.NET

    Would I be able to create a Microsoft Excel document using ASP.NET? I have to send a customer constant documents through a browser using XML or LINQ. What's the best way here? Thank you.

    ITKE435,850 pointsBadges:
  • Export SSRS to Microsoft Excel without any headers

    I have a SSRS report that I need to export to Microsoft Excel. But here's the kicker - my header that's on the first page of the report has to be removed from Excel. How can I do that?

    ITKE435,850 pointsBadges:
  • Activate Microsoft Excel worksheet

    For Microsoft Excel - I have to activate one specific worksheet. I already created a variable that will keep the name of my worksheet. How can I go about doing this? Thank you.

    ITKE435,850 pointsBadges:
  • Add text to Microsoft Excel blank cells

    In Microsoft Excel spreadsheet, I have a bunch of blank cells that I need to add the same value into. How can I do that? All that needs to be done is add NULL into all of them. Thanks!

    ITKE435,850 pointsBadges:
  • Running macro when Microsoft Excel cell is changed

    Does anyone know if there's a way to have Microsoft Excel execute a macro when one of my cells is changed? Would worksheet events work for this? Thanks so much.

    ITKE435,850 pointsBadges:
  • How to see to data in BIN file

    How to get the data through BIN file?

    iswpravinmkar5 pointsBadges:
  • What exactly is Excel?

    Are the Excel and spreadsheet the same?

    fayezppkts5 pointsBadges:
  • How to block specific cells, columns or rows in an Excel spreadsheet

    Could you please bo so kind to provide the way of blocking some specific cells, columns or rows in an Excel sheet?

    EMART00215 pointsBadges:
  • How to import data from Excel to grid view based on excel sheet Name?

    How to get excel document data from data grid view based on selected sheet name? I cannot find the answer.. Whenever i have to get 1st sheet data only. How do I do this? I need your suggestions. This is my source code: private void BtnBrowse_Click(object sender, EventArgs e) { DataTable dt = new...

    SathyaSri50 pointsBadges:
  • Create an Excel spreadsheet from iSeries spool file

    Using the DSPUSRPRF command, I want to create an outfile, then I will want to take the spool file and create a PDF, then email it to users. Can someone offer the steps I would need to take to accomplish this? Thanks for any help you can offer.

    Rrbond07140 pointsBadges:
  • What does =Macro!B40 mean in Microsoft Excel?

    What is =Macro!B40? And how to see the macro in an Excel sheet and what value in B40?

    teresa1235 pointsBadges:
  • Conditional Excel Formatting based on top values in a range

    I am looking to create conditional formatting based on the top n values in a range. Values in c1 to l1 (10 values). I want the number of values to change so want to base it on the value in cell b1 rather than simply using the top 6 conditional formatting so that I do not need to keep changing the...

    kerry7715 pointsBadges:
  • Hide connection/query settings in Excel

    I have created some Excel spreadsheets that use an external connection and MS query to download data into the SS. (No VBA involved). I would like to hide the query and connection information from users, or make it inaccessible. I want to avoid users making changes to the connection and/or query...

    azohawk2,020 pointsBadges:
  • What are the basic parameters needed to assist an automation tool?

    My concern is what are the basic key parameters to be considered for assisting an automation tool. In my company we are automating database (MySQL - Queries) part using 1st approach: Using stored procedures. 2nd approach: Using Excel VBA Macros.  For that we need to assist some basic parameters...

    VijayVardhan5 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.

Thanks! We'll email you when relevant content is added and updated.

Following