Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal vba - interaction xls/xlt
Following code does not work when I put it in my PERSONAL folder in VBA It works when I see both source and destination xls/xlt in the VB explorer. What should I change about the code to make it work? '============================================= Sub ExportSORTSTARS() Dim originWorkbook As Workbook Set originWorkbook = ActiveWorkbook Dim newSheet As Worksheet sheetS("SS").Activate Cells(1, 1).Activate Cells.Select Selection.Copy Windows("SS0.xlt").Activate Set newSheet = Worksheets.Add newSheet.Name = "SS" Cells(1, 1).Select Selection.PasteSpecial Paste:=xlPasteValues Operation:=xlNone newSheet.Visible = False Application.CutCopyMode = False originWorkbook.Activate End Su -- Zur ----------------------------------------------------------------------- Zurn's Profile: http://www.excelforum.com/member.php...fo&userid=1464 View this thread: http://www.excelforum.com/showthread.php?threadid=52916 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal vba - interaction xls/xlt
Anyone an idea? It works when opening the template first, and opening it's VB environment. Then opening the xls workbook and it's VBA environment Only then I get access to the code of both xls and xlt through the sam window. And only then it works. In other cases, the object SS.xlt is not found. Any help on this topic? Thank yo -- Zur ----------------------------------------------------------------------- Zurn's Profile: http://www.excelforum.com/member.php...fo&userid=1464 View this thread: http://www.excelforum.com/showthread.php?threadid=52916 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal vba - interaction xls/xlt
Maybe suggestions off ways to search how to solve it... anything? -- Zurn ------------------------------------------------------------------------ Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645 View this thread: http://www.excelforum.com/showthread...hreadid=529164 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
strange vba interaction | Excel Programming | |||
check box interaction | Excel Programming | |||
Interaction between worksheets | Excel Programming | |||
Web interaction | Excel Programming | |||
excel/asp interaction - HELP! | Excel Programming |