xlapp

I am getting a Compile Error: User-defined type not define. I had a freelancer develop this code for me (I am not smart enough to write this). Private Sub Command101_Click() Dim fd As FileDialog Dim ExcelRunning As Boolean Dim xlApp As Excel.Application Dim mywb As...

Hi guys, i am a newbie to vba and i am trying to copy several worksheets from a closed file into my current open one. the code is the following Sub Import() 'copy data from closed workbook to active workbook Dim xlApp As Application Dim xlBook As Workbook Dim wb1 As Workbook Dim Sh As...

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

With this code : Sub TEST() Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Set xlApp = New Excel.Application xlApp.Visible = False Set xlBook = xlApp.Workbooks.Open( "C:\temp\pippo.xls" ) Stop xlBook.Close SAVECHANGES:=False Set xlSheet =...

Hello, I have a Macro launched automatically every x minutes that refreshes a couple workbooks stored on a SharePoint site. It opens every workbook in a new Excel Instance (not simultaneously) via the Shell function, so that if one instancefails (for example an error message popping), the other...

Hi, Having issues writing the below and getting it to work. I want it to be able to use a cell in an excel document to determine which file needs to be picked up, it's currently opening the dialog box where I'd usually select the folder, but not selecting the relevant file automatically. The...

I use this code in Access to draw a timeline and freeze panes in Excel - so the commands are for the Excel enviroment - that's why I'm asking here. Sometimes it runs into error 1004 in the marked line: Private Sub bygTidslinien(st As Integer, d As Boolean) Dim xlApp As Object Dim wb As...

I execute this code (only part given here !): Dim FSted As String, FDato As String, DSted As String, DDato As String Dim xlApp As Excel.Application Set xlApp = GetObject(, "Excel.Application") AppActivate xlApp...

Would someone please explain why the Excel process continues to run even after Closing and Quitting. From my limited understanding I thought sourceWB.Close & xlApp.Application.Quit would do the trick. What Am I missing? Private Sub UserForm_Initialize()If TimeCard.tbEmployeeID.Value = "" Then...

Hi, I have a function that opens files and does not have much problem except it cannot seem to open excel files while my modeless userform is open. If my userform is not open then for some reason it works. So to get around this I want to use wildcards to catch any type of excel file extension...