Answer Questions

• mblack inputbox method and ranges

  I am having trouble assigning the range given by an inputbox method to the variable targetcells, and subsequently selecting targetcells. any help would be most appreciated. Dim i As Integer Dim CopyCells As Range 'the cells into which links will be copied Dim TargetCells As Range 'the cells that copycells will be linked to Dim CopyAddress As Variant 'the address of the copycells Dim TargetAddress As Variant 'the address of the targetaddress ...Show All

• LloydM_APFM Changing chart series

  Hi Can anyone point me in the right direction on working with Charts in Excel. I have a workbork with five pages, each page has many charts, each chart has three series. I had specified a range well beyond the data, the blank cells did not appear on the charts, and the charts updated automatically as data was entered. The data page has changed, now I need to set the ranges each time. I know the final column for each series, how can I scrol ...Show All

• Hiten macro that hides rows - excel

  hi, i was wondering if there was a way to write a macro that will automatically hide a row based on a value in a cell in excel say, if the sum of a selection of cells = 0, i want to hide the row all together. is there a way to do that thanks. anthony Yeah this works pretty good! Problem is, i've got 1500 cells to write this macro for individually...you mentioned a way to chose them in a range of cells, how can ...Show All

• Derek Slinn updating an Visio OLE object on an Access report

  I have a linked Visio document OLE object on an Access report. Depending on the result set for the report, I need to change the linked visio document. I cannot find a way to do this on a report. It works on a form because the .Enabled and .Locked properties are available. Anyone had any luck doing this. Here is the code I am trying in VBA on the report: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) With Me.visF ...Show All

• wildlife VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All

• MNMamun Dialog Box, Searching for keywords in an Excel Workbook

  Good morning, afternoon, evening... I need to create a little macro in an Excel workbook, that woud allow the user to type a keyword or a phrase, and check if this phrase or keyword exists within the same workbook or another (I guess I would just need to change the path of the work book). The rule is the following: - If the text entered is in one of the cells of Column A of each worksheet, the returned result will be the content of each ...Show All

• PC-Gram day of the week

  hello all. my macro must include some logic that's based on whether certain events happened on the weekend or a week day. does anyone know the code to tell what day a certain date falls on it certainly does. thankyou The WeekDay function might help http://msdn.microsoft.com/library/en-us/dnvbadev/html/pullingpiecesapart.asp ...Show All

• guenthk Multithreading, Callback & VBA in PowerPoint 2003

  Hi, I'm currently trying to get to work a VBA application which uses an external DLL (which I program parallely). The DLL starts a separate worker thread which calls a previously registered VBA callback function. This works perfectly (e.g. I can do a MsgBox "I was called with argument " + str(arg)) but if I try to change a slide in my slide show, PowerPoint says that "Hyperlink ^0" doesn't exist and crashes. At the end of ...Show All

• AppzGuy Ms Access form creation

  Hi I have problem with form creation wizard. During first step wizard doesn't show the fields of my tables. Only primary key field is shown. And in next steps I face such alerts as "Invalid use of null" What I should do Yes I use it. In short I follow all instructions in the way to create form or report. But...no result Are you using look-up fields (Fields with a table or query feeding a pull-down list). This could ...Show All

• Damir Bersinic VBA in EXCEL - Connect to SQL Server

  I am a new programmer try to write some VBA codes in excel to get data out from the Sql server database. When I try to compile the codes, it said "compile error: user defined typed not defined" for the following sentences Dim dbsCurrent As Database Dim qdfPassThrough As QueryDef Dim qdfLocal As QueryDef Dim rstTopFive As Recordset Dim strMessage As String What I need to define for Database,recordset or QueryDef Please help! ...Show All

• E A S VS Code Editor

  Hi, I've seen numerous examples people implementing the Windows Forms Designer in their application, I was wondering if it's possible to do something similar with the Code editor too   I would like to offer my users the capability of writing their own plug-ins.  It is ok if VS has to be installed on their PCs. I've asked this question many times before, and just had a lot of deer in headlights faces stare back at me. Cheers. Paul ...Show All

• help_m_with_extern_linkage Access 2003 - programming arrow keys with combo box

  On an Access form, I'd like the up/down arrow keys to be used to navigate the values in a combobox, similar to how a listbox behaves. So, for example, if there are five values starting with "M", the user could enter "M" and then press the down arrow key to get to the other entries. Since it's a combo box, the user could also just continue to enter text. I assume I need to program the keypress event to do this, but I'm not ...Show All

• ggovind Copy Outlook email into Excel

  I receive an email every day whose contents I have to put into Excel. I'd like to write a macro in Excel that will copy the contents of the email and paste it into Excel. The contents are always structured the same - two columns and 13 rows, and the subject is always the same. I can get the Excel part, but I'm struggling with the Outlook part. thanks! per the support engineer: Please clarify the requirem ...Show All

• tamlin2 Excel Unprotect WorkSheet problem in Excel 97

  Hi all, I have a problem when i open the Excel workbook from another Excel workbook to reset a value in a specific cell. Both workbooks are the same. When Workbook is opened manually, it will run the code in workbook_open, which is unprotect the workbook and worksheet to assign a value in a specific cell, it can be run properly in both Excel 97 and 2003. However, when i using workbook1 (running code) to open workbook2, workbook2 cannot unp ...Show All

• wrecklesswun Working with Outlook Public Folders from Excel

  Can anyone point me in the direction of some example code Instead of sending an e-mail which has a large attachment to a distribution group, I want to post it to an existing Outlook folder. The code will be placed inside an excel workbook, which creates the attachment file. Thanks in advance thanks for the additional info... I've forwarded it to the engineer! -brenda (ISV Buddy Team) Hi Brenda ...Show All