Free Microsoft Excel 2013 Quick Reference

import web data; end up wrong format in excel

http://img708.imageshack.us/img708/4823/errornf.png

Hello everyone, I tried to imported statistic data into excel, but when I imported the format changed.

I boxed the column in red, orange and green as you can see.

I also try to reformatted into text ONLY, and when I pressed the refresh button it return to original.

Does anybody have any idea how to resolve this?

Thank you


hi I listened to podcst642 yesterday about how to import web data from any given site to excel by using a web query, what if the data I want is on more than one set of records...

web query works for one set of records presented in one page, if I want the next set of records I have to execute another web query which means I have to log in to the site again pull out the records and choose record set number 2, than all over again and choose record set number 3... and that seems like to much trouble... I'm sure there's an easier way...

the amount of records I want to import are 5k+ and the page presents sets of records of 500

so I have to keep pressing the next button on the site quite often...

is there an easier way to do this?

How do i define a number format in excel for Indian Rupees. I didnt find it
in the drop down menu list in the numbers format.

Hello.i want to import web data from a site with soccer results...i've recorded a macro for it...the macro worked great but there is a little problem...here is the macro...

	VB:
	
 Macro1() 
     '
     ' Macro1 Macro
     '
    x=6 
    For x = 6 To 10 
        With ActiveSheet.QueryTables.Add(Connection:= _ 
            "URL;[url]http://www3.nowgoal.com/1x2/companyhistory.aspx?id=281&company=Bet[/url] 365&matchdate=2010-11" & x _ 
            , Destination:=Range("$A$3")) 
            .Name = "companyhistory.aspx?id=281&company=Bet 365&matchdate=2010-11-06" 
            .FieldNames = True 
            .RowNumbers = False 
            .FillAdjacentFormulas = False 
            .PreserveFormatting = True 
            .RefreshOnFileOpen = False 
            .BackgroundQuery = True 
            .RefreshStyle = xlInsertDeleteCells 
            .SavePassword = False 
            .SaveData = True 
            .AdjustColumnWidth = True 
            .RefreshPeriod = 0 
            .WebSelectionType = xlAllTables 
            .WebFormatting = xlWebFormattingNone 
            .WebPreFormattedTextToColumns = True 
            .WebConsecutiveDelimitersAsOne = True 
            .WebSingleBlockTextImport = False 
            .WebDisableDateRecognition = True 
            .WebDisableRedirections = False 
            .Refresh BackgroundQuery:=False 
        End With 
    Next x 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
i need the results from 6-11-2010 to 10-11-2010...the first day (6-11) is imported in cell a3...the second day(7-11) is imported in cell n3...i need to change the macro so the second day pasted in collumn a where the results of day one are finished.....

EDIT: please use code tags to format the VBA code

Hi Everyone,

Within VBA code to import web data, instead of spelling out a URL as source is it possible to specify a cell containing the URL such as B2 of Sheet1 ...

Thanks,

Have a great day!!

Hi all, newbie here and I would be very appreciative of some help please.
I have recorded a macro to import web data, from a sporting site,
problem is URL is date and event specific.

"URL;http://www.xxx.com.au?State=1&MeetingCode=M&Code=R&FromDate=2009-10-30T00%3a00%3a00&EventNumber=01"
_
        , Destination:=Range("A1"))
I need to be able to alter the date, meeting code and event number from the keyboard, is this possible?
And could someone assist please?

All the best

Charles Ash

Hi all

I have some code on a worksheet that basically dictates that the colour of text in column F is white unless the values of cells in column H are between 1-5 (see below).

On my Excel 2007, everything works fine and when a user selects a value between 1-5 in column H, it shows up (in black) the value of the relevant cell in column F.

However, in Excel 2003 there seems to be a delay in when this font colouring happens, and I was wondering if anyone knew why? (Unfortunately, most of the users of this worksheet will still be on Excel 2003.)

In 2003, when I select a value in H, I then need to navigate away from excel, then come back to it, and only then does the cell in column F show up as black - so is there a workaround for this? I'd be really grateful for any assistance!

Best wishes

Diane

    ' Data Validation List of numbers 1-5 and Select Score and default of ENTER SKILL LEVEL
    
    Range("H4:H25").Select
    Application.CutCopyMode = False
    With Selection.Validation
        .Delete
        .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
        xlBetween, Formula1:="<<Enter your Skill Level>>, 1, 2, 3, 4, 5"
        .IgnoreBlank = True
        .InCellDropdown = True
        .InputTitle = ""
        .ErrorTitle = ""
        .InputMessage = ""
        .ErrorMessage = "Please select a Skill Level between 1-5"
        .ShowInput = True
        .ShowError = True
    End With
    With Selection.Interior
        .ColorIndex = 2
    End With
    ' Conditional Formal on column F to show values when 1-5 entered in column H
    Range("F4").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
        "=AND(H4>0,H4<6)"
    With Selection.FormatConditions(1).Font
        .Color = 1
    End With


Hello to all,
I'm trying to import a data from a website using Microsoft Excel however the link is too long & when I do import data from web & I past the link in there, it says that it's too long and it won't let me. I know it's possible but just don't no how to do it, anyone can help ? Thanks guys.

