Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with automating spreadsheet containing VBA code
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00736099
Message ID:
00903325
Views:
18
Add a line to activate the Sheet. Otherwise focus remains on the first sheet and it somehow tricks Excel with what is selected on the first sheet:
	with OExcel.Worksheets(isheet)
		.Activate
                .......
>Ok. I have sent the files
>Thanks so much
>Steve Elster
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform