Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New to programming Excel from VB 2005
I just started a new project and with lots of reading on internet and some
help from another newsgroup I feel I'm getting the hang of this. My question is I can not find a list of all the commands available within VB for working with excel spreadsheets. I'm using Excel 2007 and am able to take text files and parse fields to put into individual cells. I am able to save the spreadsheet and even send the spreadsheet via outlook. Is there any books or link to webpage to help with the available commands? THanks, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New to programming Excel from VB 2005
Look in the Object browser in the VBE. Use the Help file in the VBE.
-- Regards, Tom Ogilvy "Stephen Plotnick" wrote: I just started a new project and with lots of reading on internet and some help from another newsgroup I feel I'm getting the hang of this. My question is I can not find a list of all the commands available within VB for working with excel spreadsheets. I'm using Excel 2007 and am able to take text files and parse fields to put into individual cells. I am able to save the spreadsheet and even send the spreadsheet via outlook. Is there any books or link to webpage to help with the available commands? THanks, Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New to programming Excel from VB 2005
Tom,
THanks; now here is my frustration. When I started VB programming (COBOL programmer forever) the help via google and books made the learning curve easier. Now I'm trying to create a spreadsheet from VB and simple things are impossible to find. I did find the object you were talking about and can see all these functions but how am I to know what does what? Here is some code I wrote to build cells in a spreadsheet. THe building of the cells works but the hide row does not. I'm probably not even using the correct command to hide a row. In my program I want to hide row 4. osheet.Range(MultiLetter & "4").Value = Mid(line, dept_no * 32 + 1, 32).ToString osheet.Range(MultiLetter & "4").EntireColumn.AutoFit() osheet.Range(MultiLetter & "5").Value = Mid(line, dept_no * 32 + 1, 32).ToString osheet.Range(MultiLetter & "5").EntireColumn.AutoFit() End If Next dept_no osheet.Rows.Hidden(4) = True Sorry about the frustration. I just wish there was a book that had all the command and what they did along with their syntax. So you don't think I'm nuts in the example above.. THere is data I build in row three that I'm going to want to use the new conditional formatting. I want an up arrow or down arrow in row three based on the value going down looking at row 5. I'm cheating by putting the value in row 5 also in row 4 and subsequently hiding row 4. This way the user will only see on arrow in row three and the one in 4 is hidden (that shows the other arrow). Thanks, Steve "Tom Ogilvy" wrote in message ... Look in the Object browser in the VBE. Use the Help file in the VBE. -- Regards, Tom Ogilvy "Stephen Plotnick" wrote: I just started a new project and with lots of reading on internet and some help from another newsgroup I feel I'm getting the hang of this. My question is I can not find a list of all the commands available within VB for working with excel spreadsheets. I'm using Excel 2007 and am able to take text files and parse fields to put into individual cells. I am able to save the spreadsheet and even send the spreadsheet via outlook. Is there any books or link to webpage to help with the available commands? THanks, Steve |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
New to programming Excel from VB 2005
I figured this with dumb luck:)
osheet.Rows("1").RowHeight = 40 osheet.Columns("A").ColumnWidth = 26 osheet.Range("B:ALN").ColumnWidth = 15 osheet.Range("A1:AZ1").WrapText = True osheet.Rows("4").Hidden = True Now to figure the conditional formatting in Excel 2007 "Stephen Plotnick" wrote in message ... Tom, THanks; now here is my frustration. When I started VB programming (COBOL programmer forever) the help via google and books made the learning curve easier. Now I'm trying to create a spreadsheet from VB and simple things are impossible to find. I did find the object you were talking about and can see all these functions but how am I to know what does what? Here is some code I wrote to build cells in a spreadsheet. THe building of the cells works but the hide row does not. I'm probably not even using the correct command to hide a row. In my program I want to hide row 4. osheet.Range(MultiLetter & "4").Value = Mid(line, dept_no * 32 + 1, 32).ToString osheet.Range(MultiLetter & "4").EntireColumn.AutoFit() osheet.Range(MultiLetter & "5").Value = Mid(line, dept_no * 32 + 1, 32).ToString osheet.Range(MultiLetter & "5").EntireColumn.AutoFit() End If Next dept_no osheet.Rows.Hidden(4) = True Sorry about the frustration. I just wish there was a book that had all the command and what they did along with their syntax. So you don't think I'm nuts in the example above.. THere is data I build in row three that I'm going to want to use the new conditional formatting. I want an up arrow or down arrow in row three based on the value going down looking at row 5. I'm cheating by putting the value in row 5 also in row 4 and subsequently hiding row 4. This way the user will only see on arrow in row three and the one in 4 is hidden (that shows the other arrow). Thanks, Steve "Tom Ogilvy" wrote in message ... Look in the Object browser in the VBE. Use the Help file in the VBE. -- Regards, Tom Ogilvy "Stephen Plotnick" wrote: I just started a new project and with lots of reading on internet and some help from another newsgroup I feel I'm getting the hang of this. My question is I can not find a list of all the commands available within VB for working with excel spreadsheets. I'm using Excel 2007 and am able to take text files and parse fields to put into individual cells. I am able to save the spreadsheet and even send the spreadsheet via outlook. Is there any books or link to webpage to help with the available commands? THanks, Steve |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
New to programming Excel from VB 2005
in case you are unaware, there is a macro recorder in Excel. You can turn
it on and apply the conditional formatting manually, then turn off the macro recorder and look at what is recorded. It will usually do Range("A1").Select Selection.Validata . . . because that is what you physically did. You can eliminate the paired select selection. Just use it to get some insight into the syntax and objects/arguments involved. -- Regards, Tom Ogilvy "Stephen Plotnick" wrote in message ... I figured this with dumb luck:) osheet.Rows("1").RowHeight = 40 osheet.Columns("A").ColumnWidth = 26 osheet.Range("B:ALN").ColumnWidth = 15 osheet.Range("A1:AZ1").WrapText = True osheet.Rows("4").Hidden = True Now to figure the conditional formatting in Excel 2007 "Stephen Plotnick" wrote in message ... Tom, THanks; now here is my frustration. When I started VB programming (COBOL programmer forever) the help via google and books made the learning curve easier. Now I'm trying to create a spreadsheet from VB and simple things are impossible to find. I did find the object you were talking about and can see all these functions but how am I to know what does what? Here is some code I wrote to build cells in a spreadsheet. THe building of the cells works but the hide row does not. I'm probably not even using the correct command to hide a row. In my program I want to hide row 4. osheet.Range(MultiLetter & "4").Value = Mid(line, dept_no * 32 + 1, 32).ToString osheet.Range(MultiLetter & "4").EntireColumn.AutoFit() osheet.Range(MultiLetter & "5").Value = Mid(line, dept_no * 32 + 1, 32).ToString osheet.Range(MultiLetter & "5").EntireColumn.AutoFit() End If Next dept_no osheet.Rows.Hidden(4) = True Sorry about the frustration. I just wish there was a book that had all the command and what they did along with their syntax. So you don't think I'm nuts in the example above.. THere is data I build in row three that I'm going to want to use the new conditional formatting. I want an up arrow or down arrow in row three based on the value going down looking at row 5. I'm cheating by putting the value in row 5 also in row 4 and subsequently hiding row 4. This way the user will only see on arrow in row three and the one in 4 is hidden (that shows the other arrow). Thanks, Steve "Tom Ogilvy" wrote in message ... Look in the Object browser in the VBE. Use the Help file in the VBE. -- Regards, Tom Ogilvy "Stephen Plotnick" wrote: I just started a new project and with lots of reading on internet and some help from another newsgroup I feel I'm getting the hang of this. My question is I can not find a list of all the commands available within VB for working with excel spreadsheets. I'm using Excel 2007 and am able to take text files and parse fields to put into individual cells. I am able to save the spreadsheet and even send the spreadsheet via outlook. Is there any books or link to webpage to help with the available commands? THanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31 | Excel Worksheet Functions | |||
Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possible? | Excel Worksheet Functions | |||
Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in e | Excel Discussion (Misc queries) | |||
VB 2005 and Excel | Excel Programming | |||
chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005 | Excel Worksheet Functions |