Answer Questions

• Michelle S Count and display in cell

  Ok I have an Excel workbook that contains a schedule (51 worksheets total). Each cell has intials in it and if that person has taken a day off the cell is highlighted a certain color (yellow, rose, or red). What I need to do is have something that goes through and counts what intials have what color and then display in a cell the number. So: If cell contains "initials" and cell color is "color" Then count and display in "cell" Example: If cell contains "JJ" and cell color is "Yellow" Then count and display in "A2" I know it is possible to do this but I'm not sure how. Tiger I tried the code and all I get is a run-time er ...Show All

• Pooja Katiyar How do connect an Excel file from Remote Server

  Hi All, I am creating one application in Excel. In this application One Excel file will be in the Remote Server.When one persone get log in then the file immediately has to link with this excel file which in the remote server. Now my question is - Is it possible to connect the Excel file from the remote server using VBA. Please any one help me to do this. i am searching this in lots of way. if not is it possible Access file. Kalidas hello, Had the same problem and i mapped a new drive and use the chdrive function good luck hey, i didn't taught it was so complicated, and i'm too a newbie to VBA programming. But i'll do my best. So, first of all i guess that ...Show All

• JMBC Updating text in a text box on an Excel Graph

  I am automating a spreadsheet, designed by someone else, which has 18 graphs on a worksheet. Most of these graphs have a text box on them which indicates the week commencing that the graph refers to. The text box appears to be a shape object on the chart. I want to loop through each chart on the sheet, then loop through each shape on the chart, and change the text if the shape is a text box. Can anyone put me on the right track, I did try using the macro recorder to get me started but this code does not work in my VBA module. Many thanks Duck Thing, just the job Then this should do it: Option Explicit Private Sub Workbook_Open() Dim ws As Worksheet, o As Char ...Show All

• Igzz how to add CheckBox?

  i want to add several CheckBox into Form. the numbers of checkBox is depends on the user input. i had already data on the ExcelSheet that represent one table of selected database. then the entire column name will be listed in userForm. i need to know how to add checkBox into the userForm (in uncertain range, depends on how many column in the table) and of course including the label beside it. Hi, Here's some additional info from our support engineer. I'd already escalated this before Derek replied, so I figured I'd post their response in case there is extra info that might be of help. Let’s talk about following issue. Base on my understanding, our buddy wants to add controls dynamically on Us ...Show All

• EnigMa_AnGeL Extra tip

  I had just discovered a critical prerequisite for when you want to create an ActiveX control using ATL that you want to use in an Excel document: The ActiveX control MUST support Connection Points. If you do not add Connection Points to your object, you may receive the following useless and misleading error message: "Object library invalid or contains references to object definitions that could not be found". Steps to reproduce: 1) Use Visual Studio 2005 to create a new ATL project. Use all default settings. 2) Use "Add Class" from the project's context menu to add an ATL Control to the project. Use all defaults for the object. 3) Compile the project. 4) Open Excel. 5) Add a Command Button. 6) Add the ActiveX c ...Show All

• yoshikatsu CRM 3.0 doesn’t save my settings

  Hi, I’m having another problem in CRM 3.0. When I change any setting in the CRM system, everytime that I clicked in the OK button it should save my new settings and that’s not happening. How can I solve this Thanks, Hi I found the solution in the microsoft dynamics troubleshooting guide www.microsoft.com/dynamics/crm/using/troubleshooting/ It worked for me. Per our support engineer: Would you please tell us where you changed the settings that were not saved There are lots of settings in CRM 3.0. So we need to know where is the problem. J Please provide the steps to reproduce this issue and I'll make sure that it gets back to the engineer. ...Show All

• Cesar Francisco Edit DataLabel in Excel charts

  Hi all, I wonder have I can add a Legend Key(a line that goes from the point in the chart to DataLabel text) to the DataLabel in the code below I would also like to now how I can change the position of the DataLabel. With ActiveChart     With .SeriesCollection(1).Points(2)         .HasDataLabel = True         .DataLabel.Text = "Saturday"     End With End With Thankful for tips. Jonas Thanks Andy! Maybe this example of leader lines will help. http://www.andypope.info/ngs/ng14.htm To change the position of the data label you can use code like this. ' using built in label positions. Positions available depend on chart ...Show All

• --Alan--- Excel user form to select a favourite file

  I am trying to use a custom form for the first time and would like to select an excel file from the normal "File _ Save As..." window and once selected, save the path and filename into cell A1 of a spreadsheet called "My Toobar.xls". This will then allow the user to open this "favourite" file very quickly. Can anyone help me get this Windows "File _ Save As..." browser window embedded into a UserForm. Many thanks, Paul Hi, You can use the build in SaveAs dialog in Excel. The example below show you how to show the dialog filtered, it only shows files of type *.fil and the file the user selected is stored in variable vSelectedFile.     ...Show All

• Adrian West Automatic Macros

  I have already been using the "Sub Auto_Open" and "_Close", some of the helpful codes that automatically runs when the sheet is opened or close. Can anyone suggest me a real time update or macro that runs when a certain sheet is selected I want my macro to update the pivot table automatically when I enter or encode a value at the source range of the pivot table... THanks for all the help... music_at_ulan wrote: I have already been using the "Sub Auto_Open" and "_Close", some of the helpful codes that automatically runs when the sheet is opened or close. Can anyone suggest me a real time update or macro that runs when a certain sheet is selected ...Show All

• billb59 Adding a command button to the toolbar or menu bar in Excel?

  Hi I'm wondering is it possible to add a command button to the toolbar or menu bar in Excel using VBA I came across an excel file before in work that somebody had setup this way but not sure how to go about it! I basically have two buttons that I would like to have added to the toolbar or menu to make the sheet tidier and enable the user to see all the data without having to move the buttons etc. http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_buttons.jpg Any ideas folks Thanks, Scott Thanks Jon, forgot about the customize menu item! The final task i'm trying to get sorted is to import data from a different Excel file and insert it into the main sheet in my Exce ...Show All

• vbjunkie vlookup

  Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata If the file is open then you do not need the full path as the name only the filename and extension. MyPath = "C:\Documents and Settings\np22331\Desktop\Consolidated list of supplier.xls" MyFile = "Consolidated list of supplier.xls" Set LookupValue = Sheet3.Range("O2") Set TableArray = Workbooks(MyFile).Worksheets("Sheet3").Range("$A$5:$F$281") hello,   the whole code that i ...Show All

• -D- Sorry it may not have been clear as>>

  I have created a program that I plan on disbursing to other people, on this program, I have added a simple form with support info. I would like the text to be a hyperlink for a website and email. Any suggestions thanks   Hi, Are you are talking of VBA Try putting the line>> System.Diagnostics.Process.Start (" http://www.epc16.com ") in the click event of a button instead and name it>>  "Visit website." or something.   Regards, S_DS   So in that case would: Shell "explorer mailto:john@yahoo.com", vbNormalFocus be a valid line for it to automatically open an email similar to writing html Thank you soooo much for finally giving me something t ...Show All

• Ryan Slimmon Creating and Editing Microsoft Access Reports using Visual Basic

  Hi, I am trying to create a report based on the selection from a combo box in a form. i have some data, of which one of the fields is callled "projects". the combo box selects selects a project, and i would like to be able to open a report showing the data that belongs to the specific project on the click of a button. i have written the code below, but the report is only ever blank. i can create a query based on the same sql statement, and it works fine. can someone help Dim thisDB As Database, strSql, projID As String, rpt As Report Set thisDB = CurrentDb projID = existingProjSelector.Value strSql = "SELECT * FROM MyTable WHERE ([PROJECT ID]='" & projID & "') ...Show All

• daniele bonini Using VBA to send an MSN instant message

  Hi I have written some VBA in Access 2003 to bring up an MSN instant message window and send a message to that contact. The only problem is, I seem to be able to do everything except actually send the message! I think this feature may have been removed from the API. Anyway, here's the code: - Private Sub SendIM()      Dim header As String Dim objmsgr As MessengerAPI.Messenger Dim contact As MessengerAPI.IMessengerContact Set objmsgr = New MessengerAPI.Messenger Set contact = objmsgr.GetContact(" anyone@hotmail.com ", objmsgr.MyServiceId) objmsgr.InstantMessage contact [this is where I'm stuck] End Sub Apparently SendKeys has to be used because there is no code to actually put a message into the window and click ...Show All

• Tony Antonucci external file data

  HI! I have got 2 excel files Eg Data.xls and report.xls I need to generate report from data.xls into Report.xls is it possible that I run a macro look into "A CLOSED EXCEL FILE" and feed that data into another excel file. Hope I am clear Cheers Nrupesh Hey man, These two articles should help.... http://support.microsoft.com/kb/257819/EN-US/ http://www.microsoft.com/technet/scriptcenter/resources/officetips/jun05/tips0607.mspx ...Show All