VBA Excel method Not working

		Microsoft Office Forums > Microsoft Excel > Excel
VBA Excel method Not working

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-07-2022, 11:19 AM

p45cal

Windows 10 VBA Excel method Not working

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

Shouldn't those forward slashes be back-slashes?
I don't think Excel will recognise xlsm as a fileformat. Try either xlOpenXMLWorkbookMacroEnabled or 52 or miss it out altogether.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel stopped working.	nodsirrah	Excel	9	07-01-2017 04:58 AM
vba error method or data member not found in excel 2010	Rose roon	Excel Programming	0	09-08-2015 03:51 AM
Is using and Excel Table to be accessed by other Office Programs the best Method??	feychylde	Excel	0	05-24-2015 12:30 PM
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC	Story11	Excel Programming	37	01-26-2015 09:34 PM
Excel error window: Excel has stopped working	MunganBrus	Excel	1	01-13-2015 11:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:04 AM.