Kelly Armstrong
Last Activity: Jul 23 '11, 12:02 AM
Joined: May 12 '11
Location: Milwaukee, Wisconsin
-
Unfortunately, the size of the data on each worksheet varies and so to eliminate blank results from being imported, I need the code to find the last used cell and import everything up to that point. -
Ok, I added the .xls, now the code runs through until the point where it is supposed to find the last used cell in each worksheet. The error code I get is : "Run-time '91': Object variable or with block variable not set. Then it highlights the noted line of code and dies.
...Code:Public Sub importing() Dim excelapp As New Excel.Application Dim excelbook As New Excel.Workbook Dim excelsheet As New Excel.Worksheet
Leave a comment:
-
Well since I first posted this I have spent a lot of time working on it. It still will not function properly though. When I try to step into it, it stops at the highlighted line of code and give me this error: Run time error 1004. Excel cannot access '2011 Rigidity' The document may be read only or encrypted. But the document is not read only nor encrypted. This is what I have so far:
...Code:Public Sub importing() Dim
Leave a comment:
-
I am assuming that you need to have different reorder levels for different items.
One option would be to create a table with the minimum inventory amounts for the different items (this could also be added to an existing table), then run a query finding the items that are below that amount (you should include the SQL in the vba code), then using an If statement you could use vba code to have a message box appear instructing the user...Leave a comment:
-
Import Multiple Sheets From Excel Into Access
Hi,
I am very new to VBA and am trying to set up an import from excel into access. Both are the 2010 version. I pulled the code I am using from a previous thread posted by a user trying to do what I want to do. The problem I am having is that every time I try to run the code I get a message saying "Compile Error: Invalid Outside Procedure" and the file path is highlighted. Any advice on what I am doing wrong would be...
No activity results to display
Leave a comment: