About 90 results
Open links in new tab
  1. Open ASP files in Excel | MrExcel Message Board

    May 10, 2010 · Hi , I am here again looking for help. I have asp files in a folder ranging between 7 and 12 in total. Can someone help me append each file to a excel worksheet with VBA code files are like …

  2. Importing from a local .aspx file in Excel 2007?

    May 30, 2015 · I have a local .aspx file that I generated by downloading from an HTML web page (the browser extension saves it as .aspx...not entirely sure why.) It contains a few hundred tables that I …

  3. Cannot import data from Excel 2013 into ASP file

    Feb 7, 2014 · I am using Excel 2013, and I am following the example here: VBScript Scripting Techniques: Read Excel files without using Excel that reads in Excel data as an ADO record set to a …

  4. Downloading files from protected website with VBA-Excel

    Dec 9, 2019 · I'm trying to download a file from a protected webpage (from my job, so I cannot post the url). When I save the bytes (I'm using a WinHTTP request), in an .xls, the file appears to be …

  5. Export Asp recordset to Excel file? | MrExcel Message Board

    May 20, 2004 · Hi, I'm wondering can anyone start me off in the right direction! I have an asp page and when the user clicks a button i want to take the data in a record set and export it to excel and save …

  6. Excel VBA automation for websites with Login

    Oct 22, 2015 · The second POST-request sends my download-request for the csv-file. Here I added the method "setRequestHeader "Cookie", Cookiestring" to let the server know that im authenticated.

  7. VBA to tell if file is READ ONLY | MrExcel Message Board

    Sep 21, 2016 · I added the piece to check if file is readonly...yet still, the file opens a second time without prompting the message box, although the file itself opens as read only...could you kindly help …

  8. How to change the default Addins folder? - MrExcel

    Nov 21, 2007 · You must create one OPEN command in the registry key HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel for each file you want …

  9. Error: The INI file was not found | MrExcel Message Board

    Jul 31, 2003 · Forums Question Forums Excel Questions Error: The INI file was not found Tony van Bokkem Jul 31, 2003 T

  10. How to Save PDF opened in an IE page thru VBA - MrExcel

    Sep 5, 2013 · Hi Everyone, I am creating a VBA macro. The purpose of this macro is to open a webpage and click on hyperlink and save the newly opened webpage in a separate window (it opens in PDF …