Hi

Is there any way of turning off all automatic formatting in Excel 2003?

For example Excel automatically changes strings such as 1-12 in a CSV file
to 1-Dec, 10-10-2005 to 10/10/2005 and strings of numbers to an exponential
representation. These changes are preserved when saving the file and thus
corrupting it, preventing any other applications from reading it.

I know you can import CSVs changing all the fields to text using the data
import option, however reopening it and saving causes Excel to make the same
changes again.

Any suggestions would be really appreciated as this is causing us real
problems.

Thanks.

Adam

Hello Friends,
My team has an requirement to implement. In our application, we have a screen from where the user can enter data. We have provided the user an option to Export that data to Excel. We are using a third party control (Teleriks rad editor). The data entered in this control is saved in the form of HTML tags, so if a user enters THIS IS A TEST in bold format then the "<b>"THIS IS A TEST "</b>" will be saved in the database. So my concern here is that how do we display the HTML data that we recieve in XML format in Excel.

Another issue is that we have some format that the user will use, how do we ensure that the data entered from the UI is always shown in the exact same format..

Any sample code related to this would be of great help..

Thanks in Advance,
Tushar

i All,

I need help urgently for parsing a text file to have a specific format. The text file is of format mentioned below:

********************************************************
Workflow ID: 234784GH56
Name: Hyundai
Type: PUBLISH
Start Date: 2009-05-19 05:15 AM
End Date: 2009-05-19 06:03 PM

Task Name Completion Date
-------------------- -------------------
Content Contributor 2009-05-19 05:35 AM
sre_cit_approvers 2009-05-19 06:03 PM
Content Contributor 2009-05-20 10:50 AM

********************************************************
Workflow ID: 546456SD2
Name: Honda
Type: PUBLISH
Start Date: 2009-05-08 02:32 PM
End Date:

Task Name Completion Date
-------------------- -------------------
Content Contributor 2009-05-08 02:49 PM

********************************************************

Each section is divided by the stars (***). There are huge such sections. I need the end format in excel as below :

Workflow ID Name Type Start Date End Date Task Name Completion Date

http://lh6.ggpht.com/_NFAcYtsF_Gw/Si...WUJg/excel.jpg

The respective data should be in columns below each header. Task Name and Completion Dates can be 1 to many.

Please help me, am in urgent need. Pls let me know if u need more info.

Thanks in advance.

Apunan

I have a spreadsheet that the data, the date was input in Excel 2003 as
mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to
"dd:mm:yyyy"(31:12:2004)? I tried to change date
format from "Format Cells----choose "date" or "custom" and tried different
options, but they wouldnt change the data already in the cells. I have a
spreadsheet that Microsoft is requesting information in dd:mm:yyyy (yes
colons) format.

Thanks

Jack

Is there any way to get more (up to 10 at least) specifications for
conditional formatting in Excel?

Hi

I am familiar with setting up to 3 conditional formats in Excel spreadsheets
but I would like to be able to set up to 10, say.
Does anyone know how I can do this?

Many thanks

I have a spreadsheet that the data, the date was input in Excel 2003 as
mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to
"dd:mm:yyyy"(31:12:2004)? I tried to change date
format from "Format Cells----choose "date" or "custom" and tried different
options, but they wouldnt change the data already in the cells. I have a
spreadsheet that Microsoft is requesting information in dd:mm:yyyy (yes
colons) format.

Thanks

Jack

I did some formating in excel 2007 csv in order to reinport easily back into sas and am now having problems:
I formated a field filled with numbers into a txt field and the leading zeros did not appear. I need those leading zeros for the data set.
I formatted another numbers field to text but then when they appeared in SAS they were in scientific notation...here the issue is 2 fold...get back the complete number and keep it in txt...Any help will be appreciated.

How do i set up a formula in excel that is the tenth root of 7 versus the
square root of 7?

I have created a plot in eps format in excel and I would like to save the
plot as an Encapsulated PostScript file for use in another document. I do
not want to save it as a bitmap first and then convert it as enlarging a
picture saved this way will make it look fuzzy and grainy.

Surely there is a way for excel to save pictures as eps files??

Dear All,

How can I convert Arabic numbers to English text format in EXCEL?

Example:
123 --> auto convert to "One hundred twenty three"

Many thanks!!

Cheers, Mac

Is it possible to have more than 3 conditional formats in excel? I find that
I need 4 formats.
I am using Excel 2000. Can Excel XP or 2003 use more than 3 formats?

Is it possible to change the default number format in Excel?

Dear All,

How can I convert Arabic numbers to English text format in EXCEL?

Example:
123 --> auto convert to "One hundred twenty three"

Many thanks!!

Cheers, Mac

Hi
I am new to conditional formating in Excel.

In row 2 I need to enter nos. between 1-5. I want each color to have a
particular color. I have managed to do 4 (3 with conditional formating and
the 4th retaining the default color).

Is there a way i can do all 5 colors?

Thanks

I want to know if it is possible to select a different default number format
in Excel 2003 so that it will apply automatically when I open a new workbook.

Hello,

Not sure if this is possible, but is it possible to bring up a calculator in Excel 2007 by invoking some VBA command?

Thank you