be excellent to each other
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 343988 articles for 1.612 sec
There is a way of "inserting" a worksheet into another file, but you'd have to do this 300 times - don't know if that helps ? Open up both Data1 and Data1g, on Data1g select "edit" and "move or copy sheet", copy the shet to the other open workbook and then save. -- Dave Eade EPCS Ltd www.EPCS.me.uk "A.A.A" wrote: > Hi, > I have 300 excel files and another different 300. I want     

Group: microsoft.public.excel.misc · Group Profile · Search for be excellent to each other in microsoft.public.excel.misc
Author: Dave Eade
Date: Sep 3, 2008 05:01

Hi, I have 300 excel files and another different 300. I want to merge one from the first 300 to one from the other 300,so that i will end up by 300 excel files each having 2 sheets one for the data from the first 300 files and the second sheet carrying the data from the other 300. Is this possible?If possible, could you explain the steps as i am new with the excel macros? My files are named
Show full article (1.29Kb) · Show article thread
My standard points: Splitting the code out has the advantage of creating a clear delineation of system layers (i.e. UI separated from the data access and business logic). Keeping the code in a data step converts an object-oriented system into a bunch of strings. Hence, you lose all metadata and context for the VBA. VBA also uses COM which causes file locking and is slooooowwwwww. It also raises     

Group: microsoft.public.excel.misc · Group Profile · Search for be excellent to each other in microsoft.public.excel.misc
Author: A.A.A
Date: Sep 3, 2008 04:39

I actually pull the XML into Excel myself first, and then Save as an = Excel Workbook; then give this final version to my users, so they never = see the popup and never know it was once an XML file! =20 Yes, you could format in VBA, but often I want to use the format that I = have created in SAS already (it is often ODS output from SAS statistical = procedures), and don't want to do it twice
Show full article (0.90Kb)
Yes, they are XML, and therefore larger, and that's why you get the = message when pulling into Excel (but they can be pulled into Excel 2007 = as well as 2003). I discovered them when I was really frustrated at = Proc Export for not retaining much formatting; Excel Tagsets are very = good at retaining formatting, and thus require less work once pulled = into Excel. Setting the style formatting     

Group: comp.softsys.sas · Group Profile · Search for be excellent to each other in comp.softsys.sas
Author: Alan Churchill
Date: Aug 19, 2008 13:09

As I recall, the files produced by default from excelxp tend to be much larger that those using a proc export or a libname statement due to additional formatting included within the file. However, the file size difference may not be significant in your case, or the formatting produced by excelxp may be what you want. Another reason that I have avoided using excelxp is that the files will result
Show full article (6.35Kb)
You can do this with Excel Tagsets, each time you want a new sheet issue a command like this with a new sheet name: ods tagsets.excelxp options(sheet_name='age65to84_nonsmoking'); Here is code that takes a dataset and writes each section it to a different sheet based on the by variable "sheetname". %%macro do_calls; ods listing close; ods tagsets.excelxp file='C:\Work_Activities\results_sheetnames     

Group: comp.softsys.sas · Group Profile · Search for be excellent to each other in comp.softsys.sas
Author: Mary
Date: Aug 19, 2008 12:21

"Update" may mean different things to different folks ... If you are saying that you receive update information in the form of Excel spreadsheets, you may still be able to use a link to those spreadsheets to "see" the data, then use queries to update your more permanent (and well-normalized) Access tables. For this approach to work, you'd need to have the same name and location for the
Show full article (5.48Kb)
This sounds like a message from the developer. I'd go back to that person and ask why he or she did this. SS wrote: > > Hi, I am the Office 2000 user. I encounter problem with printing an excel > worksheet each I edit the contents without saving. Here is the comment > message appeared each time I press the print / preview button: > > "To print, it is necessary to overwrite the content     

Group: comp.softsys.sas · Group Profile · Search for be excellent to each other in comp.softsys.sas
Author: Mary
Date: Aug 19, 2008 11:57

Show full article (3.58Kb)
    

Group: comp.softsys.sas · Group Profile · Search for be excellent to each other in comp.softsys.sas
Author: Bucher Scott
Date: Aug 19, 2008 11:45

Show full article (2.74Kb)
    

Group: comp.softsys.sas · Group Profile · Search for be excellent to each other in comp.softsys.sas
Author: Mary
Date: Aug 19, 2008 11:10

Show full article (1.75Kb)
    

Group: microsoft.public.access.externaldata · Group Profile · Search for be excellent to each other in microsoft.public.access.externaldata
Author: Jeff Boyce
Date: Aug 15, 2008 08:07

Show full article (1.82Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for be excellent to each other in microsoft.public.excel.misc
Author: Faz
Date: Aug 1, 2008 06:47

Show full article (0.27Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for be excellent to each other in microsoft.public.excel.misc
Author: Dave Peterson
Date: Jul 24, 2008 04:00

Show full article (0.54Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next