.csv

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

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

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

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

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

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

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

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

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