.csv

  1. S

    want to download multiple pages in to excel form web

    dear, i want to download historical data for one stock from yahoo i tried but when importing web data its possible with only one page, where the stock has multiple page. how can i import data for multiple pages. the .csv format of the file is available there but how to...
  2. J

    How To keep Columns when Using a Macro to automatically save a .csv file

    I'm using a Macro that when activated saves a file as a .csv (MS-DOS) file. When saving it automatically it saves all information to Column A with a comma delimter. When you save the .csv (MS-DOS) file manually it prompts you with an "Error Message" . ".csv may contain features that are not...
  3. J

    .CSV format issue with VBA Macro - Auto-Saves without Columns kept

    Hey All Thanks for your help in advance, My Issue: This code works fine but my main question/issue is the difference to when you manually save a .CSV (MS-DOS) File you are prompted with the following message " .csv may contain features that are not compatible with CSV (MS-DOS). Do you want to...
  4. H

    Executing Store Procedure containig Bulk Insert Command with macro/VBA excel 2010

    Hello everyone and thanks in advance for your help. My first post here, it's been a while since I'm working around this issue and need your help. I have a Store procedure wich has a Bulk Insert command using dynamic SQL that works ok when executed from SQLManagmentStudio. The SP is included...
  5. ClimoC

    The Server, The CSV, and the TMP files

    Arvo Thought I'd put this in here rather than the Excel one as the bulk of the code is ADO. So the system I have setup has a read-only workbook that connects to CSV databases, edits them, and saves them back out again (meaning only one workbook to debug!) I have researched and been made aware...
  6. A

    Maintaining Leading Zeros when saved as a .CSV File

    I have a column, formatted as "text" with a 7-character alphanumeric code. Some codes have a leading zero. When I save the Excel file as a .csv, then reopen it, the leading zero disappears. I need that zero as this is my unique identifier field. I've tried the ' in front, I've tried formatting...
  7. L

    Numbers converting to Scientific Formats in .csv files

    I know this question has been asked a bajillion times, so I apologize for the redundancy. I am working with an Excel spreadsheet and saving it as a .csv file in order to upload to an application that parses out the .csv data as transactions. The system requires .csv files, so this is how I need...
  8. Y

    Saving as 2 file types with active workbook name

    Hello, I'm trying to save multiple workbooks as both .xls and .csv I recieve .xls files, make consistent changes, then save the updated workbook in both formats in seperate folder. How can I do this in VBA? I want to keep the same name as what I opened the file as My current isn't...
  9. S

    .csv

    One of the users I support is copying and pasting data into an Excel 2003 or 2007 file, she has both, and needs to keep the formatting in 2 columns. One for the date to be shown as 09/03/08 and the other to show the numbers with two numbers after the decimal point (352.20). I know that when you...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top