Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Dealing with XLS file with multiple tabs
Homework and Emergencies Emergency UNIX and Linux Support Dealing with XLS file with multiple tabs Post 302898301 by SriniShoo on Monday 21st of April 2014 09:08:03 AM
Old 04-21-2014
VBA Code
Code:
Sub Splitbook()
MyPath = ThisWorkbook.Path
For Each sht In ThisWorkbook.Sheets
sht.Copy
ActiveSheet.Cells.Copy
ActiveSheet.Cells.PasteSpecial Paste:=xlPasteValues
ActiveSheet.Cells.PasteSpecial Paste:=xlPasteFormats
ActiveWorkbook.SaveAs _
Filename:=MyPath & "\" & sht.Name & ".xls"
ActiveWorkbook.Close savechanges:=False
Next sht
End Sub

---------- Post updated at 09:08 AM ---------- Previous update was at 09:02 AM ----------

This code is tested and working for me
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to delete multiple space or tabs from a read only file

Hi, Actually I am want to cut the three fields of "file-nr" file. $ cat /proc/sys/fs/file-nr 638 219 52270 I want to assign these value to diffrent varibales as follow:- a=638 b=219 c=52270 I tried to use cut command for this purpose and also tried to squeeze all sapces... (6 Replies)
Discussion started by: bisla.yogender
6 Replies

2. Shell Programming and Scripting

converting xls file to txt file and xls to csv

I need to convert an excel file into a text file and an excel file into a CSV file.. any code to do that is appreciated thanks (6 Replies)
Discussion started by: bandar007
6 Replies

3. Shell Programming and Scripting

Converting huge xls(having multiple tabs) to csv

hello I have browsed for the similar requirement i found this https://www.unix.com/shell-programming-scripting/40163-xls-csv-conversion.html but my problem is i have multiple tabs in xls file having same metadata I want to convert it into single csv file any ways to do it pls... (5 Replies)
Discussion started by: joshiamit
5 Replies

4. Shell Programming and Scripting

dealing with dates in a text file

hi guys im trying to write a bash script that grabs expired domain names it leaves me with the following outpiut in a text file Im hoping to try to normalise all the dates to the format displayed in the first 2 lines and remove the times so the file looks unfirom can any one give me a... (9 Replies)
Discussion started by: dunryc
9 Replies

5. Shell Programming and Scripting

Dealing with multiple files

Korn Shell I have hundreds of small files like below created every day. A midnight cron job moves them to the location /u04/temp/logs But sometimes I have to manually move these files based a certain dates or time. I have two basic requirements 1.Using mv command I want to move all .dat... (2 Replies)
Discussion started by: kraljic
2 Replies

6. UNIX and Linux Applications

Firefox Warning message for closing with multiple tabs not working

Can anyone explain why firefox warning message for closing with multiple tabs not working. The checkbox for warning when you have multiple tabs is checked so I don't understand why its not working. (0 Replies)
Discussion started by: cokedude
0 Replies

7. UNIX for Advanced & Expert Users

Shell script for dealing with XLS file with multiple tabs/worksheets

Hey Guys , Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below : 1. Convert one XLS file with multiple tabs to multiple CSV files. -- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (2 Replies)
Discussion started by: himanshu sood
2 Replies

8. Shell Programming and Scripting

Script to launch a KDE Konsole window with multiple tabs

Gents, I found this script to to launch a KDE Konsole window with multiple tabs.. #!/bin/bash # # Create my standard konsole windows. if ]; then profile=Shell fi sessions=( sh1 $profile 'clear; bash' sh1 $profile 'clear; bash' su1 $profile 'clear; su'... (1 Reply)
Discussion started by: jiam912
1 Replies

9. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

HI, I have multiple files per dept in folder for eg : In a folder File1_Dept100.xls File2_Dept100.xls File3_Dept100.xls File1_Dept200.xls File2_Dept200.xls File3_Dept200.xls Output should be : Dept100.xls which has File1, File2, File3 in different tabs Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies

10. UNIX for Beginners Questions & Answers

How to check string contain multiple tabs or spaces?

str contains tabs and multiple spaces str="hello world. How are you?" I want to check string start with hello world, and my code is: if ]world"* ]]; then echo "found" else echo "not found" fi Not work Other solution may work is to replace all tabs and... (4 Replies)
Discussion started by: cmdcmd
4 Replies

LEARN ABOUT DEBIAN

freespeak

freespeak(1)							   User Commands						      freespeak(1)

NAME

       freespeak -- GNOME frontend to online translator engines.

SYNOPSIS

       freespeak  [--version]  [-h, --help]

DESCRIPTION

       With FreeSpeak you can translate text and web pages using online translation engines.

       To  perform  a  translation  select your translator of choice. Then you select the languages through which you wish to translate your data.
       Finally press the "Translate" button.

       You can translate both text and web pages. Some translators don't support both modes so it may happen that your preferred translator is not
       present in the drop down list.

       You can tune all FreeSpeak settings in the preferences dialog.

       Copy to clipboard
	      Copy the translated data to the clipboard once the translation is complete.

       Paste from clipboard
	      Paste data to be translated, from the clipboard to the GUI. This only happens when you open a new translation.  If you are trying to
	      perform a web page translation and the clipboard is not holding a valid URL, FreeSpeak is not going to paste it in the URL entry.

       Default translator
	      The translator to use every time you open a new translation. It will be set in the drop down list only if the translation  mode  you
	      requested is supported by the translator you chose.

       Key bindings
	      Set several desktop-wide key bindings for doing quick translation operations.

OPTIONS

       --version Display version number with copyright and exit.

       -h, --help
		 Show help message.

AUTHOR

       This manual page was written by Luca Bruno lethalman88@gmail.com.

REPORTING BUGS

       Report bugs to <lethalman88@gmail.com> or visit the bug tracker at http://developer.berlios.de/bugs/?group_id=10396.

COPYRIGHT

       Copyright (c) 2008 Luca Bruno <lethalman88@@gmail.com>.

       Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or
       any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts.

FreeSpeak 0.3.0 						   JANUARY 2009 						      freespeak(1)
All times are GMT -4. The time now is 05:06 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy