RE: Excel & MS Query caused compile errors ... My data is in an Excel file called ... The format of it were distorted after copying and pasting. ...Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query... (microsoft.public.excel.programming)
Re: Mail Merge for non-Gregorian Calendars ... Which means that you either have to fix those dates in Word using another method, or fix them in the data source.... As you say, in this caae, using Excel to format the dates as Hijri makes no difference to the date that Word sees, even with a DDE connection. ... The field feature in Word has an option that supports non-Gregorian calendars, like the Saka Era calendar and the Hijri/Lunar calendar. ... (microsoft.public.word.mailmerge.fields)
RE: Export to Excel: 2nd, 3rd, etc excel files not opening up ... early bindings to use the built-in functions of excel to format my excel ... Well based on your suggestions my understanding is that in my early binding...Set xlApp = New Excel.Application ... I also was able to format that same exported excel ... (microsoft.public.access.formscoding)
RE: Pop Up Excel Calendar VBA CODE ... Corrected line for UK date format but probably messes up systems ... And I was creating some really good applications with excel.... But when I started programming using the Activex Calendar control... If there is a date in the active cell then the calendar will pop up ... (microsoft.public.excel.programming)
RE: Get parameter dates in heading ... And if it goes in Excel where do you put it. ...Const conLightGray As Long = 12632256 ...Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references... (microsoft.public.access.externaldata)
