Search results

So correct - after a scope change - this is working code. Will be adding more constants and other improvements. However, this should provide an idea of how to check down the directory path and create a new subfolder as dates change. ' Public Function to SaveAs into network directories and...

Thanks for the complement. Just to add a little more: When using visible = true The code should close the workbook and even leave the Excel frame (empty). Then use the Excel.Quit (see code below) This is code out of the project in front of me Note: I use ObjXL as the object set to...

Found several code samples to start. If anyone has suggestions for creating a multi-tier directory structure for a SaveAs - please chip in. Sorry, had a last minute design change - nobody responded so will update the requirement and code. Will add more code as day progresses. Output: General...

Didn't really have time to look at all the thread. Looks like it was solved. The takeaway is to make sure any Excel method is qualified with the object reference, even if it is part of the parameters. As I suspected the REPLACE is an Excel method. It is not preceded with the Excel object (dot)...

Just wondering if anyone had recent experience with MZ Tools. Used it for years at one assignment, but it has been a year now. Saw there was a new version. https://www.mztools.com/blog/ The VBA tool was updated in Jan 2017. Will hope to install trial today if system admin allows. Of great...

Not sure, but suggest looking at the Excel Object Model (F2 Object Browser in code module) to determine if the object model for charts or other objects changed. Seem to remember there was a change at some point, but that was too long ago.

tried to join, the conference number was dead. The Skype for Business to click on for my Windows 10 Pro wouldn't work at all. Sorry I missed it. These were a couple of historical stories. When this episode shows up, I will provide the Movie Critic short version. I come from a POV of writing SQL...

http://www.appspro.com/Utilities/Utilities.htm Found this, must try at home before installing on production device. Looks interesting. Does anyone else have Excel Utilities to share?

Agreed, a good choice would be to analyze data in MS Access first. Then, use one of the many ways to transfer the data into Excel.

Just had to share this, spent way more time than expected for a simple solution. Started a question, then found the answer mid way. Access code automating Excel where ObjXL is an object that is set to Excel.Application The Excel workbook has FreezePanes on column F other sheets might be G or...

The MSAccess calls a SP that runs a significant amount of code and creates tables. The Tables are the Linked Tables in MS Access. After the tables are refreshed on SQL Server, a MakeTable is run to get the data over to MSAccess quickly. From there the Access vba code uses Excel Object Model...

That worked perfect on a workbook in a macro. Added many rows of Formatting below the last row with data. Will have to try this in other code such as Sorting and Grouping. Thanks for the tip!

Just wondering if anyone knows of a shortcut or shorter solution to this issue? Problem: Using a Template or existing Excel Workbook with headers, all the formatting ready to go. Then use MSAccess code (set ObjXL as Excel.Application) to automate custom data and use CopyFromRecordset to populate...

Search DAAUG Just learned about this today. What is in store for MSAccess? Thought I would share. Join us on March 14th with our guest Michal Bar, Microsoft Access Program Manager at Microsoft! Learn about the future of Access, see demos on new features the Access team has worked on and get...

In the past, my code demonstrated using Excel object code from MS Access for remote automation. The recommendation is to turn off (xlManual) the calculation when dumping big amounts of data into an Excel worksheet then using vba to insert custom Formulas in cells to work with the data...

Sorry to apply so late, have some big deadlines on my side of the Pond.... While this won't directly answer your question, it might provide another way to sort and copy the results to another worksheet. This is only code segment, but it might give some ideas about SpecialCells. It is just a...

Saw this in my email - thought it had some interesting topics. Given the strength of the USD, I wish I wasn't so busy on a contract. Could probably actually afford to go there given the exchange rate. Hope they have a video or other media after the event. Some of the subjects look very...

This is the Sorting and Grouping part of that develops an Excel workbook Budget Forecasting Analysis tool. The end workbook has zero VBA. Basically the ObjXL is a reference to Excel Public ObjXL As Excel.Application The iStartRow is a reference to where the Public DB As DAO.Database Public rs2...

The macro recorder won't replay a Group and Subtotal. It requires a custom macro update with a custom Array. I will try to post that here when I get a break today.

Using MS Access with reference to Excel Set OBJXL as Excel.Application In a reporting system with Access Linked Tables to SQL Server Then using code for custom Sorting and Grouping The result of the Grouping (where Subtotals formula appear) are not bold in the Grouping Rows. I use to use...