Answer Questions

• Phillip Jackson Display Metadata of files

  Hi all, i am using the following code to export to a file a folder details - files and sub-folders in a specific folder. i want to export the Metadata of the files as well. any idea how i do it oFile.title, or oFile.comments does not work... thanks, S Dim oFileSystem As Object Dim oFolder As Object Dim oFile As Object Dim oFiles As Object Dim oSubFolder As Object Dim oSubFolders As Object Dim oO ...Show All

• ajay_verma VBA source code

  Hi all. I need to do my final year project in Excel using VBA. The project is in such a way that i can generate curves using Excel. I have been searching for the samples source code for cosine, sine and FFT source code, but to no avail. Could anyne please advise me on this I am a newbie to VBA, so i'm rather lost now.. Thanks in advance. in the VBA Help Dim MyAngle, MySecant MyAngle = 1.3    ' ...Show All

• keyoke VBA Out Too?

  Started by ncaplan at 03-14-2005 11:02 AM. Topic has 1 replies. VBA Out Too I just read an article stating the elimination of VB. I'm totally shocked! http://news.zdnet.co.uk/software/developer/0,39020387,39190953,00.htm   What about VBA, is that going to end as well We have and still are developing so many automated processes using VBA, it would have a major impact on our company. ...Show All

• dsula Report generated via a query

  I have a report that shows all locations and there associated assets however i would like to limit the locations. currently i return everything but this is a waste of paper and sometimes only 1 or 2 locations will be needed is there a way to control the report so only the slected locations are displayed I think this is relatively easy to accomplish but i cant seem to figure it out fully any help would be much appreciated thanks (again). ...Show All

• Paul from Iowa Format Comparison

  My goal is to distguish which format to use if the format is equal to "000.00.00.00" then or is the format equal to "00.00.00" then Public Sub DistinguishFormat() Dim Subject As String If Mid(Subject,4,1)="." Then ... Else ... End If End Sub ...Show All

• James Spink working with 2 workbooks

  hello, i have a master excel file with a command button which when pressed opens a SLAVE excel file, reads one of the cell entries, closes the excel file, comes back to the master file and writes the data into one of the cells in that. now the reading of the slave file should be done in the background and should not be visible to the user of the master file who clicks the command button. this is what i wrote ... have already done quite a lo ...Show All

• OrenSasson ned help with excel

  i'm trying to insert an image on the top of the excel the code im using is Sub ClearAndClose() Excel.Application.Quit End Sub Sub PrintPriceListF() ' ' PrintPriceListF Macro ' Comments ' ' Keyboard Shortcut: Ctrl+f ' 'Move the header to right Range("A1").Select Selection.Cut Range("e1").Select ActiveSheet.Paste Range("A2").Select Selection.Cut 'Delete the ol ...Show All

• Jan van der Peet enabling controls at runtime

  i have a userform with two listboxes, and six optionbuttions. the options buttons are split into 3 pairs of two. at the outset only the first pair of option buttons is enabled. the following code tests to see if more than one selection is made in a listbox, and if it is, then enables a relevant pair of option buttons. Private Sub Listbox1_change() 'check to see if there is a multiple selection Dim i As Integer Dim Acount As Integer Acou ...Show All

• Dan Mikkelsen Exceptional kind of Error - Menus deleted at statup of Access 2000...?

  Hi, I had been working with databases from many years...Recently I had encountered an exceptional/unusual kind of error in Microsoft Access 2000. I had developed some applications on Microsoft Access 97 and Access 2000, which also has custom based menus and toolbars etc. These applications have been running successfully on many machines, but recently I got problems on few pc's...When I open my Access applications/Databases on machines (whic ...Show All

• BrunoR2 What is an error 400?

  Useless errors are rather ... well ... useless. Hi Tony, What application (and version) were you using when you got the error thanks, -brenda (ISV Buddy Team) Brenda I believe the error would be generated if Tony is trying to show the form, which has been displayed) modally . Or Could be the Bad Server error one gets while connecting. Regards Shasur ...Show All

• Spykeyz Problem in CDO.iMailBox

  I am working on code sending email in MS-Access using Exchange Server 2000. I grab the code from  http://msdn.microsoft.com/library/default.asp url=/library/en-us/e2k3/e2k3/_cdo_imailbox_interface.asp . Now my problem is casting CDO.Person to CDo.iMailbox     iPer.DataSource.Open "LDAP://" & Info.UserName '==> This line give me iPer obj     Set iMbx = iPer '==>This line is not able to conver ...Show All

• Greg Brady excel vba

  Dim rng As Range Dim rngSelect As Range Set rngSelect = Selection For Each rng In rngSelect.Rows Selection.Offset(2, 0) = rng.EntireRow.Select 'need to add each modified range to selection Next rng I want all modified ranges to be selected in code I need like all rows in different locations selected so I can cut and copy to clipboard It's probably easier and quicker to work with range objects, not the ...Show All

• sylmil Importing data from Microsoft Access to Microsoft Word

  To anyone who can help Is there anyway that data from an access/sql query can be imported straight into Microsoft Word without losing the formating that has been set up in access. Many Thanks to anyone who can help Mark Hi Mark, The support engineer needs to know if you are planning for any reporting like mail merge, or simple data copy and paste And, he also needs to know which version of Office you are using. -bre ...Show All

• Jolo Problem solved!

  After working fine for days the following standard code to send an Outlook email is not running: Dim objOL As New Outlook.Application Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) I get now the following error message: Run-time error Automation error The specified module could not be found When I click on Debug the line code in yellow is: Set objO ...Show All

• Eric Flores provider cannot found with MDAC 2.8 Win XP sp2

  Hi, We have an app that is part VC 6 and part VB6/VBA, we have a fair number of installed on WIN XP SP2 with XP SP2 We've just installed on a brand spanking New Sony Vaio laptop with a preinstalled XP Pro sp2 image, and get a "provider cannot be found" msesage when the vb element of our app connects to a data source via ADO. The VC6 element of the app has at this point already successfully connected via ODBC. Problem occurs w ...Show All