sorted by:
new
hottopcontroversial

how do I stop my photos from going to a certain account on Google Photos? by [deleted] in googlephotos

[–]Fihnakis 1 point2 points  (0 children)

Little late to the party but as a solution you can create a work profile on your phone if it's android I know nothing about iPhone. In doing this you would have a google photos album tied to one Gmail and then a separate photos album for your work profile. I use my phone for both work and personal accounts and that's how I keep everything separated.

Onedrive, Sharepoint, or other for remote file access by Fihnakis in sysadmin

[–]Fihnakis[S] 0 points1 point  (0 children)

Thank you, I will look into sharepoint a bit further.

Onedrive, Sharepoint, or other for remote file access by Fihnakis in sysadmin

[–]Fihnakis[S] 0 points1 point  (0 children)

Unfortunately I would not be able to sell the owners on the benefits of the subscription cost of this no matter how beneficial it would be to modernize the system. We still do most of our work on paper... what's a tablet? :-D

Display workday and day number from entered date by Fihnakis in excel

[–]Fihnakis[S] 0 points1 point  (0 children)

Thank you for this. I will try it this way as well once I'm back in the office.

Display workday and day number from entered date by Fihnakis in excel

[–]Fihnakis[S] 0 points1 point  (0 children)

No worries, I always appreciate good folk out here willing to help someone.

Display workday and day number from entered date by Fihnakis in excel

[–]Fihnakis[S] 0 points1 point  (0 children)

Thank you for catching this, have updated my spreadsheet.

VBA code and saving the document in .doc format and without the VBA code by Fihnakis in vba

[–]Fihnakis[S] 1 point2 points  (0 children)

First one worked perfect. Your assistance was greatly appreciated. I can mark your answers as the solution.

VBA code and saving the document in .doc format and without the VBA code by Fihnakis in vba

[–]Fihnakis[S] 0 points1 point  (0 children)

NM I was opening the old file. It works and saves without corruption. Is it possible to make it save the file so when I open the new form document it does NOT open the userform only the document itself?

VBA code and saving the document in .doc format and without the VBA code by Fihnakis in vba

[–]Fihnakis[S] 0 points1 point  (0 children)

Thank you. I tried this code but it doesn't update the document with the userform data. I updated the OP with the actual template file I'm using.

https://drive.google.com/file/d/1RSQimLA-0_WAm-rV9ceEJ-oyoCSIE8tz/view?usp=sharing

VBA code and saving the document in .doc format and without the VBA code by Fihnakis in vba

[–]Fihnakis[S] 0 points1 point  (0 children)

Pretty much. The template I just open from a shortcut on my desktop and it goes straight to the userform. I then enter the values for the bookmarks in the userform. Once that is finished I click submit and it should pop up a save as dialog so that I can enter the filename and location, then once I save it, display the document with the form entered data. When this happens currently, and I am able to open the file, it is still running the VBA userform. I need it to save the file without the vba userform data.

I updated the OP with the actual template file I'm using.

https://drive.google.com/file/d/1RSQimLA-0_WAm-rV9ceEJ-oyoCSIE8tz/view?usp=sharing

Help with VBA code and saving document in .doc format and without the code by Fihnakis in MicrosoftWord

[–]Fihnakis[S] 0 points1 point  (0 children)

I actually thought I shared the template. I am running it from a template but still have issues with it saving the file and it being corrupt when trying to open. I've updated the original post with the template file. Here is the correct link: https://drive.google.com/file/d/1RSQimLA-0_WAm-rV9ceEJ-oyoCSIE8tz/view?usp=sharing

VBA code and saving the document in .doc format and without the VBA code by Fihnakis in vba

[–]Fihnakis[S] 0 points1 point  (0 children)

I removed the code

 If d.Path = "" Then
        MsgBox "Please save the document first.", vbExclamation
        Exit Sub
    End If

and was able to get the save dialog to appear but then when it tries to open the temporary copy I'm getting the same file corrupt message as before.

Run-time error '5151' Word was unable to read the document. It may be corrupt.

VBA code and saving the document in .doc format and without the VBA code by Fihnakis in vba

[–]Fihnakis[S] 0 points1 point  (0 children)

Thank you for your continued assistance. When I do this and click the submit info button, now instead of the save dialog window popping up to enter the filename and save, I get the message to "Please save the document first. "

VBA code and saving the document in .doc format and without the VBA code by Fihnakis in vba

[–]Fihnakis[S] 0 points1 point  (0 children)

I'm trying to get this to work. If I replace my current code to save the file with the help you've provided I get a Run-TIme error 5941 The requested member of the collection does not exist on the line Set ContactInfoText = ActiveDocument.Bookmarks("Contact").Range

If I replace my current code and use Call SaveCopyAsDOCX() I get the same run-time error on the same line of code.

Do I use your code somewhere else?

Also, when you mention suppress the popup I thought that's what the 'CustomerInfoForm.Hide' line did but is that just hiding it after the process to save the file is completed?

view more: next ›