Answer Questions

• minkee.s saving data in a userform without saving the workbook

  Hi, I have an excel VBA project which interacts with the user entirely through userforms (built it in excel rather than VB since I want to access underlying data from excel sheets for the calculations). How can I export all the data and calculations on a particular userform into a txt file or other file There may be multiple userforms open, and saving will just save one of them, loading will load the data from file, initialise a new userform and load the data into it, all without upsetting the other userforms or the underlying workbook. I'm thinking that I can use one sheet of the workbook as a scratchpad, so when the macro is called, write the userform data onto that sheet, then save the sheet only as a text file by Sheet2.Sa ...Show All

• Sam Lester - MSFT Defining objects within a cell range

  Hey,     I've been working on writing a code where the user inputs different names into a worksheet, then the code selects these files and defines it: Sheets("Variable Output Order"). Select FieldStr1 = [A2:A21]   Then, I use that defined object to use in a recordset: Set rs1 = db.OpenRecordset(" SELECT " & FieldStr1 _         & " FROM R00" & TestNumber & "DATA " _         & "ORDER BY RECORD_NUMBER")   Also,the TestNumber is defined also, but that doesn't seem to be the problem. Any thoughts Hi FieldStr1 will return an array of type variant (unless you have defined i ...Show All

• like_antani VBA to VB/Java

  I have created a form (using Word as a shell) that applies logic rules and outputs a series of text strings in a field of the same form. I no longer use the Word functionality in any fashion other than as a shell for VBA (i.e. a way to launch and run the VBA form. Is there any compilers/applications that will convert VBA to another language such as VB or Java or any common language that I can run stand alone I found one for Excel, but not Word. I am hoping someone has a suggestion. John I don't know of such a utility, but in general VBA code can usually be moved to VB.NET without much trouble. Since you say you're not using any Word functionality, you don't even have any interop issues to worry ...Show All

• Catalin Zima ScreenUpdating

  hi all, I am nearly done writing an application (in vb.net) that uses interop for Microsoft Powerpoint, and the problem is that when I write to the slide, I don't want the user to see those updates. I know in vba, one would write 'Application.ScreenUpdating = false', however screenupdating is not found under the application. I have searched fruitlessly through other articles for a simple solution, but they seem to be geared towards excel. Can anyone help me Thanks in advance   Myron Hi, Why not hide powerpoint until your code has finished and then display it. Would minimising the Active Window achieve what you want to do for the time being Application. ActiveWindow .WindowState ...Show All

• darynk21 How to detect if Access is opened exclusively

  Hello, I've just adjusted my Access database to use local tables to do data entry then send that data to the shared data tables (split DB - GUI/Data mdb's) and as a result will need to ensure that users have got a local PC copy of the GUI database file. So testing for the GUI file being opened exclusively via cmd /excl command line would be good (or via the Access DB options ->Advanced -> exclusive ). I can't seem to find the VBA method for testing if the CurrentDB is opened in Exclusive mode. Does anyone know the answer ...Show All

• sagittarian calling a function and passing the name of the recordset

  Does anyone know the best way to pass the name of a recordset to a function sample dim myrecordset as adobd.recordset Dim myvalue as string Call myfunction(mrecordset, myvalue) _________________________________________________ function myfunction(myrecordset, myvalue) etc... end function thx This actually worked thanks.. You just did by passing the entire records set Otherwise pass a string Public MyFunction(byval Name as string, Byval MyValue as string) end Function MyFunction("MyRecordSet", MyValue) ...Show All

• Ecrofirt Tables in Word 2003

  Hi, I am trying to solve a problem with tables that is causing some concern for my wife. She has various tables she uses in her job as a teacher and regularly has to update them. the problem is she would like the table to stay the same size and the text to change size if it cannot fit in a cell. In other words she may be changing the text in a cell on 12 point and it currently expands the cell to accomodate any additions, she wants the text to automatically reduce its point size to fit the cell. Is this possible anyone out ther done this or something similar Thanks Regards RobEJ53 Hi, There is a public newsgroup dedicated to Word tables that might be more helpful to you: http: ...Show All

• Paul Tew Trying to write a VERY VERY simple routine BUT GOT STUCK !! ::) = Brain Ache !!

  Hi, I'm affraid I bit off more than I can chew and It's a while since I programmed. 1/ The routine is set in an open Excel worksheet which has 5 fields/columns per row 2/ The routine reads 1 row at a time, splits 1 field, does some ifs and appends 6 new fields per row 3/ I'm stuck with the Loop 4/ I'm stuck with the IFs especially bracketing 5/ I'm stuck with the output writes I'd really appreciate if you could just wiiiizzz through it and ellimate the mistakes. For you 5 mins for me 5 days. Here it is .... Sub TeamPerformance01() ' TeamPerformance01 ' Name Fields in open worksheet ActiveWorkbook.Names.Add Name:="Date", RefersToR1C1:="=Sheet1!C1" Columns("A:A").Select ActiveWorkbook.Names.Add Name:="T ...Show All

• Scotty12105 How do I...

  select the next row down at the end of my macro. I tried to do this recording a macro using the down arrow and it did not work. Any help is greatly appreciated. You need to provide more information ie how is your macro moving from cell to cell. At the end of your macro, where is the active cell etc. Selection.Offset(1,0).select could be one method but need to know more ChasAA I am copying a range of cells within a column and pasting them into a new worksheet as a row using Paste Special, Transpose I highlight the range (can't do this in the macro since it varies), and then run the macro which copies the selection and then switches worksheets and does ...Show All

• csname Sum of hours using select statement & VBA

  Hi - ok here is my question: I have an activity recording form that records hours logged against a company. I have added a field called 'sumactivityhours' to the table and the form.  what i would like to do is when a user selects a company from the drop down list (thanks derek and duck thing for your fantastic help with that problem) it automatically populates the 'sumactivityhours' field with the total number of hours worked thus far with that company  so that the user can see the total hours and then writes that information into the 'sumactivityhours' field in the table. as i gradually begin to learn a little more about VBA im guessing that i should create an on exit event on the companyname combo box that re ...Show All

• GraemeH Office Communicator 2005 sign-in name, auto populate after install somehow?

  Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install.. Basically every user has the same format.. first.lastname@domain for the login. I'd prefer to find a way to have this info auto entered after the install when it first tries to open. I'll be using communicator as a "broadcast" method.. and alot of users probably wont take the time to enter their info when I have it set to auto start/connect on windows start up. Thanks I've found a way to do this.. Basically when the client gets installed.. I have a batch file.. It pulls the email address from AD and then uses that to create the registry entry for the sign in ...Show All

• S10n Trouble while dealing with Share Point Object Model

  Hello everybody, I am getting some trouble around SharePoint Object model. I was intended to write a console or windows application that will connect two SharePoint site (One is SharePoint 2003 and the other is SharePoint 2007) and will move/copy documents from one to another. I have tried to connect to the SharePoint 2007 first and it was connecting fine. (I was running my application into the same machine where the SharePoint 2007 is installed). The application was retrieving the Document from the SharePoint 2007 as expected but the trouble raised when it was trying to connect with the SharePoint 2003. The error was The Web Application at could not be found. Verify that you have typed the URL correctly. If the URL sh ...Show All

• Thomas Pittman whats wrong with this code?

  Sub HideGroupBox() If Cells(1, "I").Value = "2" Then DayBox.Visible = False Else DayBox.Visible = True End If End Sub im trying to hide a group box with options if the value in L1 = 2 but in not sure what im doing wrong Hello, What magical is saying, is to put the statement Msgbox(cells(1,"l").value) before each line that states DayBox.visible=.. This will display the value of cells(1,"l") before executing the next command. As for me I still dont understand the GroupBox, do you mean Frame, are you using Excel, a Userform or embedding this in the sheet. Or maybe post more of your code, it will help understand the code a bit more. Chas ...Show All

• jchau Adding data to the same workbook

  I have a macro that copy the content of the current worksheet to another "target" workbook. This works fine: n1 = ActiveWorkbook.Name Selection.Copy Workbooks.Add Template:="MyTemplate.xlt" Workbooks(Workbooks.Count).Activate n2 = ActiveWorkbook.Name ActiveSheet.Paste ' return to the source workbook Workbooks(n1).Activate Now, I would like to modify this macro so that if the user execute it more times from the same workbook, the content of the current sheet must be appended at the end of the same target n2 workbook, "collecting" all the contents. The questions I can't answer are.. 1 - How can I be sure to create the new target workbook only the first time the macro executes 2- How can I append the content at the en ...Show All

• VidyaSagarCh How to allow cookies for Windows Live ID

  Help me! I am having the exact same problem..and error message. Anyone know how to fix this Diana I haven't had a problem logging into Hotmail until today. But I've followed ALL the instructions for allowing cookies & still can't log into MSN, Live ID or Hotmail. I receive the error message further below. Do I have to download something from Live ID Thanks! Cookies must be allowed Your browser is currently set to block cookies. Your browser must allow cookies before you can use Windows Live ID. hi, i resently had some problems with spyware trojans and i erased alot of infected componants on my pc with avg, including over 100 cookies. and today my w ...Show All