Answer Questions

• Steve Mayhugh .lookin =

  Is it possible to execute a LookIn command but not to include specific folders in the named path I have a number of folders in a folder called 'Team Leaders' but within each of these folders I have 2 folders called 'Authorised' and 'Rejections'. I do not want the search to look in these folders and just skip them. Code for the routine is attached Sub ExGratia_Check() Dim objFSO As Object Dim objFile As Object Dim intFileCount As Integer Dim strFolder As String Range("A5").Select Application.StatusBar = "Counting Files" Set objFSO = CreateObject("Scripting.FileSystemObject") With Application.FileSearch .NewSearch . LookIn = "S:\Policy\CD Manual Letters_Service\Forms\Pilot Ex-Gratia\Team Lea ...Show All

• JFoushee [Access 2003] [ADO Excel Connection] Run-time error '-2147217865 (80040e37)'

  Error clause when retrieve data from Excel file using ADO, error message as the following: ShtName = "'AA BB CCCCC DD(EEEEEEE$00+) (0)" strSQL = "Select * From [" & ShtName & "$A7:BB65536]" Run-time error '-2147217865 (80040e37)': The Microsoft Jet database engine could not find the object 'AA BB CCCCC DD[EEEEEEE$00+] [0]$A7:BB65536'. Make sure the object exists and that you spell its name and the path name correctly. Thank you very much! Hi Perry, It's your range thats causing the error, if you run with only the sheet name then it's fine but when you add the range A7:BB65536 the error is thrown. Have you tried using a named range instead ...Show All

• Dinakar.babu Log in with Active X

  Hi! Every night I have a macro that is supposed to run and open and login to a program (the Bloomberg professional) and download some data. My problem is the log in process from my macro. Now I use SendKeys but that seems VERY unreliable. Does anyone have any links with code that shows how to use some better techniques e.g. Active X to log in to a program Any help appreciated! Thanks a lot in advance! AndersBank, Logging into any program is conceptually the same process, enter a user name and password, lookup the user name in an identity store (database) and check the passwords match, and set a flag that says the user is authentic. However, behind the scenes each application/web site cou ...Show All

• Haziman Text wraping on edit box of dialogsheet

  I have created a form with an editbox and what I need to do is to make the text content wrap rather than continuing on to the right past the size of the box. Any ideas welcome please. With DialogSheets("FormAdd") .EditBoxes("Edit Box 144").Text = "" .Show End With rabbitoh, What software you developing in DialogSheet and EditBoxes sound like older versions of forms and text boxes, this might explain the 256 character limit. MS Excel 2002 VBA but I am using form and code module templates that I created a few version back, which still work just fine. Rather then reinventing the wheel each time I just recycle and modify to suit but o ...Show All

• Lalitk How to get the filename into the "Insert Picture" dialogue?

  Our company written a marco that used in MS Words and it as same as the "insert -> picture -> from file" dialogue, but we want to enhance it to get the filename automatically when the dialogue box is opened to instead of blank. Do you mean I cannot not get the filename if I use the dialogs that provided by MS as below code With Dialogs(wdDialogInsertPicture) .Show End With You can use the .Name property I think to get the name. But you wanted to set the name before showing, which you can not do. Hi, Looks like the built-in dialog does not take a initial filename argument. You can change the folder using, Options.DefaultFilePath(wdPicturesPath) = "C:\" Instead try the Filed ...Show All

• Unforg3ttable Text wraping on edit box of dialogsheet

  I have created a form with an editbox and what I need to do is to make the text content wrap rather than continuing on to the right past the size of the box. Any ideas welcome please. With DialogSheets("FormAdd") .EditBoxes("Edit Box 144").Text = "" .Show End With I have updated the way I do my forms. Instead of right-clicking on a worksheet tab and inserting a dialog sheet, I have inserted a userform in the visual basic editor window. As I type, the code you provided progressivly increases the size of the data field way in advance of my typing. Running the form without the code and ensuring MultiLine is set to true, enables the form to work ...Show All

• Raulsassaa Size Form to fit user resolution

  I have several multi-user Access applications. After much time-consuming research I have not been able to find anything that works on this question: How can I get my forms to automatically fit the USER'S screen with their set resolution with the OnLoad event of a form I have already tried me.height, me.width with no success. Anyone have any other suggestions Any help would be greatly appreciated. Thanks! Blue are VB Keywords and purple is identifiers. You can setup custom formatting in the IDE through the options menu to make you coding easier to follow and find issues for yourself! In the Sample above in VB.Net it would be unneccesary to rename anything.... However it will not work ins ...Show All

• udayan converting text to Hours Minutes and Seconds

  have a database which has three fields for Hours Minutes and seconds these are just numbers and have no relation to time. I need in a report,code that will convert the numbers to time and add the seconds to minutes and add the minutes to hours. Thanks Bartley Hi, You could use the date method DateAdd to add the seconds, minutes and hours. Public Sub ReturnDate()     Dim myDate As Date     myDate = CDate("00:00:00")         'add seconds     myDate = DateAdd("s", "65", myDate)     'add minutes     myDate = DateAdd("n", "125", myDate)     'add hours     myDate = DateAdd("h", "5", myDa ...Show All

• Jonas.S Creating AxInterop.AcroPDFLib.dll and Interop.AcroPDFLib.dll in VS 2003

  I'm wanting to create these DLLs. They don't come with Windows or Adobe Acrobat V7. References to them in C# code I'm maintaining exist, but the original author is not available and I'm not sure how they were created. Any help would be much appreciated. Thanks! ...Show All

• WidgetWorking VBA function having it's name's case changed in excel

  I am just starting with VBA / excel though I am a moderately competent programmer. I created a function B4FirstBlank() (written exactly like that) that looks at a Range reference and finds the value of the cell before the first blank cell. It works fine but whenever I type it into excel it is rewritten as b4fIRSTbLANK() which doesn't do much for me in terms of readability. I get other strange rewriting of functions too, any guidance on how to sort this out much appreciated. Andrew Thanks for the reply. I've had a good look and it is definitely called B4FirstBlank(). For some reason it is now appearing as b4firstblank(). I have also looked for multiple definitions and while I do have the same function amo ...Show All

• MRandall Local Folders - Inbox

  In Outlook Express 6, under Local Folders - Inbox, I have a (1) and there is no actual mail. In other words if beside Inbox it says (5), there really are only four emails and the (1) always stays beside inbox. Was hoping maybe someone could help. anyone ...Show All

• MShetty WER Code Signing Requirement

  Hello, Recently I discovered that the Microsoft Windows Error Reporting program is open to all developers free of charge if two requirements (more or less were met). The first requirement was that upon signing up for the program, the candidate company must send a unique Verisign certificate that represent's their organization's identity (about $100). The second requirement was that the application to be submitted to Microsoft for WER must also have a Microsoft Authenticode signature also provided by Verisign (for about $400). My only question that I have is whether I could go with some other signing authority who participates in the Authenticode code signing program (Thawte for instance), and still participate in the Windows Error ...Show All

• Wendell Wang List box issues

  I am creating a word template that contains two list boxes. The user will be able to select multiple items and send the items to the other list box via a command button. However when ever I save and close the document and open the same document, the contents of the second list box are empty I have attached the code I have for you all to look at. Thanks for the help in advance. Private Sub Document_New() PopulateListBox 'Clears out second list for a new document lstbox2.Clear End Sub Private Sub Document_Open() PopulateListBoxes End Sub Private Sub cmdMovetoRight_Click() Dim i As Integer If lstbox1.ListIndex = -1 Then Exit Sub For i = lstbox1.ListCount - 1 To 0 Step -1 If lstb ...Show All

• steveareno Is there a today() function in VBA?

  I've been trying to get the current date a few ways in VBA. I tried using the today() function in a spreadsheet and getting the data from that cell and also calling it explicitly in a vba script and have had no success. any help will be appreciated. Offcourse. (^_^ ) The only difference between Now and the one's i've suggested is that Now contains both the current date and time while Date and Time are seperate commands for the date and time. (^_^ ) It all depends on which information you need. You can use "MyDate = Date()" for that. (^_^ ) If you want to the current time, use "MyTime = Time()" i use now() to enter the date for new entries into my ...Show All

• TrevorHughes excel load event

  Hi, Currently I have created a macro which I should place inside the load event How do I find the load event of an excel template. This is to place a code in there so it runs when excel template loads. Thanks Define a sub Workbook_Open in the ThisWorkbook object of the document, place your code in there, and you should be all set. ...Show All