Search results for query: *

Declare Function apiCopyFile Lib "KERNEL32" Alias "CopyFileA" _ (ByVal lpExistingFileName As String, _ ByVal lpNewFileName As String, _ ByVal bFailIfExists As Long) As Long I get the following compile error: The code in this project...

Hi, Can any one help me with the following: Declare Function apiCopyFile Lib "KERNEL32" Alias "CopyFileA" _ (ByVal lpExistingFileName As String, _ ByVal lpNewFileName As String, _ ByVal bFailIfExists As Long) As Long I get the following...

Hi, I am trying to create a function in Word 365 to add a horizontal bar above a letter. I used a record macro, and succeeded for the first attempt only. The first time I use it, it works: ¯A (it does'nt appear correctly here, but in word, the bar is just above the letter "A") But if I try it...

Hi, I am using Access vba to export all slides from a PowerPoint presentation, as jpg files, into a folder. It does not work, because I am obviously making many syntax mistakes: Private Sub pptTest() Dim objPresentation As PowerPoint.Presentation Dim objSlide As PowerPoint.Slide Dim...

I created a vba (macro) in powerpoint 365. I would like that vba to be launched by and add-in button on the ribbon. How would I do that? Thank you.

Hi, I am using the following vba access to transfer pictures from access to powerpoint: While Not rs.EOF MySource = rs![Photo_Path_And_Name].Value MyDestination = "D:\Photos\DataMiningResult\Slide" & Trim(Str(I)) & ".jpg" FileCopy MySource, MyDestination...

Hi, Is there a way to download meteomedia today's data into excel by the click of a button? Thank you.

Hi, I am using Windows 7 and Office 2007 : I am instantiating excel from vba access, do some formatting on the excel spreadsheet, than close it. I realise that the excel instance is still appearing in the task manager. Here is the code...

Hi, does anyone know how to transfer bulk emails from videotron webmail into outlook 2007? Thank you.

Hi, I am trying to copy some photos from a folder, into a new PowerPoint presentation 2007, using Access 2007 VBA. I have two problems: 1- I must open manually a new PowerPoint presentation, before running the Access VBA, otherwise I get the error message: “-2147188160 Shape (unknown...

Hi, a friend is on Windows 10, and he is interested in Kensington K64406US Pro Fit USB/PS2 Washable Keyboard with Anti-microbial Protection, White. I couldn't find any internet site to inform us of it's compatible with windows 10. Any clues? Thank you.

Hi, After a few problems with the new ZoneAlarm installation, I had to format my drive, and re-instal windows 7 (64). Unfortunately, when I look for updates, it keeps looking for hours, without stopping, without any error message, and without finding anything to update (see attached). Before the...

Hi, my friend is running Windows 7 Home Premium Service Pack 1, 64-bit. When he goes on the internet, he has an error message appearing with the following URL...

Hi, I am using a Gateway P-173XL FX laptop (vista 64). I had to format my hard drive two weeks ago (see my previous thread : "PXE-E53 No boot filename received"). I deleted the patitions, and formatted the hard drive (an SSD) with one partition only. All worked fine, and the windows updates were...

Hi, I am running Windows Vista 64 bits on a Gateway Laptop. After re-installing the OS, drivers, etc, I get the following error at startup: PXE-E53 No boot filename received I have the latest drivers, all well installed, and the system works fine though, except for an important problem: my...

Hi, I read many posts on the internet concerning the VBA error mentionned in the subject line, but none gave me a solution. I am producing a series of graphs in excel, from access (office 2007). The first time, it runs perfectly well. When I run it a second time, I get: "The remote server...

Hi, I am trying to remove a data field from an excel pivot table, using access vba: Here is the part of the code concerned: Select Case NbOfCols Case 3 .ActiveSheet.PivotTables(MyTabID).PivotFields("Col3").Orientation =...

Hi, I am trying to rename a chart in excel 2007 from vba access 2007, then access that chart from access 2007. This is the code I am using: With xlObj .ActiveChart.Parent.Name = MyReportNo

Hi, I am creating a chart in excel 2007 from access VBA 2007. It works very well. The only point I could not program, is changing the Axis Title color. I tried: With appExcel .ActiveChart.Axes(xlCategory).AxisTitle.Font.Color = vbCyan End With and I get "Object doesn't support this...

Hi, I converted an access 2003 mdb into an access 2007 accdb. The references checked are: - Visual Basic For Application - Microsoft Access 12.0 Object Library - OLE Automation - Microsoft ActiveX Data Objects 2.8 Library - Microsoft Visual Basic for Applications Extensibility 5.3 - Microsoft...