Recent content by jamsta

DJKarl, Spot on - I've got this working perfectly! Thanks very much for your help, you've helped make my life that little bit easier.

Thanks DJ, I gave this a go. Zip folders are associated with Windows Explorer on my PC. So when I put fFindExe back into the UnZip_ZipFile sub, it just opens the window. Now if you open a zip folder you can copy the contents and paste elsewhere, and that extracts the files. So I also tried...

Sorry Stopher I'll be more specific. Yes I have winzip installed but it's not in the default location in Darth Vodka's code: If Dir(PATHWINZIP & "winzip32.exe") = "" Then MsgBox "Please find your copy of winzip32.exe and try again" Exit Sub End If so I get the error...

Hi all, I would like some code that extracts a file from a zip folder, renames and saves to a specified location. I've tried the code posted by Darth Vodka http://www.access-programmers.co.uk/...d.php?t=144356 but it gets stuck at the point of checking for the existence of Winzip. Any fresh...

Thanks Doc Man.

Hi all, I realise that this is an old thread, but hopefully I can kick it off again. I would like some code that extracts a file from a zip folder, renames and saves to a specified location. I've tried the code posted by Darth Vodka...

All, I've found it... I should have had: .ActiveWorkbook.SaveAs strDBPathAndFile & "\Inputs\PBL.xls", FileFormat:=xlNormal You see - it's inspiration enough just to post on here, even if I knew the answer all along!

Hi all, I am after some code that will convert a csv file to an XLS file. I have made a start with the help of some older posts on this forum and elsewhere. Currently I have this: Sub test2() strDBPathAndFile = CurrentProject.Path Dim XLApp As Object Set XLApp =...

You've nudged me right into the solution - that works a treat. Thanks again.

That makes sense, but I'm struggling with exactly how to do it. I have this in my Excel code: Dim oApp As Object Dim LPath As String 'Path to Access database LPath = "C:\Users\My Documents\My_DB.mdb" 'Open Access Set oApp = CreateObject("Access.Application")...

Thanks again for the advice. Delayed reply... but I've looked at the snippets now and I've got this working how I want it to work. However.... related point: Is it possible to run some some code in a module in Access, from Excel? I've got data in a table that's maniupulated by some code in...

OK, thanks for that - I'll have another look and take your tips on board. Yes Java was the first language I tinkered with - so it seems I speak VBA with a Java accent!

Thanks for the link. I can't find anything there relating to my specific issue but I've bookmarked it because it's obviously a useful resource. I've been tinkering some more. The version of the code I posted is misleading because the offending line is commented out. The problem seems to be...

Hi all, I am trying to learn how to read from and write to specific cells in an Excel spreadsheet, from a VBA module in Access. This is my first try at this and I am currently playing around with some code and ideas. All it does so far is run a sub to tell me what's in a particular cell in...

Hi all, I have this line of code: DoCmd.TransferText acExportDelim, , "tblLetterContent", strDBPathAndFile & "\Exports\LETTERS.csv", True This works fine. However, I wanted to export to the csv file without double quotes around each element. So, I exported manually and created the export...