Re: Error Message: 'Argument Not optional'
- From: "Chip Pearson" <chip@xxxxxxxxxxxx>
- Date: Mon, 9 Jul 2007 11:24:04 -0500
Dave,
I think you're absolutely right about deleting the HTML content and leaving only the redirect. I'll do that sooner rather than later, maybe even today.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message news:46924A13.4D8167FC@xxxxxxxxxxxxxxxxxxx
Thanks for the info.
I looked at the two ImpText pages and didn't see a compelling reason to keep the
.html version -- except for redirection to the newer .aspx page. (At least in
this case.)
I would think it would be better for me, er, the typical user if the .hmtl
content were deleted--and just leave the link (or automatic redirection to the
newer page).
Obviously, the choice is yours, but someday, you're gonna find an error on one
of the .html pages that you just can't live with and you'll be updating that,
too. (I'd put money on it!)
Chip Pearson wrote:
> At some time, will you make the old page redirect to the new page
> automatically?
At present, I'm just putting a note and link at the top of the superseded
pages pointing to the new page. Once I get the bulk of the pages converted
(it is a big job -- over 200 pages to convert) each html page will
automatically redirect to the corresponding aspx page. All aspx pages will
have the same name as the original html page, only with an 'aspx' extension
instead of an 'htm' extension. Due to the number of links pointing to my
pages as well as the Google Groups archives, the html pages will never go
away. Once an aspx page has been created, I will no longer update the html
page, but the html page will continue to be available.
I just changed web hosting services (more features, space, and bandwidth for
less money than the old provider) so I have space to keep two version of the
site running, the html version and the aspx version.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:46916DED.1973FC5D@xxxxxxxxxxxxxxxxxxx
> Chip,
>
> At some time, will you make the old page redirect to the new page
> automatically?
>
> It'll make it slightly easier for google searchers and copy|paste > posters
> (like
> me!).
>
> Ps. I just read your "before you email me" page.
> http://www.cpearson.com/excel/EmailMe.aspx
>
> And thought that you may want to provide a note to try the > newsgroups/MS
> Communities or even search google before contacting you.
>
>
>
> Chip Pearson wrote:
>>
>> Yes, the example code on my web page was in error. I wrote the code >> years
>> ago and only very recently added the 4th parameter, which indicates
>> whether
>> to append the data to an existing output file (AppendData:=True) or to
>> purge
>> the output file before writing to it (AppendData:=False). I updated >> the
>> procedure code but neglected to update the examples. I have updated >> the
>> page
>> with the correct example code. I considered making it an Optional
>> parameter
>> but didn't because I felt that something as important as preserving or
>> killing off data shouldn't be left as a default behavior. For safety's
>> sake,
>> I wanted the user to have to explicitly state whether to kill off a >> data
>> file.
>>
>> That said, I'm converting my entire site from simple and crude HTML to
>> fully
>> compliant XHTML 1.1 Strict with ASP.NET 2.0, and that particular page >> has
>> been superseded by the page www.cpearson.com/excel/imptext.aspx . The
>> aspx
>> page had the correct example code all along.
>>
>> --
>> Cordially,
>> Chip Pearson
>> Microsoft MVP - Excel
>> Pearson Software Consulting
>> www.cpearson.com
>> (email on the web site)
>>
>> "ryguy7272" <ryguy7272@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:36AE5518-7FE9-48D1-A1FF-0651807A6FAE@xxxxxxxxxxxxxxxx
>> > This is probably something easy, but when you donâ?Tt know what to >> > do
>> > it is
>> > hard. Basically, I copied Chipâ?Ts code form the following URL:
>> >
>> > http://www.cpearson.com/excel/imptext.htm#Export
>> >
>> > Then I run the code and the get an â?~Argument Not optionalâ?T >> > message.
>> > The
>> > following line is tinted blue:
>> > ExportToTextFile
>> >
>> > I looked at some DG topics that discussed â?~Argument Not >> > optionalâ?T
>> > but didnâ?Tt
>> > get anywhere. I Googled the topic, and tried to figure out what is
>> > going
>> > on...nothing jumped out at me. Basically, I didnâ?Tt find anything
>> > that
>> > seemed
>> > helpful. I also looked under Tools > References (I had my doubts >> > about
>> > this,
>> > but tried it anyway). I clicked on Export 1.0 Type Library; it >> > still
>> > doesnâ?Tt
>> > work.
>> >
>> > Typically, I am resourceful, and try to resolve issues by myself, >> > but
>> > Iâ?Tve
>> > hit a wall, and donâ?Tt know what to do now. I thought I was just
>> > starting
>> > to
>> > get somewhat proficient with this VBA stuff and then something that
>> > should
>> > be
>> > extremely simple (can you say copy/paste) vexes me. Can anyone >> > offer
>> > some
>> > insight or give me some kind of guidance
>> >
>> > Thanks so much!
>> >
>> > --
>> > RyGuy
>
> --
>
> Dave Peterson
--
Dave Peterson
.
- Follow-Ups:
- Re: Error Message: 'Argument Not optional'
- From: Dave Peterson
- Re: Error Message: 'Argument Not optional'
- References:
- Re: Error Message: ‘Argument Not optional’
- From: Chip Pearson
- Re: Error Message: ?Argument Not optional?
- From: Dave Peterson
- Re: Error Message: 'Argument Not optional'
- From: Chip Pearson
- Re: Error Message: 'Argument Not optional'
- From: Dave Peterson
- Re: Error Message: ‘Argument Not optional’
- Prev by Date: Re: Can Excel "extract" ranges of numbers listed in the A column?
- Next by Date: Re: Relate a Number with an ARRAY
- Previous by thread: Re: Error Message: 'Argument Not optional'
- Next by thread: Re: Error Message: 'Argument Not optional'
- Index(es):
Relevant Pages
|
