excel-2003
Picture automation in excel
I have 2 sheets in excel. in 1st sheet I make 3 pictures i.e (Oval or square ) and rename those with A, B, C and also put in different colum A, B, C in different cell. and 开发者_如何学Gomake it list[详细]
2023-03-16 21:48 分类:问答Excel to Datatable gives error "Too many fields"
I am filling data from a sheet of Excel book to datatable . The excel sheet contains about 160 columns. It gives error message \"to many fields\"[详细]
2023-03-15 18:29 分类:问答How do I make some text bold, using Visual Basic in Excel to create a Word document?
I\'ve seen this, but it doesn\'t work for me; I don\'t get where to change insertafter to typetext. What should I change in the following to make part of the text bold?[详细]
2023-03-14 13:32 分类:问答Problem with macro when converting csv to xls
I am getting a problem on my project.There is one xls file with a macro that create a chart and the cell type of that xls file is \'text\'.I have to make multiple duplicate copies of that file with th[详细]
2023-03-13 03:24 分类:问答Setting language, text direction and alignment in word document created by visual basic in excel
I\'ve made an excel visual basic script that takes data from an excel sheet, and produces a paragraph in a word sheet for each row. The default language for the document is Hebrew, with text aligned r[详细]
2023-03-13 02:38 分类:问答Multivariate linear regression in excel 2003
Is this feature in excel 2003? I can\'t seem to find any kind of data analysis through the menu at all. Perhaps I need to make a chart first?[详细]
2023-03-12 09:31 分类:问答Excel - Using an Address to copy over an entire column including blank spaces
What I\'m trying to do is scan over every header on one sheet (the headers are located in \"1:1\"), find a header called \"Dealer Code\", then copy that entire column to another sheet.[详细]
2023-03-11 10:05 分类:问答How to get screen X and Y of an Excel 2003 cell in C#
How can I find the absolute position of a cell in Excel 2003 (e.g. relative to the screen[s]) when writing a C# Excel 2003 Add-in.[详细]
2023-03-11 03:27 分类:问答Application.Printers returns error message "Object does not support this property or method"
Do I need to select a specific Reference to make printers p开发者_开发问答roperty visible? Which one?The Excel VBA Worksheet object has a PrintPreview method.You can select your printer from the Previ[详细]
2023-03-03 02:36 分类:问答Password-protect the macros of a second workbook from a first using VBA
I have a workbook, which creates a second workbook (using ThisWorkbook.SaveCopyAs) to present the data nicely to users.It relies on macros for part of the processing.[详细]
2023-03-01 03:02 分类:问答