Answer Questions

• krhoover Web Page Components

  Hello All, I am a complete beginner with Web Pages!. With the help of various forums I have managed to get to a web page via a Sign In page (that is I can get my VBA code to fill in the username and password). The next page I get has some options on it. (Normally if I was to "hover" over them they get underlined, are these links . If so how do I click the appropriate one If I ever get past this the next page will have a combobox where I will have to make a choice again. How will I make that choice . (Ther will be about 5 or six drop down choices. Basically I would like to know how to reference these "controls ". I am assuming this is what they are . As I mentioned earlier, I am a complete novice to this a ...Show All

• chakravarthy_b When sending a worksheet to the USB port …

  Hey, When sending a worksheet to the USB port … (memory stick). How do I detect if the memory device is not in the USB port …. and how do I handle the error if its not there Best Regards Cathrine Hey Derek Thanks for your reply. I have a workbook that I want to save to a memory stick. How can I write the code so it will detect witch drive letter the USB have Cath Dim fsoObj As Scripting.FileSystemObject Set fsoObj = New Scripting.FileSystemObject With fsoObj If .Drives("E:").IsReady = True Then 'code goes here End If End With Set fsoObj = Nothing ...Show All

• SQLHelpFTS Getting Access Data into Excel

  I need to get a large number of Access 2000 Recordsets into Excel 2000 for evaluation. I have no problem setting up the connection and getting the entire table into Excel for testing by modifying the examples at   http://support.microsoft.com/kb/247412/EN-US/ using either the QueryTable or ADO code outlined there. The tables I need to access have over 200,000 records so getting the entire table is not an answer in this case. The SQL statement is complicated and changes 125 times in the course of the whole procedure. Sample SQL generated by Microsoft Query by building the Query in design mode and then changing to View SQL (The Access Query SQL is slightly different it the query is built in Access): ...Show All

• DigitalPenguin .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

• nithinraj Possible to add multiple (300+) hyperlinks that run the same VBA code?

  The code that I want to run is very simple -- it takes the text of the cell containing the hyperlink and copies it a specific range. It also selects the specific range. For example -- a list of 300+ symbols in one column: Not really sure I understand what you want, the symbol, will it be text and even if not where do you want it copied to . Wherever you want it copied to, that location can be found by "selection.address" Please give more info ChasAA I want the text copied to the target cell (the cell jumped to once the hyperlink is clicked). The code needs to be the same for all hyperlinks on the page so that it copies the text from the current cell to the target cell. I added ...Show All

• Ranal To find Whether a value in a cell is pasted?

  Hi, Actually if we copy - paste a value of one cell into another, the format of the copied cell, like font,color, size etc, overrides that of the cell in which the value is pasted. Is there any way where we can prevent this. Thanks Is there any way of achieving this through VBA code i think there are a no. of ways of doing it... 1) right-click on the cell that you wanna paste, then select "Paste Special", and in the Paste Special dialogue box select "Values" or "Formula". 2) when you select the cell you wanna copy, copy from the Formular bar (ie. highlight the text in the formula bar then CTRL+C) instead of hitting CTRL+C ...Show All

• Saitham8 formula for this problem

  Here is the problem I have. I have samples being collected and sent to a lab. When I receive the lab results it gets logged on this sheet in columns D and E. The formulas in columns F and H must use the results from the D and E entry for all the samples collected until it encounters another lab result, then the formula must use these results in D and E until yet another lab result is input. How do I get the formulas to see the new input and automatically change the formula for me. formula : D E F 0.43 2.00 c18*d17*8.34 0 0 c19*d17*8.34 0 0 c20*d17*8.34 .51 1.11 c21*d20*8.34 0 0 c22*d20*8.34 Dont know if this is enough to go by, but ...Show All

• Gravy VBA Editor fails to start from Access 2003

  I get the following dialog when I try to start the VBA editor from within Access 2003. *********** Microsoft Visual C++ Runtime Library Runtime Error! Program: C:\Program Files\Microsoft Office\OFFICE11\MSACCWSS.EXE This application has requested the Runtime to terminate if in an unusual way. Please contact the applications support team for more information. ***************** This modal dialog pops up in front of the editor and when I press the OK button, which is the only one available, it shuts down that instance of Access along with the editor window. This dialog pops up whenever I try to start the VBA editor from within Access 2003. It does not matter if it is a new file I just created or an existing mdb file th ...Show All

• Will.Rogers Open PDF file

  Hi everybody, I'm creating a program in MS. Access but I just want to ask:, how to open *.pdf(extension) file in visual basic access (vba) thanks in advance. :-) Hi sweet-66, It's great that you got your answer but for the sake of others reading this thread in the future can you post the solution or a link. Depends what you want to do - if you want to be able to save a PDF into your database (or any other document type) then i have code that allows you to do that and then double clicking on it will open it up in the appropriate program. Is this what you want RHhs. Hi sweet66 - sorry but ive been away for a while - yes that was exactly what my code ...Show All

• Bluehunter 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 How many different colours will you have and ho ...Show All

• erikj personalized command bar disappears when minimizing excel

  This is my first message in this forum, so please be patient. I have programmed a makro for an excel workbook. one part of this makro creates a command bar. when the excel workbook is started i make all the regular command bars disappear, only mine is left. Works wonderful. Well, i have put a button into my command bar to minimize the application. However, when i restore the workbook again from the windows taskbar, my commandbar is vanished, and the normal command bars (like standard and format and also the formula bar) are suddenly there. The command bar is still there but not enabled/visible. The problem exists on many computers and also on differnet excel versions i tried (97, 2000, xp) I do not know if that is a bug or not. Now is it p ...Show All

• Curt Zarger [Excel] How to convert Excel to jpg, gif image?

  How to convert MS Excel to jpg or gif and paste/insert to MS Word thank you very much     Yes, i need to do this programatically. thanks Not my cleanest code... the only way I can see doing this is by "tricking" Excel into thinking the copied range is a chart. The attached is a quick & dirty run to see if this would work or not. It does. When I use this in a real application I'll create a new workbook, perform the chart, etc., in that work and then delete everything. The current application I'm working on could use variants of this code 100+ times per session, so I'm very worried about the source workbook(s) becoming corrupted due to t ...Show All

• LouArnold how to convert excel to tiff file using api or vba

  hi friend, i have a requirement where i have to convert excel file to tiff file by programming. since there are about 100 files to do with , it is hard to go with manual process. pls help on this. any suggestion will be appreciated. thanks stefen ...Show All

• Jim Perry Count the number of records that show up in a Access form

  I need to count the number of records that show up in a Microsoft access form. The forms record source is defined dynamically in vb using a select query. I need to know how to count the number of records that show up in a form. Open the results of your select query as a recordset. Then move to the last record in the recordset, and get the RecordSet.RecordCount property. Does this work How do I do that ...Show All

• Adam Oxford List Box Search

  I am developing in Access 2003. I have a form that has a record set associated to it. It allows you to edit one record at a time through text boxes for each field. To this form I added a list box (lstInstruments) from a query of the same table that the form is linked to. In the AfterUpdate event of the list box I entered the following code. Set rs = Me.Recordset.Clone rs.FindFirst "[InstrumentID] = " & Str(Me![lstInstruments]) Me.Bookmark = rs.Bookmark This allows me to have a list of all of the records on the form, select one in the list box and then the detail part of the form updates to the correct record. Now I need to do the reverse. When I click on the record navigator buttons and move from reco ...Show All