xlwb

I want the code to get the path from an access table. Table Name= (tblExportsImports) Field Name = (DailyReport_Export) Example: Set xlWb = .Workbooks.Open (tblExportsImports.DailyReport_Export) Code: Private Sub cmdSummaryReport_Click() DoCmd.SetWarnings False...

Hello all, I updated a macro that had been created by a previous resource, and now when I call the macro in my Access DB I am receiving a "Run-time error '438': Object doesn't support this property or method'. I'm confused because I use the same late-binding references in all my forms. Also...

Hi, I am using the code below to print documents, I want to be able to force it to print to a specific printer. Several people use this and we are all set up to different default printers so I want it to print out at a specific printer without having the change our printers. Can this be done and...

Hi, I am running a VBA in excel, I have a list of documents that the VBA finds and prints without me having to open and print each document individually. All of the documents are in .XLS format. When I run the macro, the sheet prints but it is too small, more like A5 size rather than A4. If I...

Hi, I am using the script below to print files in a specific location from excel, but the sheets are not printing in A4, they're about half the size they should be, can anyone please spot why? if I print the documents manually they are fine, but priting from the VBA is causing an issue. Thank...