Unable to run excel macro after changing file name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After changing the filename in an excel macro, receiving Error number 5 -
Invalid procedure call or argument when users with excel 2000 run the macro.
Users with excel 2003 are not having this issue
 
Post the line of code that is causing the error.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Here is the macro code:

Dim Message, Title, Default, OperID, Response
Message = "Enter the PeopleSoft User ID of the person who ran the
report:"
Title = "Format Daily Hire Report: PeopleSoft User ID"
OperID = InputBox(Message, Title)
fName =
"\\OMACSAN01\PEOPLESOFT\Report_Output\user\Reports\DAILY-REPORT-" & OperID &
".CSV"

With Application.FileSearch
.NewSearch
.LookIn = "\\OMACSAN01\PEOPLESOFT\Report_Output\user\Reports"
.Filename = fName
Workbooks.Open Filename:=fName

After hitting 'Workbooks.Open Filename:=fName' is when we receive the error.
Thanks for your help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Baffled, can record macro, and then RTE5. Macro works fine on another PC. Excel2007 2
Excel 2007: Help creating a macro that will run Solver? 3
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Unable to change security in Excel 2007 1
Excel 2007 Macro w/ AppActivate = Run-time error '5': Invalid procedure call or argument 4
Reading Properties from Closed Files (Office and PDF) 1
Access 2007 Macro bombs when run with Access 2003 1
Macro for all Excel Workbooks to print to PDF 2

Back
Top