LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Need help - Filesaving - need to increment filename

You guys Rock !!

Works like a charm, i used the registry option, fits what i needed to
do.

i had to modify this line also for your info ;

sFN = "C:\Documents and Settings\guicha\bureau\cano\silo" & _
Format(i, "000.txt")


need to remove the .txt otherwise the file says silo001,txt.txt

Thanks again.

Guillaume.



*** Sent via Developersdex http://www.developersdex.com ***
 
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
previous post Increment a filename. katagrga Excel Discussion (Misc queries) 0 July 23rd 09 03:46 PM
Increment a filename alistew Excel Discussion (Misc queries) 4 July 10th 09 08:38 PM
Cell("filename") doesn't update to new filename when do save as. Louis Excel Worksheet Functions 2 March 22nd 07 07:27 PM
set filename to <filename-date on open bob engler Excel Worksheet Functions 2 July 13th 06 05:11 AM
Saving filename same as import filename Matt Excel Programming 4 February 24th 04 03:01 PM


All times are GMT +1. The time now is 05:56 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"