Search results

Used a lot of API calls in my last environment. As said, it is necessary to check for 32/64 bit. The biggest problem comes into the testing of them across various platforms. Some of my API calls that worked great on the desktop, just would not work on Windows Servers for example. Since you...

UPDATE: Found a workaround that reduced the need to try this. If anyone tries it later, send me PM and I will mark it as Solved Does anyone have experience in creating a mapped network drive from MSAccess? Any other suggestions over the code listed below? On my schedule is the ability to Map...

Well, SIR Doc, your ancestors stayed ahead of the outcome. It is interesting how many of us Heinz 57 (http://www.urbandictionary.com/define.php?term=heinz%2057) have ancestry across the pond. After looking at Ancestry, would also love to go back to walk in the footsteps of my family. Just the...

This weeks Housing report: http://www.theweek.co.uk/house-prices/61987/house-prices-see-abrupt-reversal-in-momentum "Nationwide reports first monthly dip for two years and a sharp fall in annual growth rate" OK, but to be fair, they didn't mention your name and that your moving there was the...

How about some of us in the States chip in to set up a multi-room Skype VIDEO chat (or other service) so we can all have a toast together. The only reason a paid service is mentioned is because the free ones don't always seem to work that well. We want the least time-delay lag since Colorado is...

Burger King's Single Fries https://www.youtube.com/watch?v=mheyvx1kVJQ Burger king's Whopper Toothpaste https://www.youtube.com/watch?v=-fCRqsQBvPY Virtual Reality YouTube https://www.youtube.com/watch?v=DPEJB-FCItk&list=PLud_6cB_H2NVSD6sq1LH9ITo18qRoBOEl Down under...

I am going to submit the Guardian stories. These are great! https://www.theguardian.com/theguardian/2017/apr/01/fake-news-the-best-and-worst-april-fools-day-stories “Science correspondent” Rollo Piaf (no prizes for unscrambling the anagram) reports that a polar bear is living on a Hebridean...

I totally disagree: People have learned nothing, the Internet has just dummied down people. The internet has only increased the tolerance and acceptance for bad behavior so now horrible behavior is the new "normal" Back to the Brexit, and other movements like it, is it the internet or is it a...

Re: Then why does he keep promoting those cronies to his cabinet? By "He" we mean all Presidents since President Jimmy Carter. It is an American Tradition borrowed from ... well everywhere else. Although Americans would like to stamp promoting cronies with a "Made in the USA". :D In 2016...

Here is yet another number to memorize, 218 Evidently, when Excel uses a Link to another workbook / worksheet in a formula, the string length of the worksheet is reserved as part of the total SaveAs Path Length. For Excel VBA remote automation from MSAccess code, the handshake is not pretty...

Glad you found the solution. Being specif about the workbook referenced is easy to miss. Filling in the answer will help others who are searching for a solution later. Please feel free to use the Thread Tools and mark your post as [SOLVED]. And, also feel free to post the key parts of the entire...

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.