Recent content by GiSquared

JHB you rock...it worked (at least on the first one...should work for the rest). I did make one change though. Instead of: oApp.ActiveWorkbook.SaveAs oApp.ActiveWorkbook.FullName, CreateBackup:=False (I got an error here) I did this oApp.ActiveWorkbook.SaveAs FileName:="C:\Your File...

This is how I wrote it with the path oApp.ActiveWorkbook.SaveAs oApp.ActiveWorkbook.FullName, p<path file name is here>, CreateBackup:=False

Ok...got a tad bit further...thank you for helping... now its stopping oApp.ActiveWorkbook.SaveAs oApp.ActiveWorkbook.FullName I am getting a new message now... Run-Time Error '91' Object variable or With block variable not set I tried to put in the path and file name...but that didn't...

Ok...when I run the script with XLApp lines I get "MICROSOFT VISUAL BASIC" popup window with "RUN-TIME ERROR '424': Object Required" Then buttons "Continue"(Greyed out) "End" "Debug" "Help" I hit Debug The highlighted line is "XLAPP.DisplayAlerts = False"

Thank you but it won't let me run the XLApp with the o.App The program keeps stopping there.

I had to remove the c:\folder\filename links until I have 10 posts... so know that I have a proper link and file name. Sorry.

I am ok on my VBA, I had an old code that was great for exporting to Excel on my C: drive and formatting the excel sheet. It has never done this before, but all of a sudden, the code is making 2 files. The desired *.xlsx and a backup*.xlk file. While the backup file doesn't accumulate when I...

Hello, My name is Jeanie Burdi From Maricopa, Arizona... My career-Project Scheduler My goal - Business Owner (I own Battlefield Live Arizona, Mobile Laser Tag Company) My family - Husband of 26 years (Mike) Son 20 years (Josh) Been playing with Access and Excel since 1997...now known as an...