Recent content by jandr272

I currently have 2 tables in a database that I'm trying to build a query off of. The first table lists personnel & their position #s, and the second table has a column for "rated person", "rater", "senior rater" and "reviewer" which are all part of our annual evaluations. I'm trying to program...

Re: Text to Columns in VBA returning "Object does not support this method" error You are the man (or woman)! Checking Excel and using Dim excelAPP As Excel.Application worked. Any idea why this worked in lieu of the other way? The other way would delete rows or select a column without a...

Text to Columns in VBA returning "Object does not support this method" error I am trying to format an excel spreadsheet through access, specifically trying to convert a column from text to dates (I receive the data in text format and need to translate it to dates). Dim excelApp As Object Set...

I see where I was mistyping your code, thanks for the clarification it definitely works now. Found a second way to skin this cat too, although I will use yours since it is much more streamlined. Thanks for all the help. excelWS.columns("A").Find("").select excelApp.activecell.entirerow.Delete...

Sub ExcelFormat() Dim excelApp As Object Dim excelWB As Object Dim excelWS As Object Set excelApp = CreateObject("Excel.Application") Set excelWB = excelApp.workbooks.Open("Z:\Data\Test.xlsx") excelApp.screenupdating = True excelApp.Visible = True Set excelWS = excelWB.worksheets("TestData")...

Figured that out right as you posted it! :D Now just need to figure out how to delete rows based on their contents. I need to select the first blank row and delete it and the 3 rows below it.

Sub ExcelFormat() Dim excelApp As Object Set excelApp = CreateObject("Excel.Application") Set excelWB = excelApp.workbooks.Open("Z:\Data\Test.xlsx") excelApp.Visible = True Set excelWS = excelWB.worksheets("TestData") excelWS.Rows("1:7").Delete It is working! Now just need to figure out...

I am trying to format a spreadsheet to import into a Table. To do this I need to delete the top 8 rows and then the 4 rows below the data I need, both areas contain header data. The 4 rows below the data I need are blank but formatted oddly and it is causing issues during import. I'm a complete...

Got it working, thanks a bunch!

[SOLVED] Converting text date to date date during import I am building a database using data imported from Excel workbooks. The dates in the workbooks are formatted as text in the YYYYMMDD format. Is there a way to convert this into date format during the import or after? I am pulling in a lot...

Hello all. I use Access at work (does anyone use it for fun?) mostly to try and track data from many different sources and provide my bosses the information they want in a way they can understand it. I wouldn't say I'm a novice, but I'm certainly not advanced, mostly I have learned by...