Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Opening files on network drives within a macro.
I'm trying to open specific files from network drives, but I can't use specific addresses for the files... I'll explain, but here is the code I'm using: if checkfile("Counterparty Report.xls") then else workbooks.open filename:="Counterparty Report.xls" end if This works when the the...- mattst
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Concatenating a cell address with a formula....
For anyone who's willing to help out a beginner... I'm trying to insert a formula in a cell as part of a macro but I can't seem to get it to work. This is the code I'm using to do that. cell4.FormulaR1C1 = "=RC[-2]/" & cell3.Address Which gives me an error. However, if I do this, I get no...- mattst
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
