Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2012, 02:01 AM
jillapass jillapass is offline switching windows for variable file name Windows 7 32bit switching windows for variable file name Office 2007
Novice
switching windows for variable file name
 
Join Date: Dec 2011
Posts: 26
jillapass is on a distinguished road
Default switching windows for variable file name

I have a template that users open.
They enter details then press a button, enter a file name and save the file.
The macro then switches them to a different file todo some more processing.
I want to be able to switch back to the file they saved.

The command I have is below, but I want to switch to whatever they entered when they saved the file.

The name they save to is 'myfilename' and I want to switch to that one whatever it is called.


Thanks



Code:
windows("test.dotm").activate
Reply With Quote
  #2  
Old 04-21-2012, 02:59 AM
tinfanide tinfanide is offline switching windows for variable file name Windows 7 64bit switching windows for variable file name Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default

I don't know if I've got your message right.
But I've tried in this way. Please see the attachment:
temp1.zip
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
switching windows for variable file name Automatic Switching of Portrait to Landscape Headers Cris4py Word 1 03-15-2012 01:21 PM
Switching between 2 accounts Night Train Outlook 5 02-20-2012 10:02 PM
opening office file deletes copied text from windows clipboard linadze Office 11 02-03-2012 10:35 AM
Switching text on either side of hyphen nignog Word 1 01-23-2012 01:13 PM
Switching between Profiles elsinore Outlook 1 09-21-2008 10:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft