Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Disabling the Save button in the "File"drop down. Also when attempting to close file. Exce
I have developed a data application in Access and, using a Macro in Excel, import the selected table into Excel. The Excel sheet has formulas and text that need to stay there every time it is used. The idea is for the user to import the data and save it to a new, dated file. I cannot have...- B Shirk
- Thread
- Replies: 14
- Forum: Microsoft: Office
-
Closing MS Access
thread181-510401 I have searched high and low for a solution to this. I have a macro in Access that will open Excel and a specific excel file. Works OK (See code below) ==================================================== Function OpenExcelFromAccess() Dim MyXL As Object Set MyXL =...- B Shirk
- Thread
- Replies: 6
- Forum: Microsoft: Access Other topics
