Recent content by sxschech

I've done printing to PDF using VBA in MS-Access, if the code is compatible to regular Visual Basic, I can try to locate it when I get back to the office. You will need to pass in the filename and pathlocation where to save it as a variable or hard code.

This video demonstrates how to use a button to switch between access files using Follow Hyperlink. In the video, he is using a switchboard (3 files rather than 2). Since you want to go directly between the two rather than a switchboard, I tried putting a button "Switch to A" in the Second...

Is the signature an outlook signature or a third party/add-in signature such as templafy? If an add-in sometimes even with html, it gets wiped out. For standard signature can also try this code. Function GetBoiler(ByVal sFile As String) As String 'Dick Kusleika...

What about another approach of having three entry fields and then use vba code or excel concatenate functions to combine and output the data. That way don't have to build a lot of logic to identify whether they used a slash or not.

If you prefer not to set a reference as shown in the screen shot from Andy, the alternative is late binding. Public Sub Rename() Dim fn As String Dim RegExp AS Object Set regExp = CreateObject("vbscript.regexp") 'Does not require a reference to Microsoft vbScript Regular...

I got three similar messages over the weekend and since I have a desktop without a camera and don't go to the kind of sites mentioned, knew it was fake and glad this thread confirms it. Before I switched to a desktop mail client when I used to use the web browser for outlook, there was an...

strongm, sorry for the oversight, you are correct. <smiley>ashamed icon</smiley> I think due to the additional discussions and examples, it didn't register that you provided the original solution. Hopefully it is rectified by the star. If not, please advise.

Contributing a new line of code before the refresh since I figured out how to adjust the range of the pivot table due to the latest refresh having less rows than the template and that caused the chart to display a literal blank. This is a hard coded statement per the comments, so it would need...

Looks like my screen refreshed whilst I was clicking on the post, meant to star Andy's post from 29 Aug 23 14:53 rather than 29 Aug 23 18:18 which must have come in while preparing and reviewing my reply.

Wow, great discussion. Thanks for the input. Andy, looks like your last post sorted it out. After adding objapp. before ActiveWorkbook, I was able to run the code multiple times without the error. I did a search [CTRL+F] for Current Project and that was the only spot where ActivWorkbook...

combo, first time through: Debug.Print ActiveWorkbook.Name displays: SubmittalsOverdueDataLeadChart_Template.xlsx Debug.Print ActiveWorkbook.PivotCaches.Count displays: 1 second time error 91 when it gets to the debug statement Case "Submittal Data" .Cells(2...

Upfront, letting you know I might not have explained well or need to provide more code for context... This question is using MS-Access to run vba to modify an excel sheet. Found this code to refresh data in pivot at https://www.automateexcel.com/vba/refresh-pivot-tables/ It seems to work fine...

Are you able to use CDO to send emails directly from Access without using Outlook? https://isladogs.co.uk/email-tester/index.html

I recall reading something about metadata in another access forum, haven't looked at it in detail or tried it so not sure if adaptable to vb script, maybe could help? Colin's web address changed so included a link to his site. https://www.accessforums.net/showthread.php?t=84076...

Is the file in a trusted location (Trust Center Settings)? Is it only the files that were copied or is there an issue with new files too?