Question about Operating Systems

1 Answer

VBA Macro i m looking for code to find Calculate the Width of the Columns Calculate the Height of the Table in a non uniform table using VBA ..PLS HELP

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Brigadier General:

    An expert that has over 10,000 points.

  • Master
  • 10,406 Answers

Nice try! Find an upper-class student to give you one-on-one tutoring with your homework assignment.

Posted on Dec 03, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Merge rows and columns of table in vb


Under edit there should just be a button called merge cells. Columns you want to merge by holding shift and clicking on them. Then click merge cells.

May 03, 2011 | Operating Systems

1 Answer

I can not draw a table in microsoft word


hi ermelitacapa,

To create a table in Microsoft Word please do the following:

1. Go to the Table menu and select 'Insert Table'. The Insert Table window will open.
2. Select the number of rows and columns you want in your table.
3. Select the column width (up to 22 inches) or choose 'Auto' to have the column with adjust automatically, making the table extend across the width of the page.
4. Select the AutoFormat button to select one of Word's pre-formatted table styles. The Table AutoFormat window opens.
5. Click one of the styles in the Formats box in the upper left side of the window.
6. Preview each format, after selecting it, in the Preview box in the upper right side of window.
7. To customize a pre-selected format, select or de-select the borders, shading, font, color, heading rows, first column, last row and last column boxes.
8. Select AutoFit, and Word will automatically fit the table to your page.
(To manually change the width of a table or column after you have created it, use the mouse to place the pointer over the vertical line you want to move. When the pointer turns into a double-headed arrow, drag the line to the position you want it in the table.)'

I hope this helps!

** If you find this information helpful please leave feedback to help us help others **

Feb 24, 2011 | Microsoft Windows 7 Home Premium 64BIT...

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Operating Systems

1 Answer

How to create VBA programme in excel?


Use macro editor. And modify it.
You need to create a new Excel Based VB Program, then install Visual Basic 6.0 or higher version and use the MS Excel ActiveX control.

Aug 10, 2010 | Operating Systems

1 Answer

Access 2000 forms and combo boxes


I could be getting confused with programming Languages, but here is a shot in the dark. You may have to code or give argument to each combo box that <when selected if (other box) is blank then update (other box)> or somthing similiar, MAYBE?????

Apr 03, 2009 | Microsoft Access 2000

1 Answer

I want a c program for reading a image


FILE *fp = fopen( "file.bmp", "rb" ); This opens the file
unsigned char buff[10];
size_t n = fread( buff, sizeof(buff[0]), sizeof(buff), fp ); This reads 10 bytes from the file.

10 is obviously just an example, but you can read the documentation to find out how big a BMPHEADER structure is, and read that number of bytes instead. Having got that, you get vital information such as
- the width and height of the image
- the number of bits in each pixel
- whether there is a colour table in the file.

You then skip the optional colour table (say by using fseek), then you can start looping reading image data, based on your knowledge of the width, height and bpp of the image format.

Mar 17, 2009 | Operating Systems

2 Answers

Setting Datagrid runtime in Visual Basic


I think you are missing this at the end:

DataGrid1.DataBind()

Sep 06, 2008 | Operating Systems

1 Answer

Want to write a code in VBA for a Chart prepared in Excel


Dear Customer,

you have not define your all details,

Plz give all details than & only than some can help you ,

so,Please mention all required details

THNX

May 08, 2008 | Operating Systems

1 Answer

Flex Grid


The most common multidimensional array, the two dimensional array table, is best presented to your users in row and column format. The grid control offers a convenient way for you to display table data to your users. The users can navigate the table's values using scrollbars. Therefore, the grid control does not have to be as large as the table, because the grid control automatically displays scrollbars.
To add the flex grid control to your toolbox, select project and components. Add the flex grid control:
lesson97-1.jpg Once it is added, you will see the yellow flex grid control in your toolbox:
lesson97-2.jpg When you place the grid control on your form, you will have to resize it before the control takes on a tabular appearance. As you expand the size of the control, it does not look to much like a table. The problem is that the table's default number of rows and columns are two. To fix this problem, you must configure the rows and columns in the properties window:
lesson97-3.jpg lesson97-4.jpg lesson97-5.jpg The grid control supports fixed rows and columns. These refer to rows and columns in a grid control that do not scroll when the user clicks the scrollbars. The fixed rows and columns provides labels that describe the data. The fixed rows and columns are often called row and column headers.
lesson97-6.jpg When working with the grid control, much code is needed to provide the grid with functionality. Call statements are used to break the code required by the grid control into smaller, more manageable procedures. This is referred to as modular programming (which refers to the practice of placing code with a single purpose in a general subroutine procedure and then calling the code from a second procedure.)
Here is the code for the form load procedure (this example is based on the computer disk example used in the last lesson)


Private Sub Form_Load()
Call SizeCells
Call CenterCells



grdGrid.Row = 0
grdGrid.Col = 1
grdGrid.Text = "Single Sided; Low Density "
grdGrid.Col = 2
grdGrid.Text = "Double Sided; Low Density"
grdGrid.Col = 3
grdGrid.Text = "Singled Sided; High Density"
grdGrid.Col = 4
grdGrid.Text = "Double Sided; High Density"

grdGrid.Row = 1
grdGrid.Col = 0
grdGrid.Text = "3 1/2 inch"
grdGrid.Col = 1
grdGrid.Text = "$2.30"
grdGrid.Col = 2
grdGrid.Text = "$2.75"
grdGrid.Col = 3
grdGrid.Text = "$3.20"
grdGrid.Col = 4
grdGrid.Text = "$3.50"



grdGrid.Row = 2
grdGrid.Col = 0
grdGrid.Text = "5 1/4 inch"
grdGrid.Col = 1
grdGrid.Text = "$1.75"
grdGrid.Col = 2
grdGrid.Text = "$2.10"
grdGrid.Col = 3
grdGrid.Text = "$2.60"
grdGrid.Col = 4
grdGrid.Text = "$2.95"

End Sub
Notice how the form load procedure is used to populate the cells in the grid control. To control cell size and cell alignment, two smaller procedures are created and each procedure is called by the form load procedure.


Private Sub SizeCells()
Dim intColumn As Integer

grdGrid.ColWidth(0) = 1100

For intColumn = 1 To 4
grdGrid.ColWidth(intColumn) = 2200
Next intColumn

End Sub

Private Sub CenterCells()
Dim intColumn As Integer

For intColumn = 1 To 4
grdGrid.ColAlignment(intColumn) = flexAlignCenterCenter
Next intColumn

End Sub

Notice that the size and alignment procedures are only applied to columns 1 through 4. Column 0, which is a fixed column reserved for labels, is not formatted using either of the above two procedures.
Here is the final result:
lesson97-7.jpg

Mar 26, 2008 | Operating Systems

2 Answers

How to hide sheet tabs in MS Excel


Do you mean by Visual Basic / Macro?

if so this is what you need:

ActiveWindow.DisplayWorkbookTabs = False

Mar 07, 2008 | Operating Systems

Not finding what you are looking for?
Operating Systems Logo

Related Topics:

122 people viewed this question

Ask a Question

Usually answered in minutes!

Top Operating Systems Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Prashant  Sharma
Prashant Sharma

Level 3 Expert

1127 Answers

Are you an Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...