Recent content by pcrody
-
P
create a macro to export to an excel file using the current date as a name
again and again and again... I did. It didnt work. -
P
create a macro to export to an excel file using the current date as a name
Im not sure what you mean. Its a very large db. Besides being confidential. I found an option to convert the entire macro to VB. Now how do I run a module from the switchboard? Ok, nvm. I got it. I would still like to know how to run a module in a macro. But, as long as I found that... -
P
create a macro to export to an excel file using the current date as a name
The name of the module is "module2" the name of the function is "ExportToExcel". -
P
create a macro to export to an excel file using the current date as a name
Ok, I used RunCode, function: ExportToExcel, and removed the "private" from module2 (Sub ExportToExcel()). But when I run the macro, it says it cannot find the function "ExportToExcel". OH, how do I made the module a function? OK, I changed module2 to: Function ExportToExcel().... End... -
P
create a macro to export to an excel file using the current date as a name
Sales Macro: ImportExportSpreadsheet (Import, Excel Workbook,Sales) OpenQuery (2013 Sales Make Table Query) OpenQuery (Sept Sales Append Table Query) OpenVisualBasicModule (Module2, ExportToExcel) MessageBox (Macro Complete) StopAllMacros Is that what you need? I've tried... -
P
create a macro to export to an excel file using the current date as a name
I have a macro in Access that exports a table created. I am using a module to add the date on the filename. The macro runs, but the module does not run. It just opens up in VB, and the macro finishes. I can then run the module and it will change the filename and save it, but it will not run...