Import plain text with formulas into Excel

Read the text file and parse it yourself.

When you find a value that looks like a formula (starts with an equal sign??),
you can process that string special.

Chip Pearson has some code at:
http://www.cpearson.com/excel/imptext.htm

It looks to me like there would be one line to change:

Cells(RowNdx, ColNdx).Value = TempVal
becomes
Cells(RowNdx, ColNdx).Formula = TempVal

But be a little careful.

If your text strings contain commas:
=if(a1="",a1+3,a1^2)
You'll have to parse that as one string.





schmiedel wrote:
>
> I'm having some trouble in Excel. If I create a plain text file like the
> following:
>
> 1,2,3
> 4,5,6
> =sum(a1:a2), =sum(b1:b2)
>
> Nothing can be done as if in spanish is (SI), iserror is (ESERROR), and
> so on. This really sucks as I can't just install other software on the
> server nor make other modifications.
>
> I don't know what Microsoft was thinking when they translated the
> versions; any Excel version should accept it's language commands and
> English commands, but well, that's too much to ask for...
>
> Any good sugestions?
>
> Regards
>
> --
> schmiedel
> ------------------------------------------------------------------------
> schmiedel's Profile: http://www.excelforum.com/member.php...o&userid=28086
> View this thread: http://www.excelforum.com/showthread...hreadid=475927

--

Dave Peterson

This line doesn't apply:

> When you find a value that looks like a formula (starts with an equal sign??),
> you can process that string special.

I looked at Chip's code after I wrote that and should have deleted that
sentence.

Dave Peterson wrote:
>
> Read the text file and parse it yourself.
>
> When you find a value that looks like a formula (starts with an equal sign??),
> you can process that string special.
>
> Chip Pearson has some code at:
> http://www.cpearson.com/excel/imptext.htm
>
> It looks to me like there would be one line to change:
>
> Cells(RowNdx, ColNdx).Value = TempVal
> becomes
> Cells(RowNdx, ColNdx).Formula = TempVal
>
> But be a little careful.
>
> If your text strings contain commas:
> =if(a1="",a1+3,a1^2)
> You'll have to parse that as one string.
>
> schmiedel wrote:
> >
> > I'm having some trouble in Excel. If I create a plain text file like the
> > following:
> >
> > 1,2,3
> > 4,5,6
> > =sum(a1:a2), =sum(b1:b2)
> >
> > Nothing can be done as if in spanish is (SI), iserror is (ESERROR), and
> > so on. This really sucks as I can't just install other software on the
> > server nor make other modifications.
> >
> > I don't know what Microsoft was thinking when they translated the
> > versions; any Excel version should accept it's language commands and
> > English commands, but well, that's too much to ask for...
> >
> > Any good sugestions?
> >
> > Regards
> >
> > --
> > schmiedel
> > ------------------------------------------------------------------------
> > schmiedel's Profile: http://www.excelforum.com/member.php...o&userid=28086
> > View this thread: http://www.excelforum.com/showthread...hreadid=475927
>
> --
>
> Dave Peterson

--

Dave Peterson