search for: activesheet

...ve, int?gr?e) riched20 (native, int?gr?e) usp10 (native, int?gr?e) My problem is that I can't open existing modules in MS-Access. Nor can I access code in an existing form when open in creation. In Excell Macro have error on ligne that work when run on XP. For example Code: If Not Intersect(ActiveSheet.Range("A18:A41"), ActiveCell) Is Nothing Then Thanks for any suggestions Fran?ois

...examples? I've read the Package description... but there are not really good descriptions/examples. I know the following parameters/commands: #Connect to the active Workbook excel <- comGetObject("Excel.Application") #Set the active sheet sheet <- comGetProperty(excel,"ActiveSheet") #Set a specific sheet sheet <- comGetProperty(excel,"Worksheets","WorksheetXY") #Create a new Worksheet comInvoke(comGetProperty(excel,"Worksheets"),"Add") #Define a range in a defined sheet range1 <- comGetProperty(sheet,"Range",&qu...

...The following example is working fine: #------------------------------------------------------------------- library(RDCOMClient) xlLocationAsObject <-2 xlXYScatterSmoothNoMarkers <- 73 ex <- COMCreate("Excel.Application") wb <- ex[["Workbooks"]]$Add() sh <- ex$ActiveSheet() ex[["Visible"]] <- TRUE r <- sh$Range("A1:D1") r[["Value"]] <- c(1:4) ch <- ex$Charts() ch$Add() ac <- ex$ActiveChart() ac[["ChartType"]] <- xlXYScatterSmoothNoMarkers ac$Location(Where=xlLocationAsObject, Name="Tabelle1") ac$S...

...CommandString") Workbooks.Open Filename:="c:\windows\temp\resultat.csv" Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Windows("smalltest.xls").Activate Range("A3").Select ActiveSheet.Paste End Sub Function works (i.e. does complete without error message) when c:\windows\temp\resultat.csv exists (created using above smalltest function in R environment) but hangs when operated from excel (file not found). My machine is a 4 Gb Memory - PIV 3.2Ghz with disk mirroring runnin...

Hi, How can I attach chart/plot to a excel file? I would like to create a plot in R eg. plot(1) and save it into a Excel file, eg. test.xls in a same working directory. Regrads, -J

Hello together, i have a list of numbers, like this one A B C 1.1 1.2 1.3 i export this list into an excel file and want now color these numbers according to her value. I want every color under 1,25 is red, and every color over 1,25 is green. How can i do this with "RDCOMClient" ? I know how to colour a complete row, like this task: U3R <- sh$Range(zellen_blue) U3RF <-

Dear all, I would like to import a range of cells (e.g. F10:K234) from an Excel worksheet to R. I have looked for documentation on RODBC and RDCOMClient but I was not able to find enough information to solve my problem and all the examples I have seen were dealing with an entire worksheet, not a range of cells. Thanks, Jean-Noel Jean-Noel Candau INRA - Unit? de Recherches Foresti?res

Hi all, Is there a way to draw 3D pie with R (like excel does)? I know how to do it in 2D, just by using pie(something)... I know it isn't the best way to represent data, but people are sometimes more interested by the look and feel than by the accuracy of the results... If there is no way, have you another suggestion ? (i already use dotchart instead of pie) Thks to all of

Hans-Peter and other R developers, How are you? Have you made any progess with embedding Url's in Excel? Well, I have been busy thinking of more things for you to do;) My colleagues in the lab are not R literate, and some are barely computer literate, so I give them everything in Excel workbooks. I have gradually evolved a system such that these workbooks have become compendia of my