Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Im trying to work on a new worksheet using workbooks.add, but when i
try to put some data on this new workbook, the data fills the original workbook, where my macro is. this is my macro: cenario = Sheet1.Range("cdimportacao") Workbooks.Add Dim hoje As Date Dim sfilename As String sfilename = Format(Now(), "ddmmyyyy") hoje = Format(Now(), "dd/mm/yyyy") data = "DATA" Sheet1.Cells(1, 1).Value = data Sheet1.Cells(1, 2).Value = hoje Sheet1.Range("A1:E2545").Value = cenario ActiveWorkbook.SaveAs Filename:="c:\place\" & sfilename, _ FileFormat:=xlText, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Can someone help me with this? Appears to be basic. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Link one worksheet in a workbook to another worksheet in same work | Excel Discussion (Misc queries) | |||
Retrieving data into worksheet from another worksheet in same work | Excel Discussion (Misc queries) | |||
How does a module of VB work in a Worksheet? | Excel Worksheet Functions | |||
Copying the active worksheet to another worksheet in the same work | Excel Worksheet Functions | |||
I need a work around for a protected worksheet | Setting up and Configuration of Excel |