Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Error Message: 'Argument Not optional'

It always made me cry when I had to support multiple versions of the same thing.



Chip Pearson wrote:

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem auto generating e-mail to several recipients - argument not optional error message [email protected] Excel Programming 8 June 8th 07 03:21 PM
Argument not optional Error 449! Need Help bad_boyu Excel Programming 3 July 26th 06 12:52 PM
error message: compile error, argument not optional Pierre via OfficeKB.com Excel Programming 3 September 5th 05 03:45 PM
Function (array argument, range argument, string argument) vba Witek[_2_] Excel Programming 3 April 24th 05 03:12 PM
Complie Error- Argument not optional Roberta Excel Programming 5 April 4th 05 02:31 PM


All times are GMT +1. The time now is 07:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"