Recent content by HelpTheNewbie

I set up some code that allows a user to import an Excel file; however one format that will be imported has a variable worksheet name... This is what I have so far, but it depends on the user setting the sheet name to "Sheet1" prior to import... Set appExcel = GetObject(ImportFile)...

Okay. I have the full version of Adobe. How can I do what this one user suggests? "set that printer as the special printer for that report (and save it in design view)" Thanks so much for your help!

I am running VBA code attached to a button on a form. Among other things the button imports and Excel file and then asks if the user would like to view a report of the imported data. I would like to allow this to be exported to PDF format, but can't quite seem to get the syntax or something...

No. I am running 2003... I checked again. I apologize - i found 11.0 and now everything seems to be working. Thanks so much for your help!

That's what I thought. Maybe then I don't understand how to add the "Microsoft Office 2.0 Object Library". I went to Tools > References > and then checked the box next to this option... When I try and declare the variable "As FileDialog" I get a compile error. Is there a step I am missing...

Would someone be able to help me with this post? http://www.access-programmers.co.uk/forums/showthread.php?t=121004 Thanks so much!

FileDialog Box Dear Moniker: Thank you so much for all of the information you have posted - it has been extremely helpful. I have one quick question, which you can chalk up to my Access ignorance. Can you please elaborate on "will expose the FileDialog object. From there, you need to...