LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default macro to save current excel sheet only without losing formatting

I have a macro that saves the current worksheet only (fileformat=xlNormal),
and automatically generates a new filename, but formatting is lost, so
reprinting the sheet looks completely different from the original.
 
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
how to save current sheet Raz Excel Discussion (Misc queries) 4 December 15th 09 11:21 PM
Losing Conditional Formatting after Save robert morris Excel Discussion (Misc queries) 5 April 11th 09 03:21 PM
Save Current Sheet Only snax500 Excel Discussion (Misc queries) 1 May 8th 08 05:57 PM
Save current sheet to new file Danno 24/7[_2_] Excel Discussion (Misc queries) 1 May 8th 08 04:32 PM
Can't save chart as object in current sheet Ann Scharpf Charts and Charting in Excel 1 December 3rd 04 11:24 PM


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