LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
EJF EJF is offline
external usenet poster
 
Posts: 1
Default minor but irritating problem when generating Excel files with Perl


This may not be an appropriate question for this forum, since it doesn't
concern VBA, but I didn't know where best to post it.

I generate a fair number of Excel files using Perl. I generate the file
with Perl, I open it for the first time in Excel, I make some changes in
Excel, and then when I go to close the file (or when I hit "save" to
save changes), a window pops up and says "save file as" (with the
correct name in that window) and the "file type" window is always set
as "text tab delimited". And then each time, I change the file type to
Excel Worksheet and then hit save, and I get the "a file with this name
already exists here - do you want to replace it?" message. And of course
the file that already exists there is the same file that I'm working on.
So basically, the first time that I open a file that I generate with
Perl, Excel thinks that I have opened a brand new blank document (text
tab delimited, for some reason) and just pasted in all this stuff and
now need to decide whether or not to save this new file. Is there
something I can do to get around this?

Thanks.

Eric


--
EJF
------------------------------------------------------------------------
EJF's Profile: http://www.excelforum.com/member.php...o&userid=32065
View this thread: http://www.excelforum.com/showthread...hreadid=518842

 
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
excel, install perl script 2apart Excel Discussion (Misc queries) 0 March 26th 08 11:28 PM
Disable Excel Command Bars and Remove Irritating Grey Bar Andy B via OfficeKB.com Excel Programming 0 December 8th 05 09:23 AM
excel, vb arrays and perl Mark Seger Excel Programming 0 June 4th 05 01:11 PM
Excel 2000 Macro and Perl problem Jim Simpson Excel Programming 0 May 19th 04 06:45 PM


All times are GMT +1. The time now is 08:19 AM.

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"