Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code to add code
Howdy.
I am trying to use write some code to write code for variable storage. The below code is from Chip's site, with slight changes. When writing, i get the following message, highlighting the first "DataArray" Compile Error Expected: end of statement. Any help would be greatly appreciated. Cheers. Russell. ----------------------------------------- Sub AddDCAProc() Dim NewCodeModule As CodeModule Dim LineNum As Long Set NewCodeModule = ThisWorkbook.VBProject.VBComponents ("Data").CodeModule With VBCodeMod LineNum = .CountOfLines + 1 .InsertLines LineNum, _ "Sub DCAStorage()" & Chr(13) & _ " dca1 = Sheets("DataArray").Range("A59").Value " & Chr (13) & _ " dca2 = Sheets("DataArray").Range("A60").Value " & Chr (13) & _ " dca3 = Sheets("DataArray").Range("A61").Value " & Chr (13) & _ "End Sub" End With End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code to add code
If you want to use double quotes within a string, you need to use two sets
of double quotes for every double quote you want in the string change " dca1 = Sheets("DataArray").Range("A59").Value " to " dca1 = Sheets(""DataArray"").Range(""A59"").Value " Testing from the immediate window: ? " dca1 = Sheets(""DataArray"").Range(""A59"").Value " dca1 = Sheets("DataArray").Range("A59").Value -- Regards, Tom Ogilvy "russell" wrote in message ... Howdy. I am trying to use write some code to write code for variable storage. The below code is from Chip's site, with slight changes. When writing, i get the following message, highlighting the first "DataArray" Compile Error Expected: end of statement. Any help would be greatly appreciated. Cheers. Russell. ----------------------------------------- Sub AddDCAProc() Dim NewCodeModule As CodeModule Dim LineNum As Long Set NewCodeModule = ThisWorkbook.VBProject.VBComponents ("Data").CodeModule With VBCodeMod LineNum = .CountOfLines + 1 .InsertLines LineNum, _ "Sub DCAStorage()" & Chr(13) & _ " dca1 = Sheets("DataArray").Range("A59").Value " & Chr (13) & _ " dca2 = Sheets("DataArray").Range("A60").Value " & Chr (13) & _ " dca3 = Sheets("DataArray").Range("A61").Value " & Chr (13) & _ "End Sub" End With End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code to add code
Thanks for your help Tom.
Cheers. Russ. "Tom Ogilvy" wrote in message ... If you want to use double quotes within a string, you need to use two sets of double quotes for every double quote you want in the string change " dca1 = Sheets("DataArray").Range("A59").Value " to " dca1 = Sheets(""DataArray"").Range(""A59"").Value " Testing from the immediate window: ? " dca1 = Sheets(""DataArray"").Range(""A59"").Value " dca1 = Sheets("DataArray").Range("A59").Value -- Regards, Tom Ogilvy "russell" wrote in message ... Howdy. I am trying to use write some code to write code for variable storage. The below code is from Chip's site, with slight changes. When writing, i get the following message, highlighting the first "DataArray" Compile Error Expected: end of statement. Any help would be greatly appreciated. Cheers. Russell. ----------------------------------------- Sub AddDCAProc() Dim NewCodeModule As CodeModule Dim LineNum As Long Set NewCodeModule = ThisWorkbook.VBProject.VBComponents ("Data").CodeModule With VBCodeMod LineNum = .CountOfLines + 1 .InsertLines LineNum, _ "Sub DCAStorage()" & Chr(13) & _ " dca1 = Sheets("DataArray").Range("A59").Value " & Chr (13) & _ " dca2 = Sheets("DataArray").Range("A60").Value " & Chr (13) & _ " dca3 = Sheets("DataArray").Range("A61").Value " & Chr (13) & _ "End Sub" End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |