Having problems with Excel w/Macros saved to Dropbox

Slraynor

New Member
Joined
Mar 6, 2019
Messages
2
Hi my name is Sandy. I am trying to create an excel workbook that both my boss and I can access and edit through Dropbox. The file is an invoice with and A/R ledger. As of now I am the only one who can open the file in dropbox. When my boss tries to open the file he receives the following error message...

Excel cannot open the file GHAMasterInvoice.xlsm because the file format or file extensionis not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

This is what my macros look like as of now:

Sub Posttoregister()
Dim WS2 As Worksheet
Dim WS3 As Worksheet
Set WS2 = Worksheets("master invoice")
Set WS3 = Worksheets("AR Ledger")
nextrow = WS3.Cells(Rows.Count, 1).End(xlUp).Row + 1
WS3.Cells(nextrow, 1).Resize(1, 4).Value = Array(WS2.Range("e3"), WS2.Range("e4"), WS2.Range("c6"), Range("e36"))
End Sub




Sub NextInvoice()
Range("E4").Value = Range("e4").Value + 1
Range("b15:D34").ClearContents
End Sub


Sub Macropdf()
Posttoregister
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\users\sraynor\Dropbox (Legend's Hospitality)\SMA-FPA-TOY\SMA\Invoices.pdf", quality:=xlQualityStandard, includedocproperties:=True, ignoreprintareas:=False, openafterpublish:=True
Range("A1").Resize(44, 6).Select


End Sub

Sorry for the lengthy post as I am a novice when it comes to excel. I thank you in advance for your help.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
are you both using PCs with the same version of excel and windows
 
Upvote 0
I guess unless the drop box is joint ownership one is owner the other user (not that i use drop box)
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top