Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WORKDAY #NAME? Problem - tried the toolpack already
Hello!
I´m trying to programatically edit an excel worksheet with VBA, ill copy part of my code below , maybe its better to understand: Set x = CreateObject("Excel.Application") If fs.FileExists(strCaminho & "Indices.xls") Then x.Workbooks.Open (strCaminho & "Indices.xls") x.ActiveSheet.Rows("1:1").Delete x.ActiveSheet.Range("2:2").Delete x.ActiveSheet.Range("A1:AA65536").Value = x.ActiveSheet.Range("A1:AA65536").Value Kill strCaminho & "IndicesNegoc.xls" 'deleta o arquivo antigo existente x.ActiveWorkbook.SaveAs fileName:=strCaminho & "IndicesNegoc.xls", FileFormat:=xlNormal x.Worksheets("MOEDAS UTILIZADAS PARA REVERSÃO").Activate 'muda de worksheet x.ActiveSheet.Rows("3:3").Delete 'deleção de linhas desnecessárias x.ActiveSheet.Range("4:4").Delete x.ActiveSheet.Range("1:1").Delete x.ActiveSheet.Range("1:1").Delete x.ActiveSheet.Range("A1:AA65536").Value = x.ActiveSheet.Range("A1:AA65536").Value Kill strCaminho & "IndicesReversao.xls" x.ActiveWorkbook.SaveAs fileName:=strCaminho& "IndicesReversao.xls",FileFormat:=xlNormal x.Quit Set x = Nothing As you can see, im just deleting the first lines, then i copy the values from Indices.xls (not the formula) and paste it, then I save as IndicesNegoc.xls. And i do the same thing with another worksheet saving as Indices Reversao.xls. When i open IndicesNegoc.xls all the cells that used workday function appears as #NAME? and ive already checked if the add-in is installed. Its ok. What should I do to solve this problem? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add no. of days to a workday to get new workday? | Excel Worksheet Functions | |||
DATE WORKDAY PROBLEM | Excel Discussion (Misc queries) | |||
Workday Problem | Excel Discussion (Misc queries) | |||
Problem using analysis toolpack when automatically running excel | Excel Programming | |||
Problem using analysis toolpack when automating EXCEL | Excel Programming